Pre Requisites
1) Supplier sites contact details should be defined
2) Organization structure should be defined
3) Ship to bill to locations needs to be defined
4) Set of books needs to be defined
5) Items, item categories, UOM needs to be defined
6) Employee creation, buyer setup should be defined.
Process Steps
1)
Create the Staging tables
2)
Develop the Control files and register
as concurrent program
3)
Develop the PL/SQL Program and write
the validations and insert into interface table
4)
Run the standard program called Import
Standard Purchase orders from PO Responsibility
Parameter : Default
Buyer : Null
Create
or update items : No
PO Status : APPROVED
Batch ID :
13
(We
can get from headers interface table)
5)
Take the Request ID execute following
query we can get the PO numbers
select segment1 PONUMBER
from
po_headers_all
where
request _id = <Pass your request id>
6)
Go to the PO Application and Query the
PO from as per the PO number.
PO_HEADERS_INTEFACE
Column Name
|
Validation Table
Name
|
VENDOR_ID
|
ap_suppliers
|
VENDOR_SITE_ID
|
ap_supplier_SITES_ALL
|
VENDOR_CONTACT_ID
|
ap_supplier_contacts_all
|
AGENT_NAME
|
PER_ALL_PEOPLE_F
|
ORG_ID
|
HR_OPERATING_UNITS
|
DOCUMENT_LOOKUP_CODE
|
Standard, Planed, Contract, Blanket
|
CREATION_DATE
|
< =
SYSDATE
|
CURRENCY_CODE
|
FND_CURREINCES
|
SHIP_TO
|
HR_LOCATIONS
|
BILL_TO
|
HR_LOCATIONS
|
PO_LINES_INTERFACE
Column Name
|
Validation Table
Name
|
LINE_NUM
|
PRIMARY KEY
|
LINE_TYPE
|
PO_LINE_TYPES
|
ITEM
|
MTL_SYSTEM_ITEM_B
|
ITEM_ID
|
|
ITEM_DESCRIPTION
|
|
ITEM_CATEGORY
|
MTL_CATEGORIES
|
ITEM_UOM
|
MTL_UNITS_OF_MEASURE
|
QUANTITY
|
Any Positive number
|
UNIT_PRICE
|
Any Positive number
|
NEED_BY_DATE
|
|
PROMISED_DATE
|
> = PO CRATION DATE
|
SHIP_TO_ORG_ID
|
ORG_ORGANIZATION_DEFINITIONS
|
SHIP_TO_LOCAITONS
|
HR_LOCATIONS
|
ORG_ID
|
HR_OPERATING_UNITS
|
