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

Last updated on JULY 29, 2020

Applies to:

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.

No errors in alert log of database too.
 

Solution

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