How To Retrieve Message Text From FND_NEW_MESSAGES?
(Doc ID 2426716.1)
Last updated on JANUARY 16, 2020
Applies to:
Oracle Order Management - Version 12 and laterInformation in this document applies to any platform.
Goal
Running PROCESS_ORDER API and receive following error messages:
ITEM and UOM not on PRICELIST
Unit List Price is required on a booked order line.
Unit Selling Price is required on a booked order line.
The above error message are defined in FND_NEW_MESSAGES table as:
Message Name: OE_PRC_NO_LIST_PRICE
Message Text = &ITEM and &UNIT not on &PRICE_LIST
Message Name: OE_BOOK_REQD_LINE_ATTRIBUTE
Message Text - &ATTRIBUTE is required on a booked order line.
etc.
Business Need
We want message_name as we will put it in a lookup table and assign someone internally/customer-site to the resolve the error.
Cannot use tokens to do this.
We are preparing a lookup that has message_name because message_text has tokens for example
Message_Text defined in the fnd_new_message as
&1 item with UOM &2 not exists in the price list &3.
Message_Name: ONT_PRICE_LIST
Lookup
Meaning: ONT_PRICE_LIST
DFF1: PERSONA
How do we retrieve message text from FND_NEW_MESSAGES?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |