Oracle Mass Allocation Process

[@shaileshverma4354]

Thanks so much Sir for uploading such informative videos..

[@OracleEbizandFusionVideos]

Thanks Shailesh

[@gadderevathi]

Thanks so much for this wonderful video

[@OracleEbizandFusionVideos]

Glad you enjoyed it!

[@srikanthgo3915]

Super ..i liked the way ur explaing

[@OracleEbizandFusionVideos]

Thanks

[@ikfodkar]

Nice video. What is inside the documents options?

[@CidKleber]

Hi ! Congratulations by great video !! based on your example, every month I need to create a STAT journal in order to define the rule, even if the percentage doesn't change ? is there a way to use the STAT journal every month ? Thanks.

[@OracleEbizandFusionVideos]

You need to create STAT journal every month even though there is no change in percentage... But, you can try the below options through which you can create same STAT Journal every month:- 1. You can use Autocopy functionality to copy the STAT journal every month. 2. You can try uploading same STAT journal using Web ADI tool 3. You can try creating a recurring journal template and generate a recurring STAT journal every month

[@CidKleber]

@@OracleEbizandFusionVideos thank you very much !! Please keep uploading videos like this.

[@OracleEbizandFusionVideos]

Sure

[@veerabhadra4708]

Thank you Arvind 👍

[@OracleEbizandFusionVideos]

My pleasure

[@KumR]

Awesome Video. Thank you.

[@OracleEbizandFusionVideos]

Thanks

[@kirankumarkottakota3414]

nice video, can you please share your video's on recurring journals & Mass allocation in fusion

[@OracleEbizandFusionVideos]

Sure

[@kirankumarkottakota3414]

@@OracleEbizandFusionVideos Hi Sir could you please post Journal allocation in fusion

[@madanurs6993]

Good explanation.. Thanks try to do more videos..

[@OracleEbizandFusionVideos]

Thanks

[@krishnasura3684]

Please post videos on EB TAX End to End Implementation and Transactions flow

[@OracleEbizandFusionVideos]

Hi Sura Krishna, give me your email id and we can discuss on this

[@krishnasura3684]

[e-mail]

[@OracleEbizandFusionVideos]

Check your email.

[@OracleEbizandFusionVideos]

Based on your request i had created my first video on Ebtax. Stay tuned to my cannel for more videos on Ebtax:- kzbin.info/www/bejne/eIa9mJmLqr2Jiqc

[@veerabhadra4708]

Arvind! If possible make one video for mass allocation for Fusion please

[@OracleEbizandFusionVideos]

Sure

[@SumitKumar-uj8jo]

Awesome

[@anandrsutube]

Thankyou, very clear. Awaiting more videos on various topics on different modules

[@OracleEbizandFusionVideos]

Hope you are following my channel... I started videos on fusion as well....

[@khushboovarshney319]

Hi Arvind - Do we have mass allocations in Oracle GL Cloud?

[@OracleEbizandFusionVideos]

Yes... it exists... Its already in my to do list to create a video on Mass Allocations in fusion cloud

[@ghodighosh9050]

What if there are more than one stat journals? How will be the system know which STAT journal to use?

[@OracleEbizandFusionVideos]

System will use the sum of all STAT journals for that period/Quarter/Year depending upon what ever you have selected in your Mass Allocation formula

[@CidKleber]

Hi ! Could you please take a doubt ? The OFFSET ACCOUNT (O) in my formula needs to be an accounting combination range instead of only one accounting combination. Is it possible to do this ? Best regards.

[@OracleEbizandFusionVideos]

What about the Source account? Even source account also needs to be range instead of single Account code combination?

[@CidKleber]

@@OracleEbizandFusionVideos Thanks for your prompt feedback. The account and the intercompany segments are different but the cost center is the same. Example: COA = COMPANY . ACCOUNT . COST CENTER. INTERCOMPANY The journal line for the OFFSET ACCOUNT (0) should be like this: (1) 129.123001.8001.101 (2) 129.123029.8001.102

