Purchase Order conversion

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