ORA-22905: Cannot Access Rows From A Non-nested Table Item During Dbms_sqltune.report_tuning_task

(Doc ID 2407736.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.0.0 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms