Purchase Order conversion

Purchase Order conversion, askHareesh blog for Oracle Apps

Purchase Order conversion:

The Purchasing Document Open Interface concurrent program was replaced by two new concurrent programs Import Price Catalogs and Import Standard Purchase Orders.
  • Import Price Catalogs concurrent program is used to import Catalog Quotations, Standard Quotations, and Blanket Purchase Agreements.
  • Import Standard Purchase Orders concurrent program is used to import Unapproved or Approved Standard Purchase Orders.
Import Standard Purchase Orders

Pre-requisites:
  • Suppliers, sites and contacts
  • Buyers
  • Line Types
  • Items
  • PO
  • Charge account setup
Interface Tables:
  • PO_HEADERS_INTERFACE
  • PO_LINES_INTERFACE
  • PO_DISTRIBUTIONS_INTERFACE
  • PO_INTERFACE_ERRORS (Fallouts)
Interface Program:
  • Import Standard Purchase Orders.
Base Tables:
  • PO_HEADERS_ALL
  • PO_LINES_ALL
  • PO_DISTRIBUTIONS_ALL
  • PO_LINE_LOCATIONS_ALL
Validations:
Header:
  • Check if OU name is valid
  • Check if Supplier is valid
  • Check if Supplier site is valid
  • Check if buyer is valid
  • Check if Payment term is valid
  • Check if Bill to and ship to are valid
  • Check if FOB, freight terms are valid
Lines:
  • Check if Line_type, ship_to_org, item, uom, ship_to_location_id,
  • requestor, charge_account, deliver_to_location are valid
General:
  • Check for duplicate records in interface tables
  • Check if the record already exists in base tables.
Important Columns:
Some important columns that need to be populated in the interface tables:
PO_HEADERS_INTERFACE:
  • INTERFACE_HEADER_ID
  • (PO_HEADERS_INTERFACE_S.NEXTVAL)
  • BATCH_ID
  • ORG_ID
  • INTERFACE_SOURCE_CODE
  • ACTION (‘ORIGINAL’,’UPDATE’,’REPLACE’)
  • GROUP_CODE,
  • DOCUMENT_TYPE_CODE
  • PO_HEADER_ID (NULL),
  • RELEASE_ID
  • RELEASE_NUM
  • CURRENCY_CODE
  • RATE
  • AGENT_NAME
  • VENDOR_ID
  • VENDOR_SITE_ID
  • SHIP_TO_LOCATION
  • BILL_TO_LOCATION
  • PAYMENT_TERMS
PO_LINES_INTERFACE:
  • INTERFACE_LINE_ID
  • INTERFACE_HEADER_ID
  • LINE_NUM
  • SHIPMENT_NUM
  • ITEM
  • REQUISITION_LINE_ID
  • UOM
  • UNIT_PRICE
  • FREIGHT_TERMS
  • FOB
PO_DISTRIBUTIONS_INTERFACE:
  • INTERFACE_LINE_ID
  • INTERFACE_HEADER_ID
  • INTERFACE_DISTRIBUTION_ID
  • DISTRIBUTION_NUM
  • QUANTITY_ORDERED
  • QTY_DELIVERED
  • QTY_BILLED
  • QTY_CANCELLED
  • DELIVER_TO_LOCATION_ID
  • DELIVER_TO_PERSON_ID
  • SET_OF_BOOKS
  • CHARGE_ACCT
  • AMOUNT_BILLED
Import Blanket Purchase Agreements:
Interface Tables:
  • PO_HEADERS_INTERFACE
  • PO_LINES_INTERFACE
Interface program:
  • Import Price Catalogs
Base tables:
  • PO_HEADERS_ALL
  • PO_LINES_ALL
  • PO_LINE_LOCATIONS_ALL

*/