My Oracle Support Banner

Build Attribute Mapping Rules Error in creating PACKAGE BODY :QP_BUILD_SOURCING_PVT_TMP (Doc ID 2640285.1)

Last updated on FEBRUARY 22, 2020

Applies to:

Oracle Advanced Pricing - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Build Attribute Mapping rules, the following error occurs.

ERROR
Error in creating package BODY : QP_BUILD_SOURCING_PVT - User-Defined Exception.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Call AD_DDL to create BODY of package QP_BUILD_SOURCING_PVT_TMP
ERROR in creating PACKAGE BODY :QP_BUILD_SOURCING_PVT_TMP
LINE :1551 PLS-00302: component 'XX_GET_YYY_ID' must be declared
LINE :1550 PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

*Note: Profile QP: Build Attributes Mapping Options = Y (Map attributes used in active pricing setup)

1. Oracle Pricing Manager responsibility
2. Navigate to: Reports
  select name = Build Attribute Mapping Rules
  submit request

--concurrent request completes with error.



.
Attribute Mapping Rules Error Report shows:

PTE: ORDFUL
Context Type: PRICING_ATTRIBUTE
Context: XX_OKS_CONTEXT
Attribute: XX_OKS_COV_PROD (PRICING_ATTRIBUTE3)
Request Type: OKS
Level: LINE
Sourcing Rule: XX_OKS_QP_SOURCE.XX_GET_YYY_ID(OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID)
Error Message: ORA-06550: line 1, column 62:
PLS-00302: component 'XX_GET_YYY_ID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
.

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!


In this Document
Symptoms
Cause
Solution
References


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