Entries by Oracle ERP Apps Guide

, , , ,

Oracle Back to Back Order in Order Management

Back Orders ·         The Oracle “term” backorder is a “status” on the order line or delivery line indicating that you have tried to release an order for picking in your warehouse, but that the pick release was UNSUCCESSFUL because there was no available inventory.(Backorder can be partial or complete). The Oracle term backorder does NOT mean that you […]

/by
, , ,

How to use CUSTOM.pll in Oracle Apps

Requirement: change the Executable field into uppercase within the Concurrent Program Executable screen   Follow these steps to make the Executable field uppercase using CUSTOM.pll:   1.    Enable show custom events: Log in to the Application Developer responsibility and enable Show Custom Events. Check the blog post for enabling custom events: Custom events can be enabled through the below navigation: Once you enable show custom […]

/by
, , , ,

What are all Oracle ASCP Plan Types?

In R12, you can launch three type of plans: Production Plan Manufacturing Plan Master Plan For MPS Planning item level, you should run Production PlanAnd for MRP Planning Item, you should run Manufacturing plan.Please see the explanation from Dev in similar question from other customers in Oracle Technical forum:“The below are the 3 plan types […]

/by
, , , , ,

Query to find Pegging Details in ASCP

SELECT mso.sales_order_number, md1.*,MSI1.ITEM_NAME||’ (‘||MSI1.INVENTORY_ITEM_ID||’)’ “COMPONENT (ID)”, substr( md1.order_number,1,22) order_num, MS1.NEW_ORDER_QUANTITY COMP_QTY — this is the pegged or previously pegged column, decode (ms1.order_type,’1′,’Purchase order’,’11’,’Intransit shipment’,’12’,’Intransit receipt’,’13’,’Suggested repetitive schedule’,’14’,’Discrete job co-product/by-product’,’15’,’Nonstandard job by-product’,’16’,’Repetitive schedule by-product’,’17’,’Planned order co-product/by-product’,’18’,’On Hand’,’2′,’Purchase requisition’,’27’,’Flow schedule’,’28’,’Flow schedule by-product’,’29’,’Payback Supply’,’3′,’Discrete job’,’30’,’Current repetitive schedule’,’32’,’Returns’,’4′,’Suggested aggregate repetitive schedule’,’41’,’User Supply’,’45’,’Demand Class Consumption’,’46’,’Supply Due To Stealing’,’47’,’Demand Due To […]

/by