Upgrade Issue: artrx.odf Consumes A Lot of Time During 12.1.1 Upgrade (Doc ID 1572639.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

12.1.1 patching takes a long time to complete. There appears to be a performance issue with the file artrx.odf, due to creation of indexes.

Review of the upgrade driver log shows:

Assigned: file artrx.odf    on worker  1 for product ar  username AR.

Time is: Thu Jun 20 2013 04:13:29
--
Completed: file artrx.odf    on worker  1 for product ar  username AR.

Time is: Thu Jun 20 2013 05:07:17

Further review of the adworker log captures the following sqls, which are taking time:

The table is missing the index RA_CUSTOMER_TRX_LINES_N4
or index RA_CUSTOMER_TRX_LINES_N4 exists on another table.
Create it with the statement: Start time for statement below is: Thu Jun 20 2013 04:16:26 CREATE INDEX AR.RA_CUSTOMER_TRX_LINES_N4 ON AR.RA_CUSTOMER_TRX_LINES_ALL
(REQUEST_ID, CUSTOMER_TRX_ID, LINE_TYPE) NOLOGGING STORAGE (FREELIST
GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE
STATISTICS PARALLEL TABLESPACE APPS_TS_TX_IDX Statement executed. The table is missing the index RA_CUST_TRX_LINE_GL_DIST_N10
or index RA_CUST_TRX_LINE_GL_DIST_N10 exists on another table.
Create it with the statement:


Start time for statement below is: Thu Jun 20 2013 04:44:51

CREATE INDEX AR.RA_CUST_TRX_LINE_GL_DIST_N10 ON
AR.RA_CUST_TRX_LINE_GL_DIST_ALL (REQUEST_ID, CUSTOMER_TRX_LINE_ID,
ACCOUNT_SET_FLAG) NOLOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE
APPS_TS_TX_IDX

Statement executed.

 

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