[@OracleEbizandFusionVideos]

I doubt if its possible to have two offset accounts. Did you try creating two separate Mass Allocation batches and checked if thats meeting your business requirement?

[@CidKleber]

@@OracleEbizandFusionVideos Hi ! I have the same doubt. As test I’ve created 2 formulas in the same batch and It worked as expected the process created 2 allocation journal for a single batch. This is much more work but I think it can meet the business requirement. Thanks !!

[@OracleEbizandFusionVideos]

Its just a one time task to setup the required formulas... so, even if its take additional time to setup these, i believe its still worth as long as it meets the business requirement

[@veerabhadra4708]

Hi Arvind, can you please post Fusion allocation process

[@OracleEbizandFusionVideos]

Sure... i will make a note of this in my long list of topics to be covered

[@HarishKumar-tj2sq]

Do we have to post stat journal every month?

[@OracleEbizandFusionVideos]

It depends upon the period type which you use in your mass allocation formula. If you use PTD, then yes STAT journals needs to be created every month and then posted. If you select QTD, then STAT jrnls needs to be created and posted every quarter and so on....

[@shehzaibtariq899]

I have tried to create an Allocation Journal following your exact method. However, I am getting D "No Journal Was Created Because Accounts For Allocation Basis Have Zero Or No Balances" error when creating the Journal. Can you please help?

[@OracleEbizandFusionVideos]

Did you ensure that you have created STAT journal and posted and also did you ensure that you that the source accounts from where you are transferring has some balance?

[@kirankumarkottakota3414]

Very good explanation...Please make video on fusion allocation

[@OracleEbizandFusionVideos]

Sure

[@Satjag]

If I want to calculate .05% how can we enter stat journal.. It accepts only 2 digits .50 not .0050

[@OracleEbizandFusionVideos]

Hi Satish, i tried and i was able to enter the value as "0.0050" while creating a STAT jrnl. Just ensure that the precision is set as "4" under currencies defintion screen for "STAT" currency and then try again

[@achafeez]

how to transfer all ar customer to ap supplier in oracle ebs r12 please guide me

[@OracleEbizandFusionVideos]

Can you rephrase your question... What do you mean by transferring AR Customers to AP Suppliers? Also, give me business reason for this

[@achafeez]

Our client required to transfer AR customer in supplier list also. because for customer deposit refund then want to create invoice. i know that in the receipt we can refund and it will be in the invoice. but client is not accepting this way.

[@OracleEbizandFusionVideos]

There is no standard feature for this... You need to manually create concerned customers as your suppliers

[@anelmah]

Can u pls post video on bank reconcilation

[@OracleEbizandFusionVideos]

Sure.. I will try to create a video on Cash Management Bank reconciliation and post... stay tuned...

[@OracleEbizandFusionVideos]

As requested, please see below video on Oracle Cash Management Reconciliation process:- kzbin.info/www/bejne/ooCWnWqQiayWrck

[@DanrKakStudio]

Dear Big Brother/ Anna, Thanks for this video. I have 10 segments: Company, Locations, Line of Business, Department, Account etc. I want to allocate all the expenses of different combinations of Non-cost enabled Departments to Cost-enabled Departments based on the Machine Hours of Cost-enabled Departments. How can I do that. Plz comment.

[@OracleEbizandFusionVideos]

Machine hours of cost enabled departments can be entered as STAT journals and as long as non Cost enabled departments are grouped as a parent, you should be able to allocate the expenses

[@DanrKakStudio]

@@OracleEbizandFusionVideos I have created a parent for Non- costed departments, a parent for Costed Departments, a parent for LOB, a parent for Employees and a parent for group accounts. In stat, I have set Machine hours from costed dept. I can send you the allocation formula which shown me Error while validation. Anna! can I talk to you by any means? Thanks

[@OracleEbizandFusionVideos]

@@DanrKakStudio What does error message say? You can ping me on my facebook page:- facebook.com/CAArvindVaraganti/