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 later
Information in this document applies to any platform.
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.
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.
How do we retrieve message text from FND_NEW_MESSAGES?
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