My Oracle Support Banner

Unable To Price Lines For Sales Orders Due To Errors for Package Body QP_BUILD_SOURCING_PVT_TMP (Doc ID 2739925.1)

Last updated on DECEMBER 24, 2020

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Pricing Engine

Unable to Price Lines for Sales Orders. This functionality is broken as Object QP BUILD SOURCING PVT TMP is in Invalid state.
We have tried to re-compile object but getting error message.

ERROR
-----------------------
LINE/COL ERROR
-------- -----------------------------------------------------------------
7077/98 PLS-00103: Encountered the symbol "," when expecting one of the
  following:
  ( - + case mod new not null
  
  continue avg count current exists max min prior sql stddev
  sum variance execute forall merge time timestamp interval
  date
   pipe
    specification>
  


Errors for PACKAGE BODY APPS.QP_BUILD_SOURCING_PVT_TMP:

Changes

 

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
Changes
Cause
Solution


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