Transfer Transactions from Receiving to Costing

Use the Transfer Transactions from Receiving to Costing scheduled process to transfer receiving transactions from Oracle Receiving to receipt accounting in Oracle Cost Management.

Receiving transactions (receipt, put away, correct, return to supplier, and return to receiving) for purchase orders, transfer orders, and in-transit shipments, are then processed further in Receipt Accounting. The Transfer Transactions from Receiving to Costing process picks up all receiving transactions that were completed since the last time the process was run.

When to Use

The RCV_TRANSACTIONS table stores all receiving transactions. The Transfer Transactions from Receiving to Costing process is used to transfer transactions from Receiving to Receipt Accounting in Cost Management. Receiving sends the receiving transactions information to the CMR_I_RCV_TRANSACTIONS table in Cost Management. Once the transactions are processed, you can run the Create Receipt Accounting Distributions process within Cost Management.

Privileges Required

Verify that you have the following role or privilege:

Job Role:
  • Cost Accountant (ORA_CST_COST_ACCOUNTANT_JOB)
Privilege:
  • Transfer Receiving Transactions from Receiving to Costing (RCV_TRANSFER_RECEIVING_TRANSACTIONS_FROM_RECEIVING_TO_COSTING_PRIV)

Specifications

Review the following before setting up this scheduled process:
Specification Description
Job Type Scheduled or as needed.
Frequency As required, usually after the receiving transactions are performed.

We recommend that you run the process multiple times a day. It can be run every hour or few times a day.

Time of Day This process can be run multiple times a day.
Duration The time taken for the process to run depends on the number of receiving transactions waiting to be processed.
Compatibility There should only be one instance of the process at any one time. The job is incompatible with itself. Please keep this in mind when creating schedules.

Parameters

None.

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area. If the process status is error, select the row and click the log and output attachment on the Process Details tab. Download the log and output file. Share the files with support to log a service request. The scheduled process request log prints the error message that was raised by the program and includes more information that is helpful to Oracle when creating the service request.
  • You can check the value of the ACCRUAL_STATUS_CODE column in the RCV_TRANACTIONS table. If Receiving hasn’t processed the transaction, the value of this column is PENDING. If Receiving has processed the transaction, the value of this column is INTERFACED.
  • The request execution log displays the organization and number of transaction lines selected for processing. You can also view the time it took for processing the records.
  • This scheduled process interfaces all receiving transactions required by the Receipt Accounting Interface for all inventory organizations.