Oracle fusion Sale Order Upload Through FBDI

Safi
3 min readFeb 7, 2024

--

1. Sale Order Header (DOO_ORDER_HEADERS_ALL_INT)

a. *Source Transaction Identifier

b. *Source Transaction System

c. *Source Transaction Number

d. **Buying Party Identifier

e. **Transactional Currency Code

f. *Transaction On

g. **Requesting Business Unit

h. Batch Name

i. **Requesting Legal Entity

2. Sales order Lines (DOO_ORDER_LINES_ALL_INT)

a. *Source Transaction Identifier

b. *Source Transaction System

c. *Source Transaction Line Identifier

d. *Source Transaction Schedule Identifier

e. *Source Transaction Schedule Number

f. *Source Transaction Line Number

g. **Product Number

h. *Ordered Quantity

i. **Ordered UOM

j. **Business Unit Name

k. **Requesting Business Unit Name

l. Requested Ship Date

a. Payment Term

b. *Transaction Category Code

c. Unit List Price

d. Unit Selling Price

e. Promise Ship Date

f. **Process Name

3. Addresses (DOO_ORDER_ADDRESSES_INT)

a. Source Transaction Identifier

b. Source Transaction System

c. Address Use Type

d. **Party Identifier

e. **Customer Identifier

f. **Party Site Identifier

g. **Account Site Identifier

4. Upload .CSV File

a. Load Interface File for Import

b. Import Sales Order

c. Data File

d. Import Sales Orders

6. Log file

7. Verification

--

--

No responses yet