Budget Upload and Absolute Control
From: seetha raman [mailto:seeethu@hotmail.com]
Sent: Monday, June 21, 1999 3:57 AM
Subject: BUDGET UPLOAD & ABSOLUTE CONTROL
Hi all,
Can I have absolute control if I upload budget amounts.
Thanks in advance for clarification
seetha
Date: Mon, 21 Jun 1999 08:54:29 -0400
From: "Farber, Andy" farban@consumer.org
Subject: RE: BUDGET UPLOAD & ABSOLUTE CONTROL
No, you cannot use budget upload, or the budget enter form, to your control
budget for absolute (or any other) budgetary control.
You CAN use ADI (formerly GLDI) to upload budget journal entries, or you can
use budget upload or budget enter to one budget structure, and then use
MassAllocation to create journal entries to copy the budget from the first
structure to the control budget.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Revenue Budgets
On Sat, 19 Jun 1999 13:22:47 Jim Phillips wrote:
All,
I would like to know how Revenue Budgets can be entered and handled in
Oracle General Ledger....The client does revenue budgets for estimated
revenues....Any help on how to enter them and the navigation path woudl
be greatly appreciated
Need this ASAP for Monday...thanks for all the replies.
From: Saranath P [mailto:saran_p@mailcity.com]
Sent: Sunday, June 20, 1999 10:35 PM
Subject: Re: GL - Revenue Budgets - URGENT HELP!!!
Process for entry of revenue budgets will be the same as Expenses budget.
However, I'm sure your client would like to have the revenue budget purely
for comparison purposes and there need not be any budgetary control. Hence,
1. you have to define a budget which does not require budget Journals
2. Define a budget organisation with appropriate account ranges. Set funds
check level as None.
3. Enter budget amounts using the budget org defined above and budget
defined in step1.
Budget Vs Actual comparison could be done through FSG Reports
Hope it helps
---
Prabu B
Date: Tue, 22 Jun 1999 09:09:46 -0400
From: "Farber, Andy" farban@consumer.org
Subject: RE: GL - Revenue Budgets - URGENT HELP!!!
We maintain revenue budgets along with our expense budgets; they are
included in the budgetary control structure. This permits us to issue
refunds charged directly to the refund accounts, which are setup as contra
revenue accounts.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Budget Organisation Name and Budget Name
Date: Tue, 29 Jun 1999 07:48:46 GMT
From: Akshay Bhatt akshayobhatt@hotmail.com
Subject: RE:Changing Budget Organisation Name and Budget Name
We already have around 40 budget organisations defined with proper account
assignments. To identify the organisation with the associated accounts, we
now want to change the names of the budget organisations to add account code
as a prefix/suffix to the existing Budget Organisation Name. This is being
allowed in the form. However this kind of change is not discussed in the
Help files or Manuals. Is it permitted to change the Budget Organisation
names at any time after definition. Any risks involved in this?
Similarly can we change the Budget Names at a later date? Can you reply
soon, this is very urgent.
Thanks is advance
Regards
Sunil
Date: Mon, 5 Jul 1999 00:09:21 -0400
From: "Farber, Andy" farban@consumer.org
Subject: RE: Changing Budget Organisation Name and Budget Name
We've changed budget org names without any problems. Generally, if the form
lets you change a field, I would think it is safe to do so...
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Mass change of Budgets for Projects
Date: Tue, 29 Jun 1999 15:20:27 -0400
From: "Reddy, Rajasekhar" Rajasekhar.Reddy@fmr.com
Subject: Oracle Projects Budgeting
Hi,
In our Oracle Projects one of the task has the following WBS
8 (Top Task)
8.1 (Middle Task)
8.1.1 (Lowest Task)
8.2(Middle Task)
8.2.1(Lowest Task)
....
8.9(Middle Task)
8.9.1(Lowest Task)
We are doing budgeting at top task and lowest task. All the projects
at this task
have budget amount at top task 8 and for some reasons we want to
change the amount
from top task (8) to lowest task 8.7.1.
Is there a simple way to do this for all the projects?
Any help will be greatly appreciated.
Thanks...Raj
Date: Wed, 30 Jun 1999 09:20:32 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: Oracle Projects Budgeting
As I understant it, budge changes are project specific - no mass changes
available.
Bart Robey
KPMG Consulting
Encumberance - not approving when funds are available
Date: Sat, 24 Jul 1999 09:44:40 GMT
From: "Akshay Bhatt" akshayobhatt@hotmail.com
Subject: RE: Funds Checker-Urgent
Dear List subscribers
We have absolute budgetary control and use encumbrance accounting. For one
of the combinations the Funds Inquiry screen in GL reflects funds available,
however during requisition approval it fails approval due to insufficient
funds. Its a great puzzle for us and we are unable to find the reasons.
Are there any bugs in this functionality? Is this bug anyway related to the
Y2k Patch. Did anyone face a similar situation. Please write back Urgently.
Thanks in Advance
Akshay
Date: Mon, 26 Jul 1999 00:05:17 -0400
From: "Farber, Andy" farban@consumer.org
Subject: RE: Funds Checker-Urgent
We face this problem on often, particularly as we get into the fiscal year.
I don't believe it is related to Y2K patches, since we've been struggling
with it since 1994.
The problems can be in lots of places - probably from a buggy encumbrance
transaction. Try looking at all the encumbrance balances for the account,
and for the related detail accounts if you are employing summary accounts.
FYI, I'm presenting a paper at Fall OAUG entitled: "Show Me the Funds -
Tracking Funds Available through Oracle Financials" on just this topic...
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Budget Org and FlexField Security Rule
Date: Tue, 3 Aug 1999 14:33:50 -0400
From: "Farber, Andy" farban@consumer.org
Subject: GL: Budget Orgs, Flexfield Security, and Content Sets
Is there any way to tie the Budget Organization and Flexfield Security Rules
together?
Is there any way to limit an FSG to accounts by Budget Org?
We deliver monthly account reports to each department, determined by Content
Set.
We limit access for on-line account and funds inquiry by flexfield security
rules.
We limit coding of requisitions by flexfield security rules.
We are contemplating setting up budget orgs for each budgeting department,
which will mirror the Content Sets and the flexfield security rules that we
already have. Maintaining just one of these is a bit of a nightmare; I'm
looking for a method to avoid having to maintain and synchronize three sets
of the same rules.
Thanks.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
Date: Tue, 03 Aug 1999 11:55:33 -0700
From: "Heman Randhawa" hRandhawa@mvsn.com
Subject: Re: GL: Budget Orgs, Flexfield Security, and Content Sets
Yes please see the FSG security rules documentation on how to do that.
You have to set up a few profiles and change the setup in Sys Admin.,
Oracle support can send you the document
Budget upload giving errors
Date: Mon, 04 May 1998 07:11:51 +0200
From: aragab a_ragab@tccbce.com
Subject: Urgent_Budget_Upload_error???????????????????????GL
hi all
I have a probelm when i try to upload the budget i have error
and the report said that
One or more of the following is true:
1. The Accounting Flexfield is either disabled or out of date
2. The Accounting Flexfield is invalid or does not allow detail
budgeting
and the request log said that
BUDG0038: Code combinations have been found and invalid accounts have
been marked with STATUS: A
BUDG0039: Counting total invalid accounts found in gl1val()
BUDG0012: 43 invalid or frozen accounts have been found in this pass
I check all the rules and check if the account allow budget and posting
or not
but i can not solve the problem????????
Thanks In advance
Best Regards / Ahmed Ragab
Date: Wed, 4 Aug 1999 11:43:32 +0800
From: Stephen.Solomon@rac.com.au
Subject: RE: Urgent_Budget_Upload_error???????????????????????GL
Ahmed,
1.This suggests that the account combination that you are trying to post to
do not exist, hence you need to setup the code combinations that it has
failed on or re-enable them if they alreadt exist.
2. As part of the segment qualifiers for each segment and code combination
you can determine whether you wish to allow posting and budgeting to them.
Check your accounts which failed to see whether they fall in this criteria.
Stephen
Date: Mon, 04 May 1998 08:01:58 +0200
From: aragab a_ragab@tccbce.com
Subject: Re: Urgent_Budget_Upload_error???????????????????????GL
Stephen thanks a lot i find the combination disapled
But now do you know how can update them by sql beacuse they are to much
ahmed
Date: Wed, 4 Aug 1999 12:24:58 +0800
From: Stephen.Solomon@rac.com.au
Subject: RE: Urgent_Budget_Upload_error???????????????????????GL
Ahmed,
Best way to do it is actually through the application as if you have
problems Oracle will support it. But you can update it through SQL by
updating the enabled_flag in GL.GL_CODE_COMBINATIONS table for your list of
cobinations.
I guess it is up to you which way you do it but these are the options.
Stephen
Date: Mon, 04 May 1998 08:29:05 +0200
From: aragab a_ragab@tccbce.com
Subject: Re: Urgent_Budget_Upload_error???????????????????????GL
Thanks Stephen
i did it through the application aand evry thing now is ok in my site
............................ please keep in touch
best regards / Ahmed Ragab