Manage Transactions That Reduce Inventory

Use Inventory Management and other work areas to manage transactions that reduce inventory after you submit the sales order that has the transaction to fulfillment.

Review Transactions That Are Done

Let's say you need to review transactions for sales order 76854.

1. Make sure you have the privileges that you need to review and manage transactions.

   For details, see Overview of Tasks from the Inventory Management Work Area.

2. Go to the Inventory Management work area.

3. Click Tasks > Review Completed Transactions.

4. On the Review Completed Transactions page, search for the values.

   Attribute	Value
   Source Type	Sales Order
   Source Reference	76854

5. In the search results, notice the value.

   Attribute	Value
   Transaction Type	Direct Sales Order Issue Inventory Management uses this transaction type to create the inventory transaction for the sales order.

6. Examine the item, transaction quantity, transaction date, revision, lot, serial, project, and task details for the transaction.

7. Click Done.

Review Transactions That Are In Error

1. Click Tasks > Manage Pending Transactions.

2. On the View Pending Transactions page, search for the values.

   Attribute	Value
   Source Type	Sales Order
   Source Reference	76854
   Transaction Type	Direct Sales Order Issue

3. In the search results, examine the Error Explanation attribute to get details about the error.

   • The page displays errors that happen when Inventory Management uses the Direct Sales Order Issue transaction type.

   • You can modify the subinventory, locator, lot, or serial for a transaction to process it from a pending transaction.

   If you specify a project on the order line, and if on-hand inventory isn't available for the item for the project and task, then the inventory transaction for the sales order will get stuck on the Manage Pending Transactions page in Inventory Management. You can use the Pending Transactions page to fix the error.

   • Adjust the cycle count to fix your project inventory.

   • Or use common inventory. Set the Allow Use of Common Supplies attribute for the item organization that the item references to Yes or leave it empty. Remove the Inventory project and task from the stuck transaction, and Inventory Management will use common inventory to fulfill the demand.

Examine Costs in Cost Management

1. Make sure you have the privileges that you need to review cost accounting distributions.

   For details, see Overview of Cost Accounting.

2. Go to the Cost Accounting work area.

3. Click Tasks > Review Cost Accounting Distributions.

4. On the Review Cost Accounting Distributions page, search for the values.

   Attribute	Value
   Source Reference	76854
   Transaction Type	Direct Sales Order Issue

5. In the search results, examine the distributions for your transaction.

   • Oracle Cost Accounting recognizes the cost of goods sold to the same level that Oracle Receivables or Oracle Revenue Management recognizes revenue.

   • If your orchestration process doesn't have a billing task, then the orchestration process proceeds to close the order line, orchestration sends the order details to Cost Accounting, and Cost Accounting uses a revenue recognition event.

   Here's the accounting template that the Direct Sales Order Issue transaction type uses.

   Accounting Line Type	Debit	Credit
   Deferred Cost of Goods Sold	X	-
   Inventory Valuation	-	X

   Here's the accounting template for Cost of Goods Sold Recognition.

   Accounting Line Type	Debit	Credit
   Cost of Goods Sold	X	-
   Deferred Cost of Goods Sold	-	X

Start the Financial Orchestration Flow

If your transaction includes a change of ownership between business units, then you must run the scheduled process that starts the financial orchestration flow.

1. Go to the Scheduled Processes work area, then click Actions > Schedule New Process.

2. In the Schedule New Process dialog, set the value.

   Attribute	Value
   Process Name	Submit Financial Orchestration Events

3. In the dialog that displays, set the value, then click Submit.

   Attribute	Value
   Process Direct Sales Order Issues	Yes Financial Orchestration will process the inventory transactions and orchestrate the financial flow.

   Note

   • Financial Orchestration processes the transaction when ownership changes from one business unit to another business unit. If your business doesn't include an ownership change for a Direct Sales Order Issue, then you don't need to run this scheduled process.

   • Financial Orchestration orchestrates financial details for each Direct Sales Order Issue transaction type.

   • To view the status of the transaction, go to the Monitor Financial Orchestration page, then set the Business Process Type attribute to Shipment.

   For details, see Overview of Supply Chain Financial Orchestration.

Failure

If the event status never finishes because a failure happens in Financial Orchestration, then run the scheduled process on a schedule.

1. Set the attributes.

   Attribute	Value
   Business Process Type	Shipment Financial Orchestration considers a Direct Sales Order Issue transaction type as a Shipment transaction.
   Process Direct Sales Order Issues	No

2. Click Schedule, then set it up to run on a schedule, such as one time every hour.