How Oracle Receiving Source Lines Are Imported

Your Oracle Receiving source lines must meet the following specific conditions to ensure that the Transfer Receipts to Mass Additions process imports receipt information into Oracle Assets.

  • When you create an item in Oracle Product Master Data Management, ensure that:
    • Create Fixed Asset is set to At Receipt.
    • Enable Asset Tracking is set to Full Lifecycle or Not Tracked.
    • Accrue At Receipt is selected.
    • The inventory organization is associated with an Assets corporate book.
  • Create the purchase order after the cut-off date used to enable this feature using the Opt In page.
  • Set the Destination Type to Expense or Inventory in the purchase order.
  • Receive the items into the inventory organization defined in Oracle Supply Chain Execution. Make sure this inventory organization is associated with an Assets corporate book.
  • Define a default asset category for the item to populate the asset category automatically when creating mass additions. If you don't want to provide the asset category for your item, use the clearing account on the asset category as the PO charge account.

Run the following scheduled jobs to import the receipts to Assets. Ensure that the Cost Accountant role is assigned to your user:

  • Transfer Transactions from Receiving to Costing (Oracle Cost Management).
  • Transfer Transactions from Inventory to Costing (Cost Management).
  • Transfer Costs to Cost Management (Cost Management).
  • Create Receipt Accounting Distributions (Cost Management).
  • Create Cost Accounting Distributions (Cost Management).
  • Create Accounting for Cost Management and Receipt Accounting (Cost Management).
  • Review Receipt Accounting Distributions (Oracle Supply Chain Execution in Receipt Accounting. Running this process is optional. Run the process to view the journal entries).
  • Review Cost Accounting Distributions (Oracle Supply Chain Execution in Cost Accounting. Running this process is optional. Run the process to view the journal entries).
  • Transfer Receipts to Mass Additions (Oracle Maintenance).

You then review and prepare the lines in Assets and determine whether to create assets from the lines.

To create invoices in Payables, create a receipt or a purchase order matched invoice with a ship-to location. The invoice must be fully accounted for before importing it into Assets.

During invoice creation, the amounts in the Freight and Miscellaneous accounts are prorated across all the item lines:

  • Freight and miscellaneous amounts are charged to the item based on the prorated allocation in the invoices. They're charged after prorating these amounts to the items in the invoice.
  • If the assets are already posted, the application calculates the proportionate freight and miscellaneous amounts accordingly. You add these adjustments to the posted asset by clicking Add to Asset on the Assets landing page or the Prepare Source Lines page.
Note: Only nonproject-based purchase receipts are transferred to Assets.

To import these invoice details into Assets, run the following processes:

  • Transfer Transactions from Receiving to Costing (Cost Management).
  • Transfer Costs to Cost Management (Cost Management).
  • Create Receipt Accounting Distributions (Cost Management).
  • Create Cost Accounting Distributions (Cost Management).
  • Create Accounting for Cost Management and Receipt Accounting (Cost Management).
  • Review Receipt Accounting Distributions (Oracle Supply Chain Execution in Receipt Accounting. Running this process is optional. Run the process to view the journal entries).
  • Review Cost Accounting Distributions (Oracle Supply Chain Execution in Cost Accounting. Running this process is optional. Run the process to view the journal entries).
  • Transfer Receipts to Mass Additions (Oracle Maintenance).
Source lines from Oracle Receiving are posted to Assets based on their queue status:
  • Post: Receiving lines can't be merged into lines that are already in a queue status of Post.

    If the lines are already posted, then you add any adjustments to the existing asset by clicking Add to Asset on the Assets landing page or the Prepare Source Lines page.

  • New or On Hold: The cost adjustments from Receiving are merged into the item line that was transferred to Assets after accounting the receipts and after running the Transfer Receipts to Mass Additions process.