My Oracle Support Banner

R12.2 Grants Accounting GMSFCSTR Performance Issue with Costing and Funds Checking on Straight Time Labor (Doc ID 2409798.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Grants Accounting - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

GMSFCSTR - GMS Costing and Funds Checking on Straight Time Labor is taking more and more time each run.

In reviewing the trace the following is the biggest performance hit:

UPDATE GMS_BC_PACKETS BP SET (BP.TASK_BUDGET_POSTED, BP.TASK_ACTUAL_POSTED,
BP.TASK_ENC_POSTED) = (SELECT SUM (NVL (BUDGET_PERIOD_TO_DATE, 0) * DECODE
(BALANCE_TYPE, 'BGT', 1, 0)), SUM (NVL (ACTUAL_PERIOD_TO_DATE, 0) * DECODE
(BALANCE_TYPE, 'EXP', 1, 0)), SUM (NVL (ENCUMB_PERIOD_TO_DATE, 0) * DECODE
(BALANCE_TYPE, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0)) FROM GMS_BALANCES
GB
WHERE
GB.BUDGET_VERSION_ID = BP.BUDGET_VERSION_ID AND GB.PROJECT_ID =
BP.PROJECT_ID AND GB.AWARD_ID = BP.AWARD_ID AND ( (BP.BUD_TASK_ID = 0) OR
(BP.BUD_TASK_ID > 0 AND GB.TASK_ID = BP.BUD_TASK_ID AND BP.TASK_ID =
BP.BUD_TASK_ID) OR (BP.BUD_TASK_ID > 0 AND BP.TOP_TASK_ID = BP.BUD_TASK_ID
AND DECODE (GB.TOP_TASK_ID, NULL, GB.TASK_ID, GB.TOP_TASK_ID) =
BP.TOP_TASK_ID ) ) AND GB.BALANCE_TYPE <> 'REV' AND GB.START_DATE BETWEEN
DECODE ( BP.TIME_PHASED_TYPE_CODE, 'N', GB.START_DATE,
BP.BUDGET_PERIOD_START_DATE) AND DECODE ( BP.TIME_PHASED_TYPE_CODE, 'N',
GB.START_DATE, BP.BUDGET_PERIOD_END_DATE) AND GB.END_DATE BETWEEN DECODE (
BP.TIME_PHASED_TYPE_CODE, 'N', GB.END_DATE, BP.BUDGET_PERIOD_START_DATE)
AND DECODE ( BP.TIME_PHASED_TYPE_CODE, 'N', GB.END_DATE,
BP.BUDGET_PERIOD_END_DATE)) WHERE BP.PACKET_ID = :B1 AND
BP.EFFECT_ON_FUNDS_CODE = 'D' AND BP.STATUS_CODE = 'P' AND
BP.T_FUNDS_CONTROL_LEVEL_CODE <> 'N' AND BP.BUD_TASK_ID <> 0



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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.