My Oracle Support Banner

Federal Projects PaAgrViewAllocationPG View Agreement Summary Amounts Errors, JBO-27122 SQL error during statement preparation. (Doc ID 2758741.1)

Last updated on MARCH 08, 2021

Applies to:

Oracle Project Billing - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

From the Agreement page in self service, trying to view the Funding Summary Amounts, but errors appear.

Navigation:
1. > Federal Projects self service responsibility > Projects: Billing > Agreements.
2. In the Search Agreement page under Simple Search, enter Customer Name. Click the Go button. Should be able to see the Agreement Numbers pulled.
3. Under the Agreement Number, choose Action=View Funding. Click the Go button.
4. In the View Funding page, see the error of,

Error
The descriptive flexfield with application name Projects (PA) and name Agreements (PA_AGREEMENTS_DESC_FLEX) is not frozen. Please contact your system administrator.

5. In the View Funding page, expand the Summary Amounts by clicking the right arrow button. Another page is pulled with the following error.

Error Page
You have encountered an unexpected error. Please contact your System Administrator for assistance.
Click here for exception details. (link)

Click the 'Click here for exception details' link. See the error of,

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PAG.AGREEMENT_ID,
AVG(DECODE(PAG.ADVANCE_REQUIRED_FLAG , 'Y',NVL(ADVANCE_AMOUNT, 0),NVL(AMOUNT,0))) SUMMARY_AMT,
SUM(NVL(PAV.TOTAL_ALLOCATED,0)) TOTAL_ALLOC_AMT,
AVG(NVL(PAG.PROPOSED_ADVANCE_AMOUNT,0)) PROPOSED_ADVANCE_AMT,
AVG(NVL(PAG.ADVANCE_AMOUNT,0)) APPROVED_ADVANCE_AMT,
SUM(NVL(PAV.TOTAL_BASELINED_AMOUNT, 0)) BASELINED_AMT,
SUM(NVL(PAV.TOTAL_UNBASELINED_AMOUNT, 0)) UNBASELINED_AMT,
SUM(NVL(PAV.TOTAL_BILLED_AMOUNT, 0)) INVOICED_AMT,
SUM(NVL(pav.TOTAL_REVENUE, 0)) NET_REVENUE,
MAX(PAV.FUNDING_CURRENCY_CODE) FUNDING_CURRENCY,
MAX(PAG.AGREEMENT_CURRENCY_CODE) AGREEMENT_CURRENCY
FROM PA_SUMMARY_PROJECT_FUNDINGS_V PAV, PA_AGREEMENTS_V PAG
WHERE PAG.AGREEMENT_ID = :1
AND PAG.AGREEMENT_ID = PAV.AGREEMENT_ID(+)
GROUP BY PAG.AGREEMENT_ID



Changes

None

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


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