The Period Close Reconciliation Report does not currently have any identified performance issues. In release 11.5.10 we have actually moved the entire period summarization logic to this report to allow users to run the process separately (or not at all, if they do not use our summarization feature).
That is why this report is taking a long time, whereas previously the close process itself was taking this amount of time.
Yes, it is possible to run the program independently. You can run the Period Close Reconciliation Report at any time just like a normal report. As you have stated, if it is run on a "Closed not Summarized" period, it will
summarize and the status will go to "Closed" after the report completes.
If it is run on a "Closed" period, it will simply pick up the summary information previously calculated. If it is run on an open period, it will run through a simulation of the summarization (can detect any potential
errors before closing for real).
Please note that a "Closed not Summarized" period is treated by Inventory in exactly the same way as a "Closed" period (transaction entry not allowed). In addition, the accounting would have already been transferred to GL in both cases. The only thing different has to do with the availability of summary
information. This information can be queried through the Accounting Periods
form or through the Period Close Reconciliation Report.
NAVIGATION
1. Responsibility: Cost Management
2. Goto View > Requests > Submit New Request > Single Program
3. Enter Period Close Reconciliation Report.
4. Enter the parameters and submit.
Thanks & Regards,
S.Grace Paul Regan
Wednesday, May 11, 2011
Tuesday, March 8, 2011
INTER ORGANIZATION TRANSFERS
INTER ORGANIZATION TRANSFERS
Scope and Application
This document is intended for users of Oracle Inventory applications. This document does not address the accounting distribution for inter - organization transfers.
Note: Items must be defined in both organizations in order to be able to transfer
INTER ORGANIZATION TRANSFERS
You can define multiple inventories, warehouses, and manufacturing facilities as distinct organizations. With Oracle Inventory you can perform inter–organization transfers as direct or intransit shipments.
You can transfer one or more items in a single transaction. You can also transfer partial quantities of the same item to different subinventories and locators in a single transaction. The items you transfer must exist in both organizations. You can also transfer expense and asset items from one organization to another using intransit inventory.
Direct Inter–organization Transfers
You can use a direct inter–organization transfer to move inventory directly from a shipping organization to a destination organization.
The validity of a transfer transaction depends on the controls you have defined in both the shipping and destination organizations for the items you want to transfer.
For example, you can transfer item A from organization X to organization Y, even though item A is under lot control only in organization X (you can specify the lot numbers for item A in organization X during the transfer transaction). However, you
cannot transfer item B from organization X to organization Y if item B is under lot control only in organization Y (you cannot specify lot numbers for item B in the destination organization because you are performing a direct transfer).
Inter–Organization Transfers via Intransit Inventory
You usually transfer material to intransit inventory when transportation time is significant. When you perform the transfer transaction, you do not need to specify the delivery location. You only need to enter the subinventory you are shipping from, a shipment number, the freight information, and, depending on the inter–organization transfer charge that applies between the organizations, a percentage of the transaction value or a discrete amount that Oracle Inventory uses to compute
transfer charges.
If the FOB point is set to Receipt in the Shipping Networks window, the destination organization owns the shipment when they receive it. If it is set to Shipment, the destination organization owns the shipment when the shipping organization ships it, and while it is intransit.
While your shipment is intransit, you can update shipping information such as the freight carrier or arrival date in the Maintain Shipments window. See: Managing Shipments, Oracle Purchasing User’s Guide.
At the time of shipment, you must define your receiving parameters for the destination organization. You can receive and deliver your shipment in a single transaction or you can receive and store your shipment at the receiving dock. See: Receipts, Oracle Purchasing User’s Guide.
The validity of a transfer transaction depends on the controls you have defined in both the shipping and destination organizations for the items you want to transfer. For example, you can transfer item A from organization X to organization Y, even though item A is under lot control only in organization X (you can specify the lot numbers for item A in organization X during the transfer transaction). You can also
transfer item B from organization X to organization Y if item B is under lot control only in organization Y (you can specify lot numbers for item B in the destination organization when you perform the receiving transaction).
Transferring Between Organizations
You can transfer material from your current organization to another organization, or from your current organization to intransit inventory.
Material in intransit inventory belongs to the organization identified by the FOB point. See: Defining Inter–Organization Shipping Networks.
Prerequisites
Define an inventory item that is common to both organizations. See: Defining Items and Assigning Items to Organizations. Define at least two organizations, one of which is valid to receive material from the other. See: Creating an Organization, Oracleand Defining Human Resource Management Systems User’s Guide
Organization Parameters.
Set up inter–organization relationships and their corresponding accounts. See: Defining Inter–Organization Shipping Networks.
For direct transfers, if the item to transfer is under serial number control, the item must have the same unit of measure in each organization. See: Defining Items.
To enter the information to perform a transfer between organizations:
Navigate to the Inter–organization Transfer window.
Enter the date of entry for the transaction.
The date you can enter is controlled by the INV:Transaction Dateprofile option. See: Oracle Inventory Profile Options.
Validation
Enter an organization to which to transfer the material. You must first define this organization as valid to receive material from your current organization. See: Defining Inter–Organization Shipping
Networks.
In addition, if this organization uses intransit inventory, Oracle Inventory stores the material as intransit inventory when you transfer any material to this organization. You must then move the material from intransit inventory to this organization with an intransit inventory receipt.
Enter a transaction type. This can be either a predefined system type or one you defined. See: Defining and Updating Transaction
Types.
Optionally, you can enter the source of the transaction type. See: Defining and Updating Transaction Source Types.
Indicate if inventory information should be defaulted from the serial number.
Enter any optional Shipment information.
Optionally, you can enter the following Shipment information:
To enter the items to transfer:
Choose Transaction Lines from the Inter–organization Transfer window.
Enter an inventory item to transfer.
You can transfer the same item more than once. For example, you can specify an item more than once to transfer partial quantities to different subinventories or stock locators.
For a direct transfer, if the item is under revision control in either organization, enter a revision that is common to the item in both organizations.
Enter a subinventory from which to transfer the material.
Optionally, enter the subinventory to which to transfer the material.
You must enter a value in this field for direct inter–organization transfers.
If you established locator control for the item, enter from and to locators.
Enter a lot number for the item. If you want to enter multiple lot numbers, complete the remaining steps, then choose the Lot/Serial button to display the Lot Entry window. For receipt transactions, if you enter a lot number, enter the date the lot expires. You can enter a value here only if the Lot Expiration (Shelf Life) Control attribute is set to User–defined Expiration Date.
Enter a unit of measure. This can be the primary unit of measure(the default) or any valid alternate unit of measure. If you enter an alternate unit of measure, Oracle Inventory issues the quantity you specify in this unit of measure. Oracle Inventory also converts the quantity to the primary unit of measure so that it can correctly update the on–hand quantity.
Enter the quantity of the item to transfer.
Optionally enter a reason code for the transaction. For example, you can use reason codes to allow you to mark exceptional charges to support a quality data collection and reporting system. You can also enter up to 240 characters of free text in the Reference field that describe the transaction.
To enter internal transfer charges to assign to the To organization:
_
Enter a value in the Added Value field that represents the transfer
charge. You can enter a value here only if you entered Requested value in the Inter–Organization Transfer Charge field in the Organization Parameters window.
Enter the percent of the transaction value that represents the transfer charge. You can enter a value here only if you entered Requested percent in the Inter–Organization Transfer Charge field in the Organization Parameters window. Defining Inter–Organization Information.
To enter freight information costs to assign to the From (current)
organization:
Enter the transportation cost to physically transfer the material; that is, the freight carrier charges.
Enter the general ledger account to which to charge the value you entered in the Transportation Cost field. Oracle Inventory displays the account you defined for the freight carrier as the default. See: Defining Freight Carriers.
To enter a unit number:
If Oracle Project Manufacturing is installed and if you have enabled its end item model/unit effectivity feature, you can enter a unit number for the item. See: Model/Unit Effectivity, Oracle Project Manufacturing Implementation Manual. Note: The Unit Number field is visible only if you have installed Project Manufacturing.
To enter lot or serial number information.
Choose the Lot/Serial button. See: Assigning Lot Numbers and Assigning Serial Numbers.
To view quantity available and quantity on hand values:
Review the following fields: Available: Displays the quantity available to transfer, based on the unit of measure you specified. The available quantity is the quantity on hand less all reservations for the item. This amount could include the amount you have reserved if you enter a transaction source that has reservations against it. The available quantity includes reservations against current transaction source. The available quantity is specific to the revision level, lot number, From
subinventory, and From locator you specify for the transfer. On hand: Displays the current on–hand quantity for the item, based on the unit of measure you specified. The on–hand quantity is specific to the revision, lot number, From subinventory, and From locator you specify for the transfer. On–hand includes quantities for pending transactions in the MTL_MATERIAL_TRANSACTIONS table.
To process the transaction:
Save your work.
To record movement statistics:
Use either of the following methods to record and maintain information associated with the movement of goods: Navigate to the Movement Statistics window and record information manually. See: Entering Movement Statistics. Automate the collection of this information by setting up parameters in the Movement Statistics Parameters and Economic Zones windows. See: Defining Movement Statistics Parameters and Defini
•A shipment number to uniquely identify an item or group of items to transfer. When the To Org uses intransit inventory, you must enter a value here.
•The freight carrier for the transfer.
•A waybill or airbill number for the transfer.
•The number of containers in which the material is stored for the transfer.
•The date you expect to receive the material at the destination organization. You must enter a date equal to or later than the current date. Oracle Inventory uses this date for reporting purposes only.
Content from Oracle Metalink
Thanks & Regards,
S.Grace Paul Regan
Scope and Application
This document is intended for users of Oracle Inventory applications. This document does not address the accounting distribution for inter - organization transfers.
Note: Items must be defined in both organizations in order to be able to transfer
INTER ORGANIZATION TRANSFERS
You can define multiple inventories, warehouses, and manufacturing facilities as distinct organizations. With Oracle Inventory you can perform inter–organization transfers as direct or intransit shipments.
You can transfer one or more items in a single transaction. You can also transfer partial quantities of the same item to different subinventories and locators in a single transaction. The items you transfer must exist in both organizations. You can also transfer expense and asset items from one organization to another using intransit inventory.
Direct Inter–organization Transfers
You can use a direct inter–organization transfer to move inventory directly from a shipping organization to a destination organization.
The validity of a transfer transaction depends on the controls you have defined in both the shipping and destination organizations for the items you want to transfer.
For example, you can transfer item A from organization X to organization Y, even though item A is under lot control only in organization X (you can specify the lot numbers for item A in organization X during the transfer transaction). However, you
cannot transfer item B from organization X to organization Y if item B is under lot control only in organization Y (you cannot specify lot numbers for item B in the destination organization because you are performing a direct transfer).
Inter–Organization Transfers via Intransit Inventory
You usually transfer material to intransit inventory when transportation time is significant. When you perform the transfer transaction, you do not need to specify the delivery location. You only need to enter the subinventory you are shipping from, a shipment number, the freight information, and, depending on the inter–organization transfer charge that applies between the organizations, a percentage of the transaction value or a discrete amount that Oracle Inventory uses to compute
transfer charges.
If the FOB point is set to Receipt in the Shipping Networks window, the destination organization owns the shipment when they receive it. If it is set to Shipment, the destination organization owns the shipment when the shipping organization ships it, and while it is intransit.
While your shipment is intransit, you can update shipping information such as the freight carrier or arrival date in the Maintain Shipments window. See: Managing Shipments, Oracle Purchasing User’s Guide.
At the time of shipment, you must define your receiving parameters for the destination organization. You can receive and deliver your shipment in a single transaction or you can receive and store your shipment at the receiving dock. See: Receipts, Oracle Purchasing User’s Guide.
The validity of a transfer transaction depends on the controls you have defined in both the shipping and destination organizations for the items you want to transfer. For example, you can transfer item A from organization X to organization Y, even though item A is under lot control only in organization X (you can specify the lot numbers for item A in organization X during the transfer transaction). You can also
transfer item B from organization X to organization Y if item B is under lot control only in organization Y (you can specify lot numbers for item B in the destination organization when you perform the receiving transaction).
Transferring Between Organizations
You can transfer material from your current organization to another organization, or from your current organization to intransit inventory.
Material in intransit inventory belongs to the organization identified by the FOB point. See: Defining Inter–Organization Shipping Networks.
Prerequisites
Define an inventory item that is common to both organizations. See: Defining Items and Assigning Items to Organizations. Define at least two organizations, one of which is valid to receive material from the other. See: Creating an Organization, Oracleand Defining Human Resource Management Systems User’s Guide
Organization Parameters.
Set up inter–organization relationships and their corresponding accounts. See: Defining Inter–Organization Shipping Networks.
For direct transfers, if the item to transfer is under serial number control, the item must have the same unit of measure in each organization. See: Defining Items.
To enter the information to perform a transfer between organizations:
Navigate to the Inter–organization Transfer window.
Enter the date of entry for the transaction.
The date you can enter is controlled by the INV:Transaction Dateprofile option. See: Oracle Inventory Profile Options.
Validation
Enter an organization to which to transfer the material. You must first define this organization as valid to receive material from your current organization. See: Defining Inter–Organization Shipping
Networks.
In addition, if this organization uses intransit inventory, Oracle Inventory stores the material as intransit inventory when you transfer any material to this organization. You must then move the material from intransit inventory to this organization with an intransit inventory receipt.
Enter a transaction type. This can be either a predefined system type or one you defined. See: Defining and Updating Transaction
Types.
Optionally, you can enter the source of the transaction type. See: Defining and Updating Transaction Source Types.
Indicate if inventory information should be defaulted from the serial number.
Enter any optional Shipment information.
Optionally, you can enter the following Shipment information:
To enter the items to transfer:
Choose Transaction Lines from the Inter–organization Transfer window.
Enter an inventory item to transfer.
You can transfer the same item more than once. For example, you can specify an item more than once to transfer partial quantities to different subinventories or stock locators.
For a direct transfer, if the item is under revision control in either organization, enter a revision that is common to the item in both organizations.
Enter a subinventory from which to transfer the material.
Optionally, enter the subinventory to which to transfer the material.
You must enter a value in this field for direct inter–organization transfers.
If you established locator control for the item, enter from and to locators.
Enter a lot number for the item. If you want to enter multiple lot numbers, complete the remaining steps, then choose the Lot/Serial button to display the Lot Entry window. For receipt transactions, if you enter a lot number, enter the date the lot expires. You can enter a value here only if the Lot Expiration (Shelf Life) Control attribute is set to User–defined Expiration Date.
Enter a unit of measure. This can be the primary unit of measure(the default) or any valid alternate unit of measure. If you enter an alternate unit of measure, Oracle Inventory issues the quantity you specify in this unit of measure. Oracle Inventory also converts the quantity to the primary unit of measure so that it can correctly update the on–hand quantity.
Enter the quantity of the item to transfer.
Optionally enter a reason code for the transaction. For example, you can use reason codes to allow you to mark exceptional charges to support a quality data collection and reporting system. You can also enter up to 240 characters of free text in the Reference field that describe the transaction.
To enter internal transfer charges to assign to the To organization:
_
Enter a value in the Added Value field that represents the transfer
charge. You can enter a value here only if you entered Requested value in the Inter–Organization Transfer Charge field in the Organization Parameters window.
Enter the percent of the transaction value that represents the transfer charge. You can enter a value here only if you entered Requested percent in the Inter–Organization Transfer Charge field in the Organization Parameters window. Defining Inter–Organization Information.
To enter freight information costs to assign to the From (current)
organization:
Enter the transportation cost to physically transfer the material; that is, the freight carrier charges.
Enter the general ledger account to which to charge the value you entered in the Transportation Cost field. Oracle Inventory displays the account you defined for the freight carrier as the default. See: Defining Freight Carriers.
To enter a unit number:
If Oracle Project Manufacturing is installed and if you have enabled its end item model/unit effectivity feature, you can enter a unit number for the item. See: Model/Unit Effectivity, Oracle Project Manufacturing Implementation Manual. Note: The Unit Number field is visible only if you have installed Project Manufacturing.
To enter lot or serial number information.
Choose the Lot/Serial button. See: Assigning Lot Numbers and Assigning Serial Numbers.
To view quantity available and quantity on hand values:
Review the following fields: Available: Displays the quantity available to transfer, based on the unit of measure you specified. The available quantity is the quantity on hand less all reservations for the item. This amount could include the amount you have reserved if you enter a transaction source that has reservations against it. The available quantity includes reservations against current transaction source. The available quantity is specific to the revision level, lot number, From
subinventory, and From locator you specify for the transfer. On hand: Displays the current on–hand quantity for the item, based on the unit of measure you specified. The on–hand quantity is specific to the revision, lot number, From subinventory, and From locator you specify for the transfer. On–hand includes quantities for pending transactions in the MTL_MATERIAL_TRANSACTIONS table.
To process the transaction:
Save your work.
To record movement statistics:
Use either of the following methods to record and maintain information associated with the movement of goods: Navigate to the Movement Statistics window and record information manually. See: Entering Movement Statistics. Automate the collection of this information by setting up parameters in the Movement Statistics Parameters and Economic Zones windows. See: Defining Movement Statistics Parameters and Defini
•A shipment number to uniquely identify an item or group of items to transfer. When the To Org uses intransit inventory, you must enter a value here.
•The freight carrier for the transfer.
•A waybill or airbill number for the transfer.
•The number of containers in which the material is stored for the transfer.
•The date you expect to receive the material at the destination organization. You must enter a date equal to or later than the current date. Oracle Inventory uses this date for reporting purposes only.
Content from Oracle Metalink
Thanks & Regards,
S.Grace Paul Regan
Thursday, December 23, 2010
Troubleshooting Average Costing In Oracle R12
When troubleshooting the Actual Cost Manager's failure to start you will discover that it is not fully documented in one source document. There are pieces of the troubleshoot process scattered throughout Metalink's notes and FAQ's that take a considerable amount of time to locate.
This article will help expedite the Actual Cost Manager's troubleshooting process.
When Average Cost Updates are not being calculated the cause can be related to the Cost Manager and the Actual Cost Worker not running.
There are several reasons why this is happening:
The first thing to check is the Inventory > Set Up > Organizations > Parameters > Costing Information [TAB] > Cost Cutoff Date.
If the cost cutoff date is set to the current date or the date is in the past the Average Cost calculations will not work. The Fix: It will need to be re-set to a valid date or cleared.
Other problems are associated with the Actual Cost Worker - if it does not start or if it completes with a warning or an error the Average Costs will not get updated.
If there are any errors in the MTL_MATERIAL_TRANSACTIONS table the Cost Manager usually will not spawn an Actual Cost Worker in an Average Costing
environment UNTIL ALL ERRORS ARE CORRECTED in the table.
Problems can also be associated with the transaction rows that have a ‘null’ Distribution_Account_id which can cause the Costed_flag = ‘E’ which the Cost Manager identifies as an Error and then the Average Cost Update will not work since the Actual Cost Worker does not get started. The Fix: Add the correct Distribution_Acct_id and re-run the
Average Cost update.
Errors relating to the MTL_MATERIAL_TRANSACTIONS can be viewed in the forms: Cost Management > View Transactions > Material Transactions > select a date range when costs are not posting or an item that has not had its unit cost updated after an Average Cost Update has been posted. Look in the Transaction ID [TAB] Error Code column and the Error Explanation column. (Example: Error Code = CST_NO_TXN_INVALID_ACCOUNT and the Error Explanation = An invalid account is associated with the item being transacted.)
If an invalid account is associated with the item being transacted it could be because a Cost Variance account is missing from the Cost Group - verify this by: Cost Management > Set Up > Cost Groups > Account field (Cost Variance.) The Fix:Add a new Cost Variance account in the GL module and apply it to the Cost Group’s Cost Variance account.
Thanks & Regards,
S.Grace Paul Regan
This article will help expedite the Actual Cost Manager's troubleshooting process.
When Average Cost Updates are not being calculated the cause can be related to the Cost Manager and the Actual Cost Worker not running.
There are several reasons why this is happening:
The first thing to check is the Inventory > Set Up > Organizations > Parameters > Costing Information [TAB] > Cost Cutoff Date.
If the cost cutoff date is set to the current date or the date is in the past the Average Cost calculations will not work. The Fix: It will need to be re-set to a valid date or cleared.
Other problems are associated with the Actual Cost Worker - if it does not start or if it completes with a warning or an error the Average Costs will not get updated.
If there are any errors in the MTL_MATERIAL_TRANSACTIONS table the Cost Manager usually will not spawn an Actual Cost Worker in an Average Costing
environment UNTIL ALL ERRORS ARE CORRECTED in the table.
Problems can also be associated with the transaction rows that have a ‘null’ Distribution_Account_id which can cause the Costed_flag = ‘E’ which the Cost Manager identifies as an Error and then the Average Cost Update will not work since the Actual Cost Worker does not get started. The Fix: Add the correct Distribution_Acct_id and re-run the
Average Cost update.
Errors relating to the MTL_MATERIAL_TRANSACTIONS can be viewed in the forms: Cost Management > View Transactions > Material Transactions > select a date range when costs are not posting or an item that has not had its unit cost updated after an Average Cost Update has been posted. Look in the Transaction ID [TAB] Error Code column and the Error Explanation column. (Example: Error Code = CST_NO_TXN_INVALID_ACCOUNT and the Error Explanation = An invalid account is associated with the item being transacted.)
If an invalid account is associated with the item being transacted it could be because a Cost Variance account is missing from the Cost Group - verify this by: Cost Management > Set Up > Cost Groups > Account field (Cost Variance.) The Fix:Add a new Cost Variance account in the GL module and apply it to the Cost Group’s Cost Variance account.
Thanks & Regards,
S.Grace Paul Regan
Sunday, April 6, 2008
What is Inventory?
●Inventory defines the item you use in manufacturing and maintain perpetual inventory balances through transactions that reflect daily activities such as receipts and material movement. Oracle Inventory provides the transaction needed to maintain on-hand quantities. These transactions records most inventory movements like receipts, issues and location changes.
●Inventory Organization is further subdivided into sub inventories A subinventory is a subdivision of an organizations inventory, frequently it represents a physical location. Oracle Inventory provides basic inventory planning like min-max planning and re-order point planning and basic forecasting capabilities.
●Oracle Inventory can be seamlessly integrated since Oracle General Ledger provides a set of books and currency exchange rates and receives transaction accounting summary and details.
●Inventory is the crucial module, connecting all of Oracle Manufacturing Applications together. It shares UOM, items, item information, receipts, delivers, inter-org information ATP/on-hand quantity and basic forecasting info with Cost Management, WIP, ASCP, BOM, OM, Purchasing, as well as engineering items and information with Engineering.
Thanks & Regards,
S.Grace Paul Regan
●Inventory Organization is further subdivided into sub inventories A subinventory is a subdivision of an organizations inventory, frequently it represents a physical location. Oracle Inventory provides basic inventory planning like min-max planning and re-order point planning and basic forecasting capabilities.
●Oracle Inventory can be seamlessly integrated since Oracle General Ledger provides a set of books and currency exchange rates and receives transaction accounting summary and details.
●Inventory is the crucial module, connecting all of Oracle Manufacturing Applications together. It shares UOM, items, item information, receipts, delivers, inter-org information ATP/on-hand quantity and basic forecasting info with Cost Management, WIP, ASCP, BOM, OM, Purchasing, as well as engineering items and information with Engineering.
Thanks & Regards,
S.Grace Paul Regan
Friday, April 4, 2008
Oracle Inventory Organizations
Oracle Applications uses multiple types of organizations to build the business execution structure. At the top of the structure is the accounting set of books SOB), defined in the General Ledger. Next, different types of organizations are used to further define the organization structure and relationships. All organizations are defined and updated with the Define Organization form.
Set of Books:
A General Ledger SOB, linked to the inventory organization, controls the financial accounting of inventory transactions. A SOB is made up of a chart of accounts, a financial calendar, and a currency. The general ledger secures transactions (journal entries, balances) by SOB.
Legal Entity:
A legal entity organization defines the tax and fiscal reporting level. The legal entity represents the legal company.
Operating Unit:
An operating unit organization defines the Purchasing, Order Entry, Accounts Payable and Accounts Receivable level of operation. An operating unit may span multiple manufacturing facilities, distribution points and sales offices, or it may be limited to a single site.
Inventory Organization:
Two flavors of inventory organizations are found in Oracle Applications. They are defined the same, and both are assigned a set of books, a legal entity organization, an operating unit organization, and a location. An item master organization is used for item number maintenance and validation, No item transaction will be done in an Item Master Organization.
This master organization serves as a data repository storing items and item attributes, master level categories and category sets, master level cross references, and numerous data defaults. On-hand balances, inventory movements, and other on-going inventory activities are not performed in an item master organization. Generally, the master organization is used as the validation organization for Purchasing and Order Entry. It is recommended that a single item master organization be defined, even in multiple organization, multiple sets of books environments.
In addition to the item master organization there are one or more non-master inventory organizations. Like the item master inventory organization, the non-master organizations are assigned a set of books, a legal entity organization and an operating unit organization. The non-master inventory organization points to a master organization and looks to the master organization for master level item attributes, master level categories, and other master level controlled data.
Note that each organization has its own set of books/legal entity/operating unit relationship, so inventory organizations with differing SOB’s or operating unitsmay share the same master organization.
These non-master inventory organizations are the execution level organizations. They hold on-hand balances and transaction history. Here is where inventory users execute their daily activities, such as receiving and issuing material, performing cycle counts, and viewing material availability and transaction history. A single organization therefore generally represents a single manufacturing site or distribution center.
Locations:
A location code is an address. Each inventory organization must be assigned at least one location code.
Subinventories:
A subinventory is used as a holding point for on-hand
inventory and generally represents a stockroom, stocking area or cage used for storing material. Subinventories are defined within inventory.
organizations:
An inventory organization may have any number of subinventories, and an asset account is assigned to each subinventory. Since the subinventory entity is logical, as there is not an address or physical location description associated with it, clients may define subinventories for any physical or logical grouping of inventory.
Examples of subinventories:
Stores. Used for the primary stockroom for storing raw materials and sub-assemblies
FG. Used for Finished Goods inventory if finished goods are stocked
WIP. Used for raw material and sub-assemblies stored in production areas and issued at operation or job completion (backflush).
MRB. Used for Material Review Board goods. This is generally material that requires engineering review before disposition as scrap, rework, return to supplier or use as is.
Stock Locators:
Stock locators are an optional entity that may be used to represent physical locations within a subinventory. You may choose to use stock locators for selected subinventories or selected items within selected subinventories. If locators are used, subinventory and locator track on-hand balances. Therefore, if locators are defined to represent a shelf within a stockroom, on-hand balances on the system would show the item and quantity down to the physical location within the facility.
Oracle Inventory uses a key flexfield for stock locators. This presents a few limitations for its use. Only one locator flexfield definition is allowed per install. Therefore, if the stockroom (subinventory) wants to track material by row, bin and shelf, it will likely define a three-segment flexfield with segments for row, bin, and shelf. If locators are desired for another subinventory, even in another organization, the structure will again be 3 segments for row, bin and shelf. In addition to this limitation, locators must be unique within an organization; you cannot use the same locator in different subinventories within an organization, but you can use the same locator in subinventories in a different organization.
Thanks & Regards,
S.Grace Paul Regan
Tuesday, March 4, 2008
Overview Oracle Inventory R-12
Dear All,
Kindly find the document to have an breif about Oracle Inventory in R-12.
Click Me - R-12 Oracle Inventory Overview
Thanks & Regards,
S.Grace Paul Regan.
Kindly find the document to have an breif about Oracle Inventory in R-12.
Click Me - R-12 Oracle Inventory Overview
Thanks & Regards,
S.Grace Paul Regan.
Monday, March 3, 2008
Receiving: Returns and Corrections
Q1. Is it possible to perform Returns for Internal Shipments (Inter-Org and Internal Order)?
A: No, it is not possible to perform Returns on Internal Shipments. You need to reverse the original process if you want to return an internally ordered item. You have to create an internal requisition for the item in the source organization, and then process that order back to the source organization.
Q2. Is it possible to perform Returns/Corrections for RMAs?
A:The Returns/Corrections for RMAs that are delivered to Inventory is not supported if the customer has file poxrcv.odf version higher than or equal to 115.52.
Q3. Can I return/correct a cancelled PO line or shipment to a vendor?
A: It is not possible to return/correct a cancelled PO line or shipment.
As a workaround the following can be performed:
For Inventory Item:
Enter a 'Miscellaneous Issue' in Inventory Module against this Item. This will correct the quantity in inventory.
For expense item:
Enter adjustment directly in GL, or credit memo to cancel accruals.
Please note: The Cancel Action (and Final Close) in the PO Summary form is an irreversible action. A warning message is displayed indicating no futher transaction activity will be allowed if the Cancel action is selected. The warning message provides an opportunity for the User not to continue with the Cancel. Oracle development does not support any datafixes on cancellation and finally closed (user actions) since there are double verifications done while proceeding on this action.
Q4. Can I change the line status of PO to "Closed for Receiving" and then query the PO in Returns/Corrections Form to correct them?
A: The customer should NEVER change the status of the cancelled/finally-closed line without development's consent via a bug.
Oracle Development may not provide a datafix for explicitly cancelled lines because of "user errors".
Q5. I cannot do returns/adjustments for an un-ordered receipt. Why?
A: Adjustments and/or returns to vendor on unordered receipts can only be done after the receipt has been matched to a Purchase Order. Verify this has been done.
Q6. Can Returns/Corrections be performed when the deliver_to person is not active?
A: Returns/Corrections are not allowed if the deliver to person is not active. You have to re-activate the employee to perform returns/corrections.
Q7. I am not able to return an item under serial control. What should I do?
A: Check whether the Serial Number is available in the subinventory and organization.
Thanks & Regards,
S.Grace Paul Regan
A: No, it is not possible to perform Returns on Internal Shipments. You need to reverse the original process if you want to return an internally ordered item. You have to create an internal requisition for the item in the source organization, and then process that order back to the source organization.
Q2. Is it possible to perform Returns/Corrections for RMAs?
A:The Returns/Corrections for RMAs that are delivered to Inventory is not supported if the customer has file poxrcv.odf version higher than or equal to 115.52.
Q3. Can I return/correct a cancelled PO line or shipment to a vendor?
A: It is not possible to return/correct a cancelled PO line or shipment.
As a workaround the following can be performed:
For Inventory Item:
Enter a 'Miscellaneous Issue' in Inventory Module against this Item. This will correct the quantity in inventory.
For expense item:
Enter adjustment directly in GL, or credit memo to cancel accruals.
Please note: The Cancel Action (and Final Close) in the PO Summary form is an irreversible action. A warning message is displayed indicating no futher transaction activity will be allowed if the Cancel action is selected. The warning message provides an opportunity for the User not to continue with the Cancel. Oracle development does not support any datafixes on cancellation and finally closed (user actions) since there are double verifications done while proceeding on this action.
Q4. Can I change the line status of PO to "Closed for Receiving" and then query the PO in Returns/Corrections Form to correct them?
A: The customer should NEVER change the status of the cancelled/finally-closed line without development's consent via a bug.
Oracle Development may not provide a datafix for explicitly cancelled lines because of "user errors".
Q5. I cannot do returns/adjustments for an un-ordered receipt. Why?
A: Adjustments and/or returns to vendor on unordered receipts can only be done after the receipt has been matched to a Purchase Order. Verify this has been done.
Q6. Can Returns/Corrections be performed when the deliver_to person is not active?
A: Returns/Corrections are not allowed if the deliver to person is not active. You have to re-activate the employee to perform returns/corrections.
Q7. I am not able to return an item under serial control. What should I do?
A: Check whether the Serial Number is available in the subinventory and organization.
Thanks & Regards,
S.Grace Paul Regan
Sunday, March 2, 2008
How do users delete the receipts made in error?
Users cannot delete a receipt once it is made, however users can perform either a
'Correction' or a 'Return' to the receipt dependant upon the nature of the error
made when performing the receipt:
Return To Vendor - This is typically done if you do not want the shipment received
from the vendor (for example, vendor over-shipped, or items received were damaged
or wrong color, or you just don't want to receive that shipment at this time). You can return
the shipment for the full amount.
Correction - This is typically done when you wish to correct an error made when receiving
a shipment (for example, you physically received 9 but put down that you received 10).
Both methods above ensure that correct accounting adjustments are made when performing
either a return or a correction.
Thanks & Regards,
S.Grace Paul Regan
'Correction' or a 'Return' to the receipt dependant upon the nature of the error
made when performing the receipt:
Return To Vendor - This is typically done if you do not want the shipment received
from the vendor (for example, vendor over-shipped, or items received were damaged
or wrong color, or you just don't want to receive that shipment at this time). You can return
the shipment for the full amount.
Correction - This is typically done when you wish to correct an error made when receiving
a shipment (for example, you physically received 9 but put down that you received 10).
Both methods above ensure that correct accounting adjustments are made when performing
either a return or a correction.
Thanks & Regards,
S.Grace Paul Regan
Thursday, January 3, 2008
Closing Inventory Period
Oracle Inventory uses accounting periods to group material transactions and work in process transactions for accounting purposes. So normally these deatils are grouped for a month and the transaction details are posted to GL.
An automatic general ledger transfer is processed when you close an accounting period.
1. Material Transaction
=======================
The Material Transaction includes miscellaneous issue, sales order issue, or cycle count adjustment.
2. WIP Transaction
==================
Resource transaction Lists resource transaction details.
Overhead transaction Lists overhead transaction details.
Outside processing Lists outside processing transaction details.
Cost update Lists cost update transaction details.
Period close variance Lists transaction details for period close variance transactions for expense jobs and certain instances of repetitive schedules.
Job close variance Lists job close variance transaction details.
Closing a Period
================
You can close the earliest accounting period with a status of Open or Error.
Before you close a Inventory period make sure you have noticed all the pending transactions that is showing for the particular accounting period that you have chosen to close, to find the pending transactions (navigation)
1.Inventory Superuser > Accounting Close Cycle > Inventory Accounting Period >
Pressing the pending button in the bottom left corner of the screen !
2. After Choose the Pending button. The Pending Transactions window appears
Resolution Required: Displays the number of unprocessed material transactions,
uncosted material transactions, and pending WIP costing transactions existing in
this period. These must be resolved before the period is closed.
Resolution Recommended: Displays the number of pending receiving transactions,
pending material transactions, and pending shop floor move transactions existing
in this period. You can close the accounting period, however, after it is closed
these transactions cannot be processed.
See
Unprocessed Transaction Messages
One of the following messages appear if there are unprocessed transactions:
Pending receiving transactions for this period
When you use Purchasing, this message indicates you have unprocessed purchasing transactions in the RCV_TRANSACTIONS_ INTERFACE table. These transactions include purchase order receipts and returns for inventory. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your receiving value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Unprocessed material transactions exist for this period
This message indicates you have unprocessed material transactions in the MTL_MATERIAL_TRANSACTIONS_TEMP table. You are unable to close the period with this condition. Please see your system administrator. Inventory considers entries in this table as part of the quantity movement.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending material transactions for this period
This message indicates you have unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your inventory value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Uncosted material transactions exist for this period
This message indicates you have material transactions in the MTL_MATERIAL_TRANSACTIONS table with no accounting entries (Standard Costing) and no accounting entries and no costs (Average Costing). You are unable to close the period with this condition. These transactions are part of your inventory value.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending move transactions for this period
This message indicates you have unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your work in process value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Pending WIP costing transactions exist in this period
This message indicates you have unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table. You are unable to close the period with this condition. These transactions are in your work in process value, and awaiting further processing.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
After you have checked all the pending transactions and after clearing all the mandatory pending transactions and again once again check for any pending transactions, Once you are sure that you are ready to close the inventory period you can come back to the main inventory accounting periods page in the right end corner press the change status button in the pop up window select Close and be sure that INVENTORY PERIOD CLOSED CANNOT BE REOPENED (This is a irreversable process), Take extra care while closing inventory period.
Thanks & Regards,
S.Grace Paul Regan.
An automatic general ledger transfer is processed when you close an accounting period.
1. Material Transaction
=======================
The Material Transaction includes miscellaneous issue, sales order issue, or cycle count adjustment.
2. WIP Transaction
==================
Resource transaction Lists resource transaction details.
Overhead transaction Lists overhead transaction details.
Outside processing Lists outside processing transaction details.
Cost update Lists cost update transaction details.
Period close variance Lists transaction details for period close variance transactions for expense jobs and certain instances of repetitive schedules.
Job close variance Lists job close variance transaction details.
Closing a Period
================
You can close the earliest accounting period with a status of Open or Error.
Before you close a Inventory period make sure you have noticed all the pending transactions that is showing for the particular accounting period that you have chosen to close, to find the pending transactions (navigation)
1.Inventory Superuser > Accounting Close Cycle > Inventory Accounting Period >
Pressing the pending button in the bottom left corner of the screen !
2. After Choose the Pending button. The Pending Transactions window appears
Resolution Required: Displays the number of unprocessed material transactions,
uncosted material transactions, and pending WIP costing transactions existing in
this period. These must be resolved before the period is closed.
Resolution Recommended: Displays the number of pending receiving transactions,
pending material transactions, and pending shop floor move transactions existing
in this period. You can close the accounting period, however, after it is closed
these transactions cannot be processed.
See
Unprocessed Transaction Messages
One of the following messages appear if there are unprocessed transactions:
Pending receiving transactions for this period
When you use Purchasing, this message indicates you have unprocessed purchasing transactions in the RCV_TRANSACTIONS_ INTERFACE table. These transactions include purchase order receipts and returns for inventory. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your receiving value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Unprocessed material transactions exist for this period
This message indicates you have unprocessed material transactions in the MTL_MATERIAL_TRANSACTIONS_TEMP table. You are unable to close the period with this condition. Please see your system administrator. Inventory considers entries in this table as part of the quantity movement.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending material transactions for this period
This message indicates you have unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your inventory value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Uncosted material transactions exist for this period
This message indicates you have material transactions in the MTL_MATERIAL_TRANSACTIONS table with no accounting entries (Standard Costing) and no accounting entries and no costs (Average Costing). You are unable to close the period with this condition. These transactions are part of your inventory value.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
Pending move transactions for this period
This message indicates you have unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table. If this condition exists, you will receive a warning but will be able to close the accounting period. These transactions are not in your work in process value. However, after you close the period, these transactions cannot be processed because they have a transaction date for a closed period.
Pending WIP costing transactions exist in this period
This message indicates you have unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table. You are unable to close the period with this condition. These transactions are in your work in process value, and awaiting further processing.
Closing the period in this situation is not allowed because the resultant accounting entries would have a transaction date for a closed period, and never be picked up by the period close or general ledger transfer process.
After you have checked all the pending transactions and after clearing all the mandatory pending transactions and again once again check for any pending transactions, Once you are sure that you are ready to close the inventory period you can come back to the main inventory accounting periods page in the right end corner press the change status button in the pop up window select Close and be sure that INVENTORY PERIOD CLOSED CANNOT BE REOPENED (This is a irreversable process), Take extra care while closing inventory period.
Thanks & Regards,
S.Grace Paul Regan.
Subscribe to:
Posts (Atom)