Total Pageviews

March 6, 2016

3/06/2016 09:50:00 PM


Purchase Order Inbound Interface

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. 

Oracle Purchase order Open Inteface

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




 
Related Posts Plugin for WordPress, Blogger...