Rest API to get Item and PO details from Oracle Fusion
Summary:
We have a requirement to automatically reopen the purchase orders and blanket purchase agreements using REST API and FBDI approach. Currently we are using Fusion tables to get below PO details for certain validations, request your help to share if we can achieve the same through API call.
PO_HEADER_ID
PO_NUMBER
PRC_BU_ID
REQ_BU_ID
BUYER_ID
REOPEN_LEVEL
PRC_BU_NAME
STYLE_VALIDATION
DISPLAY_NAME
TYPE_LOOKUP_CODE
DOCUMENT_STATUS
END_DATE
PO_LINE_ID
LINE_EXPIRATION_DATE
LINE_NUM
LINE_LOCATION_ID
ITEM_NUMBER
LINE_STATUS
REQ_BU_NAME
VENDOR_NUMBER
APPROVED_FLAG