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