Oracle fusion/Cloud Procurement: Purchase order FBDI imports

Safi
2 min readApr 22, 2024

--

PO Header Information :PO_HEADERS_INTERFACE

  • Interface Header Key
    * Action
    Batch ID
    Approval Action
    Order
    Document Type Code
    Procurement BU
    Requisitioning BU
    Sold-to Legal Entity
    Bill-to BU
    Currency Code
    Description
    Bill-to Location
    Ship-to Location
    Supplier
    Supplier Site
    Supplier Contact
    Payment Terms
    Communication Method

PO Line information: PO_LINES_INTERFACE

  • Interface Line Key
    * Interface Header Key
    * Action
    Line
    Line Type
    Item
    Item Description
    Category Name
    Amount
    Quantity
    UOM
    Price

PO Line Locations (Shipment) Information:PO_LINE_LOCATIONS_INTERFACE

  • Interface Line Location Key
    * Interface Line Key
    Schedule
    Ship-to Location
    Ship-to Organization
    Amount
    Quantity
    Need-by Date Eg: Format : 2022/04/29
    Promised Date Eg: Format : 2022/04/29
    Destination Type Code

PO Distribution Information:PO_DISTRIBUTIONS_INTERFACE

  • Interface Distribution Key
    * Interface Line Location Key
    Distribution
    Deliver-to Location
    Amount
    Quantity
    CHARGE_ACCOUNT_SEGMENT1 For Example: 1610
    CHARGE_ACCOUNT_SEGMENT2 For Example: 00
    CHARGE_ACCOUNT_SEGMENT3 For Example: 5600
    CHARGE_ACCOUNT_SEGMENT4 For Example: 16005
    CHARGE_ACCOUNT_SEGMENT5 For Example: 0000
    CHARGE_ACCOUNT_SEGMENT6 For Example: 00000

Run Below Requests

1.Load Interface File for Import

a. Import Process: Import Order

2.Import Order

Verify Log File

Job Id: 7689895

Import Document Job Started.

Calling Job: ImportSPO

Input — Procurement BU Name: PRO QLD BU

Input — Batch ID: 1002

********** Purchase Orders Imported Successfully **********

QLD-PO-0000033

Import Document Job Finished.

Status: S

Validate the PO in the application

--

--

No responses yet