Entries by Oracle ERP Apps Guide

, , , , , , , , ,

Partial Shipments of a Sales Order Using API

For partial shipment of the sales order, we need to call the WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes API to update the corresponding delivery details to ship all/entered quantity in the delivery details. — OM – Script to Ship Partial Quantities in a SO using WSH_DELIVERY_PUB API —–=========================================================== DECLARE p_sales_order NUMBER := 10014445;p_line_number NUMBER := 1.1;p_org_id NUMBER := 308;l_shipped_quantity NUMBER […]

/by
, , , , , , , ,

Period-End Process

Period-End process is performed at the end of each period(depends on the organization). It is very important in any organization because if the period is not closed, the accounting for that period can not be closed, which will affect the financial results reporting of the respective period. One can not close any module without following […]

/by
, , , ,

Collection Element ‘REV’ has no LOV in R12 Oracle Quality

In Oracle Quality module, the Quality Element ‘Revision’ on Enter Quality Results window has no list of values after R12 upgrade, where it was available in 11i. The users who want to capture the ‘Revision’ for an item on quality plans have no option to select the list of values for Revision.  According to Oracle, […]

/by
, , , , , , ,

Accounting entries in Purchasing, Payables and Receivables

When we enter transactions in Purchasing, the accounting entries will get generated with respect to the following accounts. 1. When Creating a receipt:Inventory Receiving A/C DRAccrual Account CR 2. At the time of Receiving transactions:Asset clearing A/c or Inventory valuation a/c DRInventory Receiving A/c CR 3. When a Payables invoice matched with PO:Accrual A/C DRLiability […]

/by