My Oracle Support Banner

Adding Modifier Lines Throws Error ORA-38818: illegal reference to editioned object (Doc ID 2458126.1)

Last updated on FEBRUARY 13, 2019

Applies to:

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

Goal

While adding new lines in modifier in 'Item Pricing' form or updating the modifier line
with the new category value (segment1 from mtl_categories_b) we are facing the following
errors in form and it is not allowing further operations .

ORA-30554 function-based index
QP.XX_QP_PRICING_ATTRIBUTES_XX.. is disabled in package .
QP_Pricing_Attr_Util Procedure Insert row

One has a custom function based index which is enabled in PROD and working fine.
But in test instance, this index is disabled and not able to enable this.
When using the alter command to enable this, one got the below error :

ERROR at line 1:

ORA-04045: errors during recompilation/revalidation of
QP.XX_QP_PRICING_ATTRIBUTES_XX..
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option



Then tried to drop the index from test instance and tried to recreate it with the metadata of this index from PROD.
But then it is showing error.


ERROR at line 1:
ORA-38818: illegal reference to editioned object APPS.XXNM_UTIL...



No errors in alert log of database too.
 

Solution

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
Goal
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.