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