My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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

Goal

How can one resolve the following error shown on the TEST instance?

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_N1 is disabled in package .
QP_Pricing_Attr_Util Procedure Insert row

Additionally to be more precise,
We have a custom function based index which is enabled in PROD and working fine.
But in our test instance, this index is disabled and we are not able to enable this.
When we are using the alter command to enable this, we got the below error :

ERROR at line 1:

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



Then we 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 related to EBR.


SQL> CREATE INDEX "QP"."XX_QP_PRICING_ATTRIBUTES_N1" ON "QP"."QP_PRICING_ATTRIBUTES" ("APPS"."XXNM_UTIL"."RET_NUMBER"("PRODUCT_ATTR_VALUE"))

2 PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
3 STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
4 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
5 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
6 TABLESPACE "APPS_TS_TX_IDX";

CREATE INDEX "QP"."XX_QP_PRICING_ATTRIBUTES_N1" ON "QP"."QP_PRICING_ATTRIBUTES" ("APPS"."XXNM_UTIL"."RET_NUMBER"("PRODUCT_ATTR_VALUE"))

*

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.