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

Last updated on NOVEMBER 15, 2022

Applies to:

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

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