My Oracle Support Banner

Custom Pricing Attribute Using Context with User Value String ASO_PRICING_INT.G_HEADER_REC.ship_to_org_id Does Not Work (Doc ID 804963.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Advanced Pricing - Version to [Release 11.5]
Information in this document applies to any platform.


-- Problem Statement:
On in Production:
Find customer qualifier pricing attribute is not being built correctly.
Attribute mapping for code = STATE under qualifier context ORDER,
shows that used in setup is checked but attribute mapping status is not enabled.

Error Message

Error Message: ORA-06550: line 1, column 100:
PLS-00302: component 'SHIP_TO_ORG_ID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Expect the attribute mapping status to be enabled after running build attribute mapping rules.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
2. Navigate to report, run build attribute mapping rules.
3. Query the qualifier pricing attribute and find attribute mapping status is not checked.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot complete this setup and use the custom qualifier.


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

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