My Oracle Support Banner

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.

Details

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.

Actions

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.NoReported Release VersionSymptomsBug NumberBug AbstractRoot CausePatch NumberFixed file version / File version upgraded by the patch suggestedBehavior 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
gl_bc_packets and
gl_bc_packets_hists tables
<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
PSAXMLRB.pls
<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
PSAXMLRB.pls
<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.
document_status column
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
data.
<Patch.7686612:R12.PSA.A> for R12 & <Patch.7686612:R12.PSA.B> for 12.1 BudgetaryControlResults
  AMImpl.java -
120.4.12000000.4 for R12
& BudgetaryControlResults
  AMImpl.java
- 120.6.12010000.2
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 -
120.50.12000000.7
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
  ResultsCO.java
 - 120.14.12000000.10 &
PSAXMLRB.pls -
120.49.12000000.1
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. <Bug.6125391>

2. <Bug.5949027>
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
120.21.12000000.16
for R12
& POXVENCB.pls
120.23.12010000.12
for 12.1
Fund check can be performed in Buyer Work Center.

 

Latest file versions :

 

Release VersionLatest file versionPatch
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
psa_bc_results_gt.xdf 120.3.12000000.5

POXCOMSG.pld - 120.9.12000000.2
<Patch.9881400:R12.PSA.A>

<Patch.9100984:R12.PSA.A> (PSA RUP)

<Patch.8555643:R12.PO.A>
12.1.1 psampst.odf - 120.52.12010000.16
PSAXMLRB.pls - 120.63.12010000.13

BudgetaryControlResultsCO.java 120.23.12010000.2
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.9881400:R12.PSA.B>

<Patch 9100984:R12.PSA.B>(PSA rup)

<Patch.8555643:R12.PO.B>
12.1.2    
12.1.3    

Contacts

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
Details
Actions
 List of Code fixes
 Latest file versions :
Contacts
References

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