|Oracle Loans User Guide|
Part Number E13646-04
This chapter describes setting up budgetary control.
This chapter covers the following topics:
Budgetary Control provides systematic enforcement of spending limits based on availability of funds before loan approval. Oracle Loans integrates with Oracle U.S. Federal Financials to generate accounting entries for the budgetary control of funds. Loan agents can check in real time, whether funds are available to cover the amount of a loan application.
If Approval Depends on Fund Availability is checked while creating the Loan Type, Loans automatically allocates funds for the entire loan amount at loan approval. It also reduces the budget accounts according to the U.S. Federal Accounting Subledger Accounting Methods.
If loan approval is not linked to fund availability, the funds are reserved on the first disbursement.
This is only available for organizations in the U.S. Federal government that offer direct loans and use Oracle U.S. Federal Financials. Other installations of Loans will not be able to view budgetary control features.
To set up budgetary control perform the following steps:
Oracle General Ledger Setup, Oracle General Ledger Implementation Guide.
Oracle U.S. Federal Financials Setup Overview, Oracle US Federal Financials Implementation Guide.
Oracle Loans Setup for Budgetary Control.
Create Loan Product with Budgetary Attributes
Create Default Accounting
Map Fund Value
You can perform this setup only if you set up budgetary control in Oracle General Ledger. For further information, see: Overview of Budgeting, Oracle General Ledger User's Guide.
Creating Loan Product with Budgetary Control Attributes
Login as Loan Administrator and click Accounting under Setup: Your organization: Loan Products.
Create a Loan Product.
Select Approval Depends on Funds Availability (optional).
Ensure a valid Subsidy Rate exists in the Subsidy Rate tab.
Create Default Accounting for Loan Product
Login as Loan Administrator and click Accounting under Setup : U.S. Federal Government.
Ensure the Year and Fiscal Year Segments match the Budget Year.
Fund Segment must match the Mapped Fund setup.
Limitations, Program and Cost Center should match the corresponding fields in Budget Execution.
The SGL or Natural Account used for Budget Execution must match the overlaid natural account segment set up in SLA account.
See: Accounting Derivation Rules
Fund Value Mapping
Login as Loan Administrator and click Fund Value Mapping under Setup : <Operating Unit>.
Query the Federal Account Symbol Name you created as part of Federal setup.
Select a Financing Account.
Select Matching Program Account Treasury Account Symbol.
Note: The Federal Account Symbol needs to have at least one fund value mapped to it.
While setting up loan types, the Approval Depends on Funds Availability option is only available to organizations in the U.S. Federal Government that offer direct loans. If set to Yes, the loan manager cannot approve the loan if funds are not available. If set to No, the manager can approve the loan but no funds are reserved. Disbursement cannot be made before funds are reserved.
The Subsidy Rate tab will be visible only to organizations in the U.S. Federal Government that have Federal Financials enabled and is associated with a ledger with U.S. Federal Accounting Method. The Start Date of the Subsidy Rate can be the same or later than the Start Date of the Loan Product. The Start and End Date of the Subsidy Rate cannot overlap for different rates.
Copyright © 2005, 2010, Oracle and/or its affiliates. All rights reserved.