ORA-22905: Cannot Access Rows From A Non-nested Table Item During Dbms_sqltune.report_tuning_task
(Doc ID 2407736.1)
Last updated on DECEMBER 08, 2023
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 2.6.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
SQL> SELECT
dbms_sqltune.report_tuning_task('a6cwfc19pf9k6_tuning_task') AS recommendations
FROM dual; 2 3
GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name : a6cwfc19pf9k6_tuning_task
Tuning Task Owner : SYS
Workload Type : Single SQL Statement
Scope : COMPREHENSIVE
Time Limit(seconds): 500
Completion Status : COMPLETED
Started at : 01/24/2018 08:18:06
Completed at : 01/24/2018 08:18:06
-------------------------------------------------------------------------------
Schema Name: CISADM
SQL ID : a6cwfc19pf9k6
SQL Text : INSERT INTO CI_TXN_DTL_PRITM_SUMMARY (ACCT_ID, DER_DIVISION,
INIT_PRICEITEM_CD, TOU_CD, PRICEITEM_PARM_GRP_ID,
AGG_PARM_GRP_ID, ORG_TXN_DATE, BCHG_START_DT, BCHG_END_DT,
PROCESSING_DT, SW_PRM_TXN_HEADER_ID, SW_PRM_TXN_SOURCE_CD,
SW_PRM_CIS_DIVISION, SMRY_UID, STATUS, RUN_GRP_ID) (SELECT
ACCT_ID, CIS_DIVISION, INITIAL_PRICE_ITEM_CD, INTIAL_TOU_CD,
PRICEITEM_PARM_GRP_ID, AGG_PARM_GRP_ID, TXN_DTTM, TXN_DTTM,
TXN_DTTM, PROCESSING_DT, :B5 , :B4 , :B3 , TO_CHAR(SYSDATE,
'YYYYDDMM') || TO_CHAR(SYSDATE, 'HH24mmssSSS') ||
TO_CHAR(RMB_CI_TXN_PRITM_SMRY_UID_SEQ.NEXTVAL, 'FM000000'), 'I',
:B2 FROM (SELECT ACCOUNTID AS ACCT_ID, DERIVEDDIVISION AS
CIS_DIVISION, INITIALPRICEITEMCODE AS INITIAL_PRICE_ITEM_CD,
INITIALTOUCODE AS INTIAL_TOU_CD, PRICEPARMGROUPID AS
PRICEITEM_PARM_GRP_ID, AGGPARMGROUPID AS AGG_PARM_GRP_ID,
ORGTXNDATE AS TXN_DTTM, PROCESSINGDATE AS PROCESSING_DT FROM
TABLE(:B1 ) A WHERE NOT EXISTS (SELECT 1 FROM
CI_TXN_DTL_PRITM_SUMMARY S WHERE S.ACCT_ID = A.ACCOUNTID AND
S.INIT_PRICEITEM_CD = A.INITIALPRICEITEMCODE AND S.TOU_CD =
A.INITIALTOUCODE AND S.PRICEITEM_PARM_GRP_ID =
A.PRICEPARMGROUPID AND S.AGG_PARM_GRP_ID = A.AGGPARMGROUPID AND
S.ORG_TXN_DATE = A.ORGTXNDATE AND S.PROCESSING_DT =
A.PROCESSINGDATE)))
-------------------------------------------------------------------------------
ERRORS SECTION
-------------------------------------------------------------------------------
- ORA-22905: cannot access rows from a non-nested table item ++++++++++
Cause
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
Symptoms |
Cause |
Solution |
References |