How To Retrieve Message Text From FND_NEW_MESSAGES? (Doc ID 2426716.1)

Last updated on JANUARY 16, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.