Transfer Transactions from Inventory to Costing

Use the Transfer Transactions from Inventory to Costing scheduled process to transfer inventory transactions from Oracle Fusion Cloud Inventory Management to Oracle Cost Management. This process ensures inventory transactions are transferred to Cost Management for associated costing, accounting, and reporting activities.

When to Use

The Transfer Transactions from Inventory to Costing process enables you to transfer completed inventory transactions from the Oracle Inventory Management to Cost Management interface tables. When a transaction is created in Inventory Management and successfully processed, the Transaction Costed Status field on the Review Completed Transactions page updates to the Pending Interface to Costing status. Once the Transfer Transactions from Inventory to Costing process is submitted, the Transactions Costed Status field updates to the Interfaced to Costing status. At this point, the inventory transaction data is ready to be imported to the Cost Management base tables.

Privileges Required

  • Transfer Inventory Transaction from Inventory to Costing (INV_TRANSFER_INVENTORY_TRANSACTION_FROM_INVENTORY_TO_COSTING_PRIV)

Specifications

Review the following before setting up this scheduled process:
Specification Description
Job Type Ad hoc job

Scheduled

Frequency As required, usually after the Manage Inventory Transactions process has completed.

It's recommended to schedule the process to run every 30 minutes or every hour. This allows one process to complete before the next one starts. However, these are only recommendations. Ultimately, the frequency depends on the number of transactions and type of transactions. For example, inventory transactions for items that are lot and serial controlled can take additional processing time.

Time of Day Any time.
Duration Runtime of this process will vary based on the number of inventory transactions and type of inventory transactions requiring processing. For example, inventory transactions for lot and serial controlled items can take additional processing time.
Compatibility There should only be one instance of the Transfer Transactions from Inventory to Costing process running at one time.

Parameters

Parameter Optional or Required Description Parameter Values Special Combinations Required Notes
Cost Organization Optional You can run this process for a specific cost organization or for all cost organizations. If you don't have data access to the selected cost organization, the process ends with a Warning status. If you schedule the process without selecting a cost organization, the process transfers data for only those cost organizations to which you have data access. An error message is logged for those cost organizations that you don't have access to. Cost organization None N/A
Commit Limit Optional Determines the number of transactions to process in each loop. The default setting is sufficient for most typical use cases. Number None N/A

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area.
  • Error and warning messages encountered while running the process display in the process log file.
  • When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, and Release Process as provided by the Scheduled Processes work area.
  • You can view the Transaction Costed status on the Review Completed Transactions page. When the process completes successfully, the Transaction Costed status updates from Pending Interface to Costing status to Interfaced to Costing status.
  • To run the process, you must have data access to the appropriate cost organization and the inventory organization must be assigned to the cost organization. If you don't have data access to the selected cost organization, the process ends with a Warning status.
  • In the event inventory transactions are not transferred to Cost Management, confirm the following setups:
    • Navigate to the Manage Cost Organization Relationships setup task and confirm that there’s an inventory organization associated with the cost organization.
    • Navigate to the Manage Inventory Organizations setup task and confirm that there’s a profit center business unit associated with the inventory organization.
    • Navigate to the Assign Business Unit Business Function setup task and confirm that the Below Legal Entity check box is selected for your business unit.