Category Archives: requisition import

Oracle Apps Purchasing Interview Questions / FAQs

Q1. What is the Basic Purchasing Setup for Requisition Import? A: If importing requisitions from Inventory, input a value for the profile option INV: Minmax Reorder Approval. If the value of INCOMPLETE is selected, the result will be imported Requisitions … Continue reading

Posted in oracle apps Purchasing, PO, Purchase Orders, requisition import | Leave a comment

Create Requisitions Using Requisition Import – Training

Steps required importing a requisition in purchasing: Use the following scripts to insert data into the po_requisitions_interface_all table. After inserting into the interface table, run the “Requisition Import” program. Destination Type Inventory (Item AS54888). INSERT INTO PO_REQUISITIONS_INTERFACE_ALL (INTERFACE_SOURCE_CODE,                                            ORG_ID,                                            … Continue reading

Posted in create requisition, PO_REQUISITIONS_INTERFACE, requisition import | Leave a comment

Oracle order management – Drop Ship orders

Check the blog posts: Oracle Drop Ship tables Oracle Order Management Drop Ship process in Detail OM Drop Ship Setups and Prerequisites Warehouse Consider establishing a logical warehouse to receive drop shipments. This will isolate the costs of drop shipped … Continue reading

Posted in Autocreate, Drop Ship orders, requisition import | Leave a comment

Interfaces and Conversions in Oracle Applications

I have consolidated all the interfaces and conversions in oracle applications. Order Import Interface (Sales Order Conversion) Pre-requisites: Order Type Line Type Items Customers Ship Method/ Freight Carrier Sales Person Sales Territories Customer Order Holds Sub Inventory/ Locations On hand … Continue reading

Posted in AP invoice, AR, AR Receipt, customer, GL budget, GL daily conversion rates, GL Journal, Import Blanket Purchase Agreements, Inv On-hand quantity, Item, OM, PO Receipts, requisition import | Leave a comment