Oracle Cloud ERP – Contract Purchase Agreement Import (FBDI
Docs :
Scheduled process
Import Contract Purchase Agreements *** Import Contract Agreements
Interface Tables
PO_GA_ORG_ASSIGN_INTERFACE —> Interface Table For Org Assignments
PO_HEADERS_INTERFACE –> is the interface table that holds header information for the PDOI program to create standard/blanket purchase orders/cpa and catalog quotations.
Error Table
PO_INTERFACE_ERRORS
select * from PO_INTERFACE_ERRORS order by creation_date desc
Base Table
PO_GA_ORG_ASSIGNMENTS –>contains mappings of Global Agreements to the requesting and purchasing operating units that may source it and execute against it, respectively. Each org assignment is either enabled or disabled. (PO_HEADER_ID)
Query
SELECT
PHA.PO_HEADER_ID, PHA.SEGMENT1, PHA.CREATION_DATE, PHA.CREATED_BY,
PS.VENDOR_NAME,
hao.NAME prc_bu_name,
PHA.FROM_HEADER_ID,
PHA.DOCUMENT_CREATION_METHOD
FROM
PO_HEADERS_ALL PHA,
PO_GA_ORG_ASSIGNMENTS PGOA,
POZ_SUPPLIERS_V PS ,
hr_all_organization_units hao
WHERE 1=1
AND PGOA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND PHA.VENDOR_ID = PS.VENDOR_ID
AND PHA.SEGMENT1 IN ( '52274')
AND PHA.prc_BU_ID = hao.ORGANIZATION_ID FBDI File Used In This Sample
https://drive.google.com/file/d/1FmVkq34h0urrTom2UEgsxLjShj6ik8Xn/view?usp=sharing