Assign Territory Accesses Concurrent Program (ASTATA) Clocking 100% Of All CPU Resources (Doc ID 1940276.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Sales Foundation - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

When running Assign Territory Accesses in Total mode,  CPU usage is 100% for all CPUs

Database trace shows the following statement is long running.

INSERT /*+ append parallel(JTF_TAE_1001_ACCOUNT_TRANS)
 */ INTO JTF_TAE_1001_ACCOUNT_TRANS ( SOURCE_ID, TRANS_OBJECT_TYPE_ID, TRANS_OBJECT_ID, TRANS_DETAIL_OBJECT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
 REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, SQUAL_NUM02, SQUAL_NUM04, SQUAL_CHAR08, SQUAL_CHAR09, SQUAL_CURC01, SQUAL_CHAR02, SQUAL_NUM06, SQUAL_CHAR07, SQUAL_CHAR03,
 SQUAL_NUM01, SQUAL_FC01, SQUAL_CHAR01, SQUAL_NUM05, SQUAL_CHAR06, SQUAL_CHAR05, SQUAL_NUM03, SQUAL_CHAR10, SQUAL_CHAR04, SQUAL_CHAR11)
 SELECT -1001, -1002, TRANS_OBJECT_ID, TRANS_DETAIL_OBJECT_ID, SYSDATE, :B5 , SYSDATE, :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE, SQUAL_NUM02, SQUAL_NUM04, SQUAL_CHAR08, SQUAL_CHAR09, SQUAL_CURC01,
 SQUAL_CHAR02, SQUAL_NUM06, SQUAL_CHAR07, SQUAL_CHAR03, SQUAL_NUM01, SQUAL_FC01, SQUAL_CHAR01, SQUAL_NUM05, SQUAL_CHAR06, SQUAL_CHAR05, SQUAL_NUM03, SQUAL_CHAR10, SQUAL_CHAR04,
 SQUAL_CHAR11 FROM AS_TAP_ACCOUNTS_V

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