My Oracle Support Banner

R12: ORA-06510 ORA-06512 APPS.PA_FP_GEN_FCST_AMT_PUB Error when Using Apply and Generate Amounts Option when Generating a Forecast (Doc ID 2588446.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Project Planning and Control - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When generating a forecast, the following error is received:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.PA_FP_GEN_FCST_AMT_PUB"", line 1038
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.PA_FP_GEN_FCST_AMT_PUB"", line 4949
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.PA_FP_COPY_ACTUALS_PUB"", line 1220
ORA-01403: no data found"
ORA-01403: no data found
"ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.PA_FP_COPY_ACTUALS_PUB"", line 1220
ORA-01403: no data found"
"ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.PA_FP_GEN_FCST_AMT_PUB"", line 4949
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.PA_FP_COPY_ACTUALS_PUB"", line 1220
ORA-01403: no data found

The workaround documented in Bug 5086592: R12.PJ:XB2:QA:CERT: FOREACST GENERATION ERRORING OUT WITH ORA-01403 did not work:

This issue is reproduced only when, you create a forecast version and on create version page select Apply and Generate Amounts. Then on the Generate Forecast page, on clicking generate and edit, for the first time, the error is shown. But on subsequent clicking on generate and edit button again for the same version, the error is not thrown and ETC is generated successfully.

There is a work around to avoid this error:

While creating a forecast version, select apply and edit forecast instead and from the edit forecast page, navigate to the generate forecast page and then try to generate the ETC. In this flow, no error is shown at all.

Changes

 

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
Changes
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.