How to map Return Reason 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 Return Reason code from DOO_FULFILL_LINES_ALL to its text value in Sales Order UI

Hello Community,

We are working on extracting the Return Reason values from Sales Orders in Oracle Cloud. On the Sales Order line, the Return Reason value appears as a text (e.g., "The item is damaged") in the UI. However, in the backend table DOO_FULFILL_LINES_ALL, this value is stored as a numeric Return Reason code (e.g., 5).

We have checked the standard lookups (DOO_RETURN_REASON), 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.


How can we retrieve the text value (as seen in the UI) from the numeric Return Reason code stored in 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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