R12: Billing Tab On Implementation Options Form Will Take 10-12 Hours To Open (Doc ID 2511320.1)

Last updated on JUNE 09, 2019

Applies to:

Symptoms

Since upgrading to R12, the Billing tab on Implementations takes 10-12 hours to open.

From <bug 27804260> - PERF:BILLING TAB ON IMPLEMENTATIONS FORM TAKES SEVERAL HOURS TO OPEN

Problem query:

SELECT 'Y'
FROM
DUAL WHERE EXISTS (SELECT P.PROJECT_ID FROM PA_PROJECTS P, PA_TASKS T WHERE
 P.PROJECT_ID = T.PROJECT_ID AND EXISTS (SELECT NULL FROM
 PA_STD_BILL_RATE_SCHEDULES_ALL BR WHERE ( (T.JOB_BILL_RATE_SCHEDULE_ID =
 BR.BILL_RATE_SCH_ID AND NVL(P.ORG_ID,-99) <> NVL(BR.ORG_ID,-99)) OR (
 T.EMP_BILL_RATE_SCHEDULE_ID = BR.BILL_RATE_SCH_ID AND NVL(P.ORG_ID,-99) <>
 NVL(BR.ORG_ID,-99)) OR ( T.NON_LAB_STD_BILL_RT_SCH_ID = BR.BILL_RATE_SCH_ID
 AND NVL(P.ORG_ID,-99) <> NVL(BR.ORG_ID,-99)) ))

Cause

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