How to Upload or Download Oracle Budgets in GL

[@MdKamal-yn1um]

Thanks for sharing great knowledge. Need more videos on Budgets and encumbrance. Kindly share.

[@getrudemukami5112]

Thanks for the video ,Asante.

[@OracleEbizandFusionVideos]

You are welcome

[@amirulashraf8789]

Thanks for the guide !!

[@OracleEbizandFusionVideos]

Thanks

[@wajdimatoussi]

Thanks do much

[@OracleEbizandFusionVideos]

Thanks

[@CidKleber]

Congratulations for your video !! Could you please take me a doubt ? The "require budget journal" isn't checked in the define budget windows, that's why It was possible upload budget by budget wizard. Is it possible to load budget by WEBADI when the "require budget journal" is checked, if so, do you have any guide about that ? Thanks and best regards.

[@OracleEbizandFusionVideos]

I tried and i think the Budget dropdown in Web ADI is showing only those budgets where "Require Budget journals" is unchecked.... May be you can try creating separate budgets and enable this checkbox for those budgets

[@MdKamal-yn1um]

Please provide Project Budget and FA Budget video

[@Marzyart]

Hello. I am getting this message in AP module "an assignment does not exist for these parameters". Plz help how can I solve it?

[@OracleEbizandFusionVideos]

When you performing which transaction are you getting this error?

[@Marzyart]

@OracleEbizandFusionVideos when entering a new invoice in AP module

[@OracleEbizandFusionVideos]

Looks like Document Sequencing is enabled in your environment. If so, you need to set Document Sequencing and then retest

[@Marzyart]

@OracleEbizandFusionVideos thank you.

[@jasmin9311]

How can we change "Last" budget period?

[@thackerjignay]

Hi one doubt, can in single budget organization can we enter range from all cost center from 0 to t all together, so that entire business data come in one roof

[@thackerjignay]

So entire business can be uploaded in single request

[@OracleEbizandFusionVideos]

Yes, you can update budgets for all cost centers in single go

[@thackerjignay]

@@OracleEbizandFusionVideos but sir for each cost center we need to create budget org, so same can be done for all budget org

[@OracleEbizandFusionVideos]

As you have seen in my video that Budget and Budget org are mandatory while uploading budgets aand if you have a business requirement of creating each cost center as a Budget org, then probably, in your case it would not be possible to upload budgets for entire org through single upload... You need to look and find if there is any available API for the same

[@Raj-xw1lv]

If budget is applicable in system then it is mandatory to take the subledger accounting method as Encumberance accounting..?

[@OracleEbizandFusionVideos]

When you say budget is applicable in system, do you mean Budgetory control is enabled for ledger?

[@Raj-xw1lv]

@@OracleEbizandFusionVideos I mean to say there are two subledger accounting method standard accrual and standard encumberance. If company using the budget system then subledger accounting method must be Encumberance or accrual in 4,Cs set ups.. And last thing is there any other mandatory set up required for budget which has not been included in ur budget tutorial..

[@OracleEbizandFusionVideos]

Going back to your original question, if you have uploaded budgets for a company, its not mandatory to enable Encumbrance accounting or use encumbrance functionality. If you want to use funds check i.e. ensure that the actuals do not exceed budget then you need to go for encumbrance accounting and accordingly you need to use SLAM related to Encumbrance accounting

[@Raj-xw1lv]

@@OracleEbizandFusionVideos Thanku so much for making me understand in very easy way..😀

[@financefunctional2238]

Hi Arvind, Thanks for uploading such short video with lots of information and knowledge. Is there any control for the Budget period in Oracle EBS? I have observed that if the GL period is closed, the budget journal can be posted. If we want to restrict user from entering budget for a particular period or year how can we achieve the same?

[@financefunctional2238]

In addition to the first query is there any separate budget period control in EBS like we have in fusion?

[@BOB-gm4wx]

hello when pressing create document i have message The LOV relation that you are trying to add is invalid. , could you help

[@BOB-gm4wx]

found that profile option Set the profile option BNE: Enable Simplified Create Document Set to = No.

[@OracleEbizandFusionVideos]

Great

[@jampanavamsi]

Iam not able fetch my created Budget Name in the Launch Budget Wizard...What is the reason.

[@OracleEbizandFusionVideos]

Are you sure you are using correct resp?

[@OracleEbizandFusionVideos]

Did you follow the steps exactly as mentioned in the video?

