R12.1.1 : Invalid Objects FV
Hi,
We have some database objects invalid:
1. The bodies of the packages FV_FACTS_TBAL_TRX, FV_FACTS_TRANSACTIONS and FV_FACTS_TRX_REGISTER are invalid with this error:
PL/SQL: ORA-00918: column ambiguously defined
The error is the use of the column def_indef_flag in this select:
SELECT UPPER (FTS.RESOURCE_TYPE), DEF_INDEF_FLAG, FFP.FUND_CATEGORY
INTO VL_RESOURCE_TYPE, VA_DEF_INDEF_VAL, VL_FUND_CATEGORY
FROM FV_TREASURY_SYMBOLS FTS, FV_FUND_PARAMETERS FFP
WHERE FFP.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND FFP.FUND_VALUE = FUND_VAL
AND FTS.TREASURY_SYMBOL = VP_TREASURY_SYMBOL
We have some database objects invalid:
1. The bodies of the packages FV_FACTS_TBAL_TRX, FV_FACTS_TRANSACTIONS and FV_FACTS_TRX_REGISTER are invalid with this error:
PL/SQL: ORA-00918: column ambiguously defined
The error is the use of the column def_indef_flag in this select:
SELECT UPPER (FTS.RESOURCE_TYPE), DEF_INDEF_FLAG, FFP.FUND_CATEGORY
INTO VL_RESOURCE_TYPE, VA_DEF_INDEF_VAL, VL_FUND_CATEGORY
FROM FV_TREASURY_SYMBOLS FTS, FV_FUND_PARAMETERS FFP
WHERE FFP.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND FFP.FUND_VALUE = FUND_VAL
AND FTS.TREASURY_SYMBOL = VP_TREASURY_SYMBOL
Tagged:
0