My Oracle Support Banner

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:

Oracle Project Billing - Version 12.1.3 and later
Information 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


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