[@Raj-xw1lv]

Sir can you tell me the nature of reserve for encumberance a/c and budget account?

[@OracleEbizandFusionVideos]

Do you mean the account type of these natural accounts or the significance of these accounts?

[@sakivelathirumala3598]

Hi, Could you please share us excel macro settings that are required to be able to create the document as on my device document is not getting created. Regards,

[@OracleEbizandFusionVideos]

In near future, i will try to create a video on this for the benefit of my channel subscribers

[@OracleEbizandFusionVideos]

As promised, i had created a video on this topic... Please refer the below URL of the video:- kzbin.info/www/bejne/jGObfo2raNaJp5I

[@Raj-xw1lv]

For what type of nature account we allocate funds.. Please guide me sir

[@OracleEbizandFusionVideos]

If your question is regarding for what kind of accounts do we assign budgets, then the answer depends upon the business policy of a client. Most of the clients do budgets for different expenses and Revenue.. Some clients do budgets for capital expenditure like purchase of Assets as well...

[@venugopal-gi9jt]

Sir, I could see only frozen option for status field while creating budget,how to get other values

[@OracleEbizandFusionVideos]

Did you exactly follow the steps which i mentioned in my video.... If you follow, then ideally you should be able to see both Frozen and Open

[@venugopal-gi9jt]

@@OracleEbizandFusionVideos Yeah, we have 2 servers, out of which one server is having as you explained in the video. But when I am getting many errors while following the process like 1. Assign Budget Account Ranges resulted in error. 2. General Ledger - Budget Import (Upload Budget Amounts) resulted in error.

[@venugopal-gi9jt]

Even Budget Posting resulted in error

[@venugopal-gi9jt]

@Oracle Ebiz and Fusion Videos, request you to help me in any way to upload budget and account in GL. Or else can we create flat file and migrate it to budget base tables with validations, if yes please send me .csv file and validations to me @[e-mail]

[@OracleEbizandFusionVideos]

@@venugopal-gi9jt What kind of errors?

[@abhitoshkumarviral]

Please create one video on , how to implement Oracle R12. so that we can have the basic understanding, i know its difficult but please try if you could have time. thanks

[@OracleEbizandFusionVideos]

Hi Abhitosh, its difficult in one video as implementing of Oracle R12 at a client site is dependant on so on many different factors

[@yusufza3fran18]

I have an issue - after creating the budget - in AP at Invoice level when I am entering a manual invoice and go to Action Menu >> Check funds. I receive this message (Decision: Encumbrance Accounting has been turned off. ) could you please guide me to know what is the issue.

[@OracleEbizandFusionVideos]

Could you provide me exact error message along with Error code (if any) so that i can help you...

[@yusufza3fran18]

it is not error ... at invoice level >> action menu >> check funds Decision Encumbrance Accounting has been turned off.

[@OracleEbizandFusionVideos]

Did you check if the Sub ledger Accounting method assigned to your ledger is Encumbrance enabled?

[@yusufza3fran18]

I tested both (Encumbrance Accrual - Standard Accrual)

[@OracleEbizandFusionVideos]

Can you double check if Budgetory control is turned off for your ledger?

[@venugopal-gi9jt]

Hi Sir, Can u please explain regarding high and low flex-fields of Account

[@OracleEbizandFusionVideos]

Is this a generic question or related to high and low values which i had selected in this video?

[@venugopal-gi9jt]

@@OracleEbizandFusionVideos This is Generic

[@venugopal-gi9jt]

Hi Sir, In that window I am getting an error, "This account range overlaps another range with same currency in this ledger". Please help to select the fields of low and high

[@OracleEbizandFusionVideos]

@@venugopal-gi9jt Please cross check the account assignments... May be you have selected From as 000 and To as ZZZ for one of the account assignment and then trying to create another row and in this row you are using some accounts which are already included under 000 to ZZZ

[@venugopal-gi9jt]

Can Someone tell me, Do we need to install any software to allow excel to open the WebADI Document? It is giving me Run-time error 1004. Method 'VBProject' of object '_Workbook' failed with enabled options end, debug, help.

[@OracleEbizandFusionVideos]

You need not install any software..

[@OracleEbizandFusionVideos]

Please refer my below video which explains the Excel settings which you need to make in order to get rid off this VB error message:- kzbin.info/www/bejne/jGObfo2raNaJp5I

[@venugopal-gi9jt]

@@OracleEbizandFusionVideos Than you sir!