Issues With Budgetary Control Results Page - List Of Code Fixes
(Doc ID 1175415.1)
Last updated on JUNE 22, 2017
Applies to:Oracle Purchasing - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
This document is a 'Master Code Fix Note' which consolidates all the code fixes done in the problem category "Issues with Budgetary Control Results page". It includes the issues related to the Budgetary Control Results page which gets opened when clicking 'View Results' for the funds check activity.
For similar such notes refer to the Master Note matrix,
Note 1138043.1 Master Note For Oracle EBS Procurement Suite - Encumbrance And Receipt Accounting
When the funds check is done for PR/PO or when the RESERVE action is done for PR/PO, system will throw the message "Your budgetary control action failed with exceptions" or "Your budgetary control action completed successfully". To view the details about exceptions or details about funds availability, users can click the 'View Results' button available on this message which will open the Budgetary Control Results page. All the code fixes related to this page will be explained in this document.
Code fix note lists the following details for the fix in a tabular format.
* Release version applicable to
* Symptom for the issue fixed
* Bug number
* Root cause
* Patch number released
* Relevant file versions upgraded in the patch
* Post patch behaviour
This document will be updated with all these details whenever a new code fix is done in the problem category.
Whenever you get an issue related to the problem category 'Uninvoiced Receipts Report (URR) & Receipt Accrual Period End Process',
1) Match your issue with the symptoms listed in the table below. The patch mentioned in the column, ' Patch number', for the record will fix the symptom mentioned.
Apply the patch in a test instance first and verify if this resolves your issue.
2) The note also contains the latest code fixes/ file versions available for the problem area discussed.
If you are unable to match your problem with the symptoms listed on the table below, verify your file versions with the versions available on the table given in the end for the respective application release. Apply the latest fix patch(es) mentioned on the table in a test instance and check if this resolves your issue. Check the patch read me for more information on the patch.
It is always recommended that customer upgrade to lastest versions of code when ever possible to avoid running into issues already fixed.
3) If the above actions do not resolve your issue, please log a Service Request with Oracle Support for assistance.
List of Code fixes
|S.No||Reported Release Version||Symptoms||Bug Number||Bug Abstract||Root Cause||Patch Number||Fixed file version / File version upgraded by the patch suggested||Behavior after Patch application|
|1||12 & 12.1||While trying to do 'check funds' for purchasing documents, no
results found in budgetary control page
|<Bug.9881400>||CANNOT VIEW BUDGETARY CONTROL RESULT REPORT IN PURCHASING DOCUMENTS||Product teams are populating
multiple rows in
PSA_BC_REPORT_EVENTS_GT due to code limitation
|<Patch.9881400:R12.PSA.A> for R12 & <Patch.9881400:R12.PSA.B> for 12.1||[psampst.odf - 120.50.12000000.21; PSAXMLRB.pls - 120.49.12000000.27] for R12 & [psampst.odf - 120.52.12010000.16; PSAXMLRB.pls - 120.63.12010000.13] for 12.1||Budgetary Control Results Report pulls in correct data|
|2||12 & 12.1||Budgetary Control Results Report takes long time to get opened on clicking the 'View Results' button after doing funds check for PR/PO||<Bug.9756641>||CHECK FUNDS ON STANDARD PO CREATION IS TAKING TOO LONG TO RESPOND.||In the PSA_BC_REPORT_V view, all the rows are being
selected with out any
join condition on the
|<Patch.9742320:R12.PSA.A> for R12 & <Patch.9742320:R12.PSA.B> for 12.1||[psampst.odf - 120.50.12000000.19; PSAXMLRB.pls - 120.49.12000000.23 ] for R12 & [psampst.odf - 120.52.12010000.14; PSAXMLRB.pls - 120.63.12010000.9] for 12.1||Time taken to do check funds/reserve PR or PO gets reduced|
|3||12 & 12.1||Budgetary Control Results Report takes long time to get opened on clicking the 'View Results' button after doing funds check for PR/PO||<Bug.9261883>||ENG : POOR PERFORMANCE IN BUDGET FUNDS CHECK RESULTS FORM||Code limitation in file
|<Patch.9100984:R12.PSA.A> for R12 & <Patch.9100984:R12.PSA.B> for 12.1||PSAXMLRB.pls -
120.49.12000000.21 for R12 & PSAXMLRB.pls - 120.63.12010000.8 for 12.1
|Budgetary Control Results Report will have better performance|
|4||12 & 12.1||After doing Check funds from Tools on the Requisition/ PO form and on clicking the 'View Results', Budgetary control results report opens, but it does not show the encumbrance type details in the expanded funds available table||<Bug.8912719>||ENCUMBRANCE DETAILS MISSING FROM BUDGETARY CONTROL RESULTS REPORT||PSA_BC_REPORT_V view is not fetching the correct Commitment and Obligation related amounts||<Patch.9100984:R12.PSA.A> for R12 & <Patch.8912719:R12.PSA.B> (Controlled release) for 12.1||[psampst.odf - 120.50.12000000.13; PSABCR.rtf - 120.17.12000000.6] for R12 & [psampst.odf - 120.52.12010000.8; PSABCR.rtf - 120.19.12010000.4] for 12.1||Budgetary Control Results Report pulls in correct data|
|5||12 & 12.1||When India Localization is enabled, the
Budgetary Control Page is opening up with exceptions,when "View Results" button is pressed afer the funds check action on a PO
|<Bug.8555643>||YOUR BUDGETARY CONTROL ACTION COMPLETED WITH EXCEPTIONS||Code limitation in file POXCOMSG.pld||<Patch.8555643:R12.PO.A> for R12 & <Patch.8555643:R12.PO.B> for 12.1||POXCOMSG.pld - 120.9.12000000.2 for R12 & POXCOMSG.pld - 120.9.12010000.2 for 12.1||When India Localization is enabled, the
Budgetary Control Page will get opened without any error
|6||12 & 12.1||Budgetary Control Results Report pulls in incorrect data. The report is pulling in the data for the associated requisition as well as data for another supplier and PO. The data for the other supplier and PO are incorrect. The amount and account are not the actual PO. The report displays correctly if: (1) PO is manually created and (2) PO is copied from
another PO. The error only occurs when there is an associated requisition.
|<Bug.8243863>||BUDGETARY CONTROL RESULTS REPORT PULLS IN INCORRECT DATA||Code limitation in file
|<Patch.8243863:R12.PSA.A> for R12 & <Patch.9138667:R12.PSA.B> for 12.1||PSAXMLRB.pls - 120.49.12000000.16 for R12 & PSAXMLRB.pls - 120.63.12010000.5 for 12.1||Budgetary Control Results Report pulls in correct data|
|7||12.1||After doing Check funds from Tools on the Requisition/ PO form and on clicking the 'View Results', Budgetary control results report does not get opened and system throws the error "No results found, perform Funds Check/Reserve to view the results " . This error happens in non English instance||<Bug.7689063>||TST1211.XB1.QA: UNABLE TO VIEW RESULTS FOR FUNDS CHECK DONE IN KOREAN LANGUAGE||The psa_bc_results_gt.
size has a limitation which
needs to be modified from 30 to 240
|<Patch.7689063:R12.PSA.B>||psa_bc_results_gt.xdf - 120.5.12010000.3||Budgetary Control Results Report will show the correct details in non English instance|
|8||12 & 12.1||Budgetary Control Results html page does not show table headers names in language which user logs into the application with (Arabic).
Headers names are shown in English. The same issue occurs at Requsition and Purchase Orders level.
|<Bug.7686612>||BUDGETARY CONTROL RESULTS PAGE DOES NOT SHOW TABLE NAMES IN ARABIC LANGUAGE||BudgetaryControlResults
AMImpl.java has a query
in getLocale() to get language
and territory. This query is
not correctly returning the
|<Patch.7686612:R12.PSA.A> for R12 & <Patch.7686612:R12.PSA.B> for 12.1||BudgetaryControlResults
120.4.12000000.4 for R12
|Budgetary Control Results Report shows table headers in non English language|
|9||12 & 12.1||When attempting to reserve funds for a code combination, the amount is added to the budget instead of getting subtracted in the View results screen resulting in increase in funds availability instead of reducing it. But the funds inquiry shows correct amounts, only the Budgetary control Results page shows incorrect funds availability||<Bug.7003238>||FUNDS CHECK SCREEN CALCULATES INCORRECTLY. SEE ATTACHED DOCUMENT.||Transaction_Amount is calculated wrongly for Revenue, Liability and Owner's equity account types in psa_bc_report_v view. Hence Current Funds Available is also shown wrongly in the report||<Patch.7003238:R12.PSA.A> for R12 & <Patch.7003238:R12.PSA.B> for 12.1||psampst.odf -
for R12 & psampst.odf
120.52.12010000.3 for 12.1
|Budgetary Control Results Report will show the correct funds availability for all types of accounts|
|10||12.0.6||After doing Check funds from Tools on the Requisition/ PO form and on clicking the 'View Results', Budgetary control results page does not show details for both English and non English language. It shows the error "The page cannot be found.HTTP404 - File not found"||<Bug.6497863>||R12: PO: REQUISITION CHECK FUND - CANNOT VIEW BUDGETARY CONTROL RESULT REPORT||xml encoding was done in IS0-8859-1 previously and retrieval of CLOB from db doesn't involve character encoding and BlobDomain usage. This resulted in 'Page Not Found' Error when trying to access PSA Budgetary Control Results Report||<Patch.6445210:R12.PSA.A>||BudgetaryControl
- 120.14.12000000.10 &
|Budgetary Control Results Report will show the correct details for both English and non English language|
|11||12.0.6||1. Budgetary control results page does not show the lines for the summary template when the budget account used in PR/PO is attached to summary account. This issue happens only when the report is opened from subledgers and not when funds check is done for manual journal in GL
2. After doing Check funds from Tools on the Requisition form and on clicking the 'View Results', Budgetary control results page does not get opened. This issue happens only when the requisition line is sourced to a blanket agreement which is encumbered
|1. R12 CERT : PSA SUMMARY TEMPLATE NOT DISPLAYED ON BUDGETARY CONTROL RESULTS
2. POCT:NO DETAILS IN BUDG CONTROL RESULTS WHEN ENC IS PREVENTED
|Code limitation in file PSAXMLRB.pls||<Patch.6473924:R12.PSA.A>||PSAXMLRB.pls - 120.49.12000000.14||Budgetary Control Results page opens up on clicking the'View Results' and will show the correct data|
|12||12 & 12.1||Getting "No results found" error when attempting to perform check funds for complex and standard PO in Buyer Work Center (BWC).||<Bug.13077585>||NO RESULTS FOUND, PERFORM FUNDS CHECK/RESERVE TO VIEW THE RESULTS||The draft and invalid events are being present in po_bc_distributions and xla tables on which the report depends.||<Patch.13077585>:R12.PO.B for R12 & <Patch.13077585>:R12.PO.A for 12.1||POXVENCB.pls
|Fund check can be performed in Buyer Work Center.|
Latest file versions :
|Release Version||Latest file version||Patch|
|12.0.4||psampst.odf - 120.50.12000000.21
PSAXMLRB.pls - 120.49.12000000.27
PSABCR.rtf - 120.17.12000000.6
BudgetaryControlResultsAMImpl.java - 120.4.12000000.4
BudgetaryControlResultsCO.java - 120.14.12000000.11
POXCOMSG.pld - 120.9.12000000.2
<Patch.9100984:R12.PSA.A> (PSA RUP)
|12.1.1||psampst.odf - 120.52.12010000.16
PSAXMLRB.pls - 120.63.12010000.13
BudgetaryControlResultsAMImpl.java - 120.6.12010000.2
psa_bc_results_gt.xdf - 120.5.12010000.3
PSABCR.rtf - 120.19.12010000.4
POXCOMSG.pld - 120.9.12010000.2
<Patch 9100984:R12.PSA.B>(PSA rup)
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
|List of Code fixes|
|Latest file versions :|