Order Import Not Processing Pricing Attribute Data In OE_PRICE_ATTRS_IFACE_ALL
(Doc ID 313007.1)
Last updated on OCTOBER 22, 2019
Applies to:Oracle Advanced Pricing - Version 11.5.9 to 188.8.131.52 [Release 11.5]
Oracle Order Management - Version 11.5.9 to 184.108.40.206 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
You have a requirement to import pricing attributes for some 'service' items on their
order lines. To accomplish this, you are populating the interface tables as follows:
a) Table - OE_LINES_IFACE_ALL
b) Table - OE_PRICE_ATTS_IFACE_ALL
PRICING_ATTRIBUTES# - that are defined for the pricing context.
Order Import is failing with the following error:
"Program error. Please inform your support representative that the descriptive
flexfield in the application QP could not be found.
User-Defined Exception in Package OE_Validate_adj Procedure Desc_Flex"
The error message shows that the order import process could not identify the flexfield associated
with the Pricing attributes. The failure occurred in package OE_Validate_adj and procedure Desc_Flex. A quick
check of this procedure shows that it expects a flexfield name parameter to be passed. However, according
to the customer, the following were the key fields being populated in the table OE_PRICE_ATTS_IFACE_ALL:
PRICING_ATTRIBUTES# - that are defined for the pricing context.:
The flexfield name is stored in the column FLEX_TITLE.
For pricing attributes the value populated should be 'QP_ATTR_DEFNS_PRICING' .
The flexfield title is a mandatory parameter for importing price adjustments due to the logic in
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!