My Oracle Support Banner

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 11.5.10.2 [Release 11.5]
Oracle Order Management - Version 11.5.9 to 11.5.10.3 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.

Symptoms

 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
Columns -
SERVICE_DURATION
SERVICE_START_DATE
SERVICE_END_DATE
SERVICE_COTERMINATE_FLAG
SERVICE_CONTEXT
SERVICE_PERIOD
SERVICE_REFERENCE_TYPE_CODE (CUSTOMER_PRODUCT)

b) Table - OE_PRICE_ATTS_IFACE_ALL
Columns -
ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
PRICING_CONTEXT
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"

 

Changes

 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:

ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
PRICING_CONTEXT
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
OE_Validate_Adj.Desc_Flex.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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