Skip to main content

Troubleshooting Fund Check/Budgetary Control Guide

Troubleshooting Fund Check/Budgetary Control Guide -Part 1

Troubleshooting Details A) Common Setup

Profile Options
PA: Enable Budgetary Controls
PA: Allow Override of Budget Accounts
PA: Days to Maintain BC Packets
PSA: Budgetary Control Report Template (R12)

i)Bottom-Up Budgeting Setup/Processing Steps

Perform the following tasks to implement Bottom-Up Budgeting:
1. Define the Project Budget Account Workflow process
2. Define the Allow Override of Budget Accounts profile option
3. Define the Enable Budgetary Controls profile option
4. Define the GL budget
5. Define Integration for the Project Type/Project
6. Define the Project Budget
7. Generate accounting information for each budget line
8. Optionally, override the generated account for specific budget lines
9. Baseline the Project Budget
10. Run the Program: Create Journals process
11. Post the GL journal batches


ii)Bottom-Up Budgeting Integration Definition

Field Descriptions:

Allow Override at Project Level - Default or Dictate settings for projects using this project type.
Budget Type - Select from the defined project budget types. The list of values will not include project budget types that have baselined budget versions.
Balance Type - For Bottom-Up Budgeting the Balance Type must be Budget.
Non-Project Budget - Select a defined General Ledger budget. The list of values will only include GL budgets with a status of ‘Open’ or ‘Current’.
Remaining Fields - All remaining fields should be null

iii)Bottom-Up Budgeting Troubleshooting Tips

1. Account Generation Fails
Verify the Budget Account Workflow definition.
Is Dynamic Insertion enabled in General Ledger.
2. Budget Baseline Process Fails
Will the resulting budget journals reduce GL available funds to less than zero.
Does the budget contain a new or changed budget amount for a closed GL Period.


j)Top-Down Budgeting Setup

Perform the following tasks to implement Top-Down Budgeting:


-Define the Project Budget Account Workflow process
-Define the Allow Override of Budget Accounts profile option
-Define the Enable Budgetary Controls profile option
-Define the PA: Days to Maintain BC Packets profile option
-Define the PA encumbrance type
-Define the GL/CC budget
-Setup encumbrance in GL, PO, AP
-Define Integration for the Project Type/Project
-Define the Project Budget
-Generate accounting information for each budget line
-Optionally, override generated accounts
-Baseline the Project Budget

jj)Top-Down Budgeting Restrictions

-Supported for Oracle General Ledger and Oracle Contract Commitment funding only
-The budget entry method must be time phased by GL Period.
-Project budget amounts in open GL Periods.
-A budget line must exist for each budget period
-Cross Charge transactions are not supported

jjj)Top-down Budgeting Troubleshooting Tips

1.Transaction Fails Funds Check
Does a Baselined Budget exist.
Do budget lines exist for all project levels that have a control level other than ‘None’.
Is the transaction amount greater than available funds.
Was the PRC: Update Project Summary Amounts After Resource List Change ran after a new resource member was added.
2.Account Generation Fails
Verify the Budget Account Workflow definition.
Is Dynamic Insertion enabled in General Ledger.
3. Budget Baseline Process Fails
Will the resulting budget journals reduce GL available funds to less than zero.
Does the budget contain a new or changed budget amount for a closed GL Period.
Is the Budget amount greater than current actual plus commitment balances.


k)Non-Integrated Budgets Setup

-Enable BC in GL and encumbrance accounting in Oracle Payables or/and Oracle Purchasing
-Define the PA: Enable Budgetary Controls profile option
-Define the PA: Days to Maintain BC Packets profile option
-Enable Budgetary Controls for Project Type/Project
-Define Control Level Defaults and Time Intervals
-Create and Baseline a Cost Budget
-Update the Control Levels for your Baselined Budget
    Resource List
    Project/Task
    Resource Groups/Resources

kk)Non-Integrated Budgets Troubleshooting Tips

1. Transaction Fails Funds Check
Baselined Budget must exist.
Budget Line must exist if control level is not ‘None’.
Available funds must exceed transaction amount.
PRC: Update Project Summary Amounts After Resource List Change must be ran when a new resource member is added.
2. Budget Baseline Process Fails
Budget amount must be greater than current actual plus commitment balances.
3. The following processes fail to interface transactions:
Interface Usage and Miscellaneous Costs to GL
Interface Total Burdened Costs to GL

The Maintain Budgetary Control Balances process must be ran.
4. Data corruption in funds-related tables and cause failures during funds validation processing

Either BC in GL or encumbrance accounting in AP or PO have been changed ( disabled)


l)Troubleshooting Baseline/Transactions Failures

-Use the Transactions Funds Check Results form to review funds check failures
-Use the Transactions Funds Check Results form to review funds check failures that occur during transaction processing.
-Review Funds Check Result Messages and identify the corrective action see Note 445119.1 and/or Oracle Project Management User Guide pag 6-111
-Always check PA_BC_PACKETS table,where funds check errors are present

B)General Troubleshooting

1.See Note 296559.1 -Common Tracing Techniques within the Oracle
2. Note 301372.1 - How to Generate a Raw Trace File Including Binds and Waits for a Concurrent Program for 11.5.10

3. To debug workflow issues verify/check
-Note 224308.1 -Account Generator & Workflow Frequently Asked Questions
-Note.116375.1-Workflow How to Get Information Required to Run wfstatus/wfstat.sql
-Note 187071.1- bde_wf_item.sql - Runtime Data of a Single Workflow Item

C)Troubleshooting Budget Workflow

1.PABDACWF ORA-20002: 3136: Item 'PABDACWF/#SYNCH' Cannot be Accessed
See Note 744359.1 for solution
2. ORA-20002: 3135: 'Wf_Engine.Notification' is not permitted in synchronous processes
See Note 334232.1 for solution
3. Unable to baseline a budget through workflow budget remains in 'In progress" status
See Note 552483.1 for solution

4. Modifying Existing Budget Gets Rejected in Workflow With ORA-1422
See Note 396515.1 for solution
5. PAWFBUI - PAXBUEBU: Error ORA-6502 In Workflow When Budget Is Baselined
See Note 336055.1 for solution
6. Workflow background process for PAWFBUI has performance issues
Apply Bi -monthly rollup Patch 7364558 or consolidated
Patch 7584055  This patch fixes critical fund check issues

D)Troubleshooting Budget/Fund check 

1.For code issues/fixes see Note 745300.1 -Fund Check and Budgetary Control Troubleshooting Guide part 2
2.Check latest fund check consolidated Patch 7584055 applicable on top of 11i.PJ_PF.M
3.For Budget/Fund check datafixes see unpublished Note 820963.1-Troubleshooting Guide for Funds Check/Budgetary Controls Data Issues
4. Note.732309.1-R12.0.6+ Oracle Projects Funds Check Data Collection Transaction Data Test:
5. Note.423519.1-11i Oracle Project Costing Funds Check Data Collection Data Collection Test:  

Labels:

Comments

Post a Comment

Popular posts from this blog

R12 Oracle E-Business Tax Configuration Guide

Applies to: Oracle E-Business Tax - Version: 12.0 to 12.2 Information in this document applies to any platform. Abstract R12 Oracle E-Business Tax Configuration Guide Document History R12 Oracle E-Business Tax Configuration 1. Tax Basic Tax Configuration Tax Definition: comprises the tax data that you set up for each tax regime and tax that your company or institution is subject to. The Tax Authority designates the regulations and rates that apply to the tax regime. Required Task List a) External Dependencies Create First Party: Legal Entity and Establishments Create Reporting and Collecting Tax Authorities b) Tax Configuration Create Tax Authorities Party Tax Profiles Create Tax Regimes Create First Party Legal Entity Party Tax Profile Create Tax Create Tax Status Create Tax Jurisdictions Tax Rate Responsibility: Tax Manager Path: Tax Managers -> Tax Managers -> Home Complete the following setup tasks: -Legal Entities and Establishments -Reporting and Collecting Tax Authorities ...
1 comment
Read more

Create Accounting for a Payment generates errors 95333 and 95359

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...
15 comments
Read more

R12: Payables Holds Explained – Why They are Applied and How to Remove

Invoice Validation checks the matching, tax, period status, exchange rate, and distribution information for invoices you enter. If an invoice has a hold, you can release the hold by correcting the exception that caused Invoice Validation to apply the hold by updating the invoice or the purchase order, or changing the invoice tolerances. Then resubmit Invoice Validation to release the hold. In the Invoice Holds tab, you can manually release certain invoice holds, even if you have not resolved the matching error condition. Here are some of the regular holds and explanation Account Holds Payables uses holds with this type to identify invoices with invalid or incorrect accounts. An invalid account prevents payment of an invoice and prevents Payables from creating accounting entries for an invoice or payment. Dist Acct Invalid:  Invoice distribution distributed to invalid account. To release the holds you must correct account and resubmit invoice validation. ERV Acct Invalid: ...
Post a Comment
Read more