How to map FOB code from DOO_FULFILL_LINES_ALL to its text value in Sales Order UI? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to map FOB code from DOO_FULFILL_LINES_ALL to its text value in Sales Order UI?

in Order Management 1 comment

Hello Community,

We are working on extracting the FOB (Freight on Board) value from Sales Orders in Oracle Cloud. On the Sales Order line, the FOB value appears as a text (e.g., "None") in the UI. However, in the backend table DOO_FULFILL_LINES_ALL, this value is stored as a numeric FOB code (e.g., 1).

We have checked the standard lookups (FOB, ORA_FOB), but we are unable to find a direct mapping between the numeric code in DOO_FULFILL_LINES_ALL and the text value shown in the UI.

Example:

  • UI Value: "None"
  • Table Value: 1 (in DOO_FULFILL_LINES_ALL.FOB_CODE
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!