My Oracle Support Banner

QPXPSRCB ERROR in creating PACKAGE BODY :QP_BUILD_SOURCING_PVT_TMP (Doc ID 455873.1)

Last updated on SEPTEMBER 22, 2018

Applies to:

Oracle Advanced Pricing - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance on 12-FEB-2013


Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to run the concurrent program Build Attribute Mapping Rules ( QPXPSRCB module),
the following error occurs:

ERRORS:


Call AD_DDL to create BODY of package QP_BUILD_SOURCING_PVT_TMP
ERROR in creating PACKAGE BODY :QP_BUILD_SOURCING_PVT_TMP
LINE :4910 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :4909 PL/SQL: Statement ignored
LINE :4982 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :4981 PL/SQL: Statement ignored
LINE :5018 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5017 PL/SQL: Statement ignored
LINE :5054 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5053 PL/SQL: Statement ignored
LINE :5090 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5089 PL/SQL: Statement ignored
LINE :5162 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5161 PL/SQL: Statement ignored
LINE :5198 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5197 PL/SQL: Statement ignored
LINE :5234 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5233 PL/SQL: Statement ignored
LINE :5306 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5305 PL/SQL: Statement ignored
LINE :5342 PLS-00222: no function with name 'G_LINE_REC' exists in this scope
LINE :5341 PL/SQL: Statement ignored
+---------------------------------------------------------------------------+

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Via Oracle Pricing Manager responsibility
2. Submit concurrent program Create Attribute Mapping Rules


-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot use the pricing module.

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.