A lot number is a combination of an alphanumeric prefix and a numeric suffix. When we define an item, we can specify the starting lot prefix and the starting lot number. Oracle Inventory uses this information to generate defaults during transaction entry. 1. Establish lot control for an item. We can establish lot control for […]
Inv_Quantity_Tree_Pub API can be used for querying the available Onhand in a given subinventory or organization. The output of the API inv_quantity_tree_pub.query_quantities will show the Total Available Onhand , Reservations , Suggestions and the Actual Onhand that can be Transacted. — R12 – INV – Sample Script to Get Onhand Using INV_Quantity_Tree_PUB API:DECLARE l_api_return_status VARCHAR2 […]
The Receiving Transaction Processor processes pending or unprocessed receiving transactions. We can receive the Purchase Order either using the Expected Receipt form or by putting the record into the Receiving Open Interface (ROI). And then if we will submit the receiving transactions processor so the PO will be received. Records needs to be inserted into […]
Using the PO_CHANGE_API1_S.update_po, the following columns can be updated in a Purchase Order. – Promised_date– Need_by_date– Quantity– Unit_price Importance of LAUNCH_APPROVALS_FLAG=================================– Indicates if you want to launch APPROVAL workflow after the update. Its value could be either ‘Y’ or ‘N’. If not provided, the default value is ‘N’.– If we are passing launch_approvals_flag =>’N’, the […]
R12 – Sample Script to Cancel Single AP Invoice using ap_cancel_package APIDECLAREl_message_name VARCHAR2 (1000);l_invoice_amount NUMBER;l_base_amount NUMBER;l_tax_amount NUMBER;l_temp_cancelled_amount NUMBER;l_cancelled_by VARCHAR2 (1000);l_cancelled_amount NUMBER;l_cancelled_date DATE;l_last_update_date DATE;l_original_prepayment_amount NUMBER;l_pay_curr_invoice_amount NUMBER;l_token VARCHAR2 (100);l_boolean BOOLEAN;l_user_id NUMBER := 2083;l_resp_id NUMBER := 20639;l_appl_id NUMBER := 200; CURSOR C_Inv_Det isSELECT distinct aia.*FROM ap_invoices_all aia, ap_invoice_lines_all ailaWHERE aia.invoice_id = aila.invoice_idAND aia.org_id = aila.org_idAND aia.org_id = 308AND […]
Recent Comments