R12: Billing Tab On Implementation Options Form Will Take 10-12 Hours To Open
(Doc ID 2511320.1)
Last updated on JULY 08, 2020
Applies to:
Oracle Project Billing - Version 12.1.3 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |