Oracle GL Secondary Ledger Data Conversion Options

[@ayatelnabawy6696]

You are an Exemplar, Arvind!! Thanks a lot dear.

[@OracleEbizandFusionVideos]

My pleasure

[@yashmittal9972]

Really nice video. Provided a lot of information in a small session.

[@OracleEbizandFusionVideos]

Thanks

[@TheSachinmrig]

I really liked the video you explained the concepts of primary and secondary ledger and data movement between them.

[@OracleEbizandFusionVideos]

Thanks for your feedback

[@muralikrishnabalu5366]

Hi Bro, really i like your videos very much which is having lot data

[@OracleEbizandFusionVideos]

Glad to hear that

[@veerabhadra4708]

Thank you Arvind, easy to understand way 👍👍

[@OracleEbizandFusionVideos]

Glad to hear that

[@mohithearthaker]

Neatly explained... Kudos... 👌

[@OracleEbizandFusionVideos]

Thanks for the feedback

[@shaileshverma4354]

Very informative...well explained. Thanks Sir

[@OracleEbizandFusionVideos]

Thanks

[@danishjamali5998]

Thanks Aravind , Again for a very informative video. I have a query if COA structure is different in Secondary ledger , then do we need to do some additional work or it automatically converts the entry as per the COA Structure. and what if we reverse the journal, can we reverse or post the journal directly in secondary ledger and how can we make adjustments in secondary ledger.

[@OracleEbizandFusionVideos]

Question 1:- If COA Structure of Secondary ledger is different:- Let us assume that in your Primary ledger you have 8 segments and in your secondary ledger, there are 4 segments, then you need to define Primary to Secondary ledger mapping and assign the same while creating Secondary ledger. In this example you do mapping of 4 segments of Secondary ledger to corresponding 4 segments of Primary ledger. So, when you look at the data, there are journal lines with 8 segments in Primary ledger, whereas in secondary ledger, you will have journal lines with 4 segments Question 2:- Impact of Reversals in Secondary ledger:- If you reverse the journal in Primary ledger, reversal journal is also pushed to secondary ledger and hence no need to manually reverse the corresponding reversal journal in Secondary ledger Question 3:- Can we make adjustments in Secondary ledger:- Yes, you can manual adjustment entries directly in Secondary ledger (if you go for Subledger level or Journal level data conversion).. These journals exists only in Secondary but not in Primary ledger

[@sanjaypriyadarshi]

@@OracleEbizandFusionVideos lovely explanation..

[@angrydebater6043]

Thank you for sharing informative videos. It would be great if you can share EBTAX videos for US and Canada.

[@OracleEbizandFusionVideos]

Sure. Please stay tuned to my channel

[@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

[@yashmittal9972]

Waiting for more interesting videos. Looking for a video on inter-company setups and scenarios

[@OracleEbizandFusionVideos]

There are already some videos on AGIS intercompany transactions. Let me know if you are looking for any other intercompany scenarios

[@yashmittal9972]

I am looking for Intercompany balancing concept and setup between 2 legal entities and also the use of Intercompany Flexfield qualifier in same

[@OracleEbizandFusionVideos]

Sure. I will create a video and let you know

[@km0p]

Dear Arvind, COA same. Calendars are different. Julian and 4-4-5. Some journals are not being posted in secondary. I belive those are credit memos of AR invoices which were created before secondary ledger got created. How can we find out which ones are not created? Can we pass manual adjustments in secondary? I belive so. If business wants to balance primary and secondary, since calendars are different, how can they tally PTD balances? What is the significance of allow posting and auto for each module in secondary led setup . If I set up as No ,except for others , would it makr different? Thanks for your help.

[@OracleEbizandFusionVideos]

1. Regarding your question on passing of Manual adjustments in Secondary ledgers... Its absolutely possible to pass direct manual journal entries in Secondary ledger 2. Ideally as the Calendars of Primary and Secondary ledgers are different, they will never match.... For one of our client, we had the same requirement and we developed a custom report in our BI reporting and this report runs based on GL date as the parameter and not the GL Period... So, for those GL Dates which overlap in both primary and secondary ledgers, journal balances should match 3. Can you provide more details on where exactly are you referring to Allow Posting and Auto for each module in Secondary ledger setup?

[@km0p]

@@OracleEbizandFusionVideos Thanks Arvind. At Sub Ledger level, while configuring Secondary ledger , there are options to enable the flag to let autoposting. I was referring to that . For revaluation, you want that flag to be enabled. likewise other subledger sources.

[@OracleEbizandFusionVideos]

Ideally for all subledgers, Transfer to Secondary Ledger should be set to "No" and for Others, it should be set to "Yes"

[@anurag982]

Hi Arvind sir Please confirm.SLA enable data access set profile option required to be set for primary ledger and secondary ledger responsibility or not required?

[@OracleEbizandFusionVideos]

If you set the value for profile option "SLA: Enable Data Access Set Security in Subledger" as "Yes" for say AP Super user responsibility, then for the same responsibility, you need to assign the value as below:- GL: Data Access Set :- SLA: Additional Data Access Set:-

[@anurag982]

@@OracleEbizandFusionVideos - SLA additional data access set not required to set for General ledgers responsibilities we need to leave this option as null..for example- We have primary ledger and secondary ledger Then SLA additional data access set for both ledger should be null

[@OracleEbizandFusionVideos]

Yes, SLA: Additional Data Access Set is not required for GL responsibilities

[@anurag982]

@@OracleEbizandFusionVideos thanks Arvind sir

[@OracleEbizandFusionVideos]

You are welcome

[@NeerajPalDiaries]

Thank you sir , could you please make a video on cross validation, security rules and dynamic inserts and their impact on project.

[@OracleEbizandFusionVideos]

Sure. Please stay tuned to my channel

[@OracleEbizandFusionVideos]

Hi Neeraj, based on your request, i created a video on Cross Validation and security rules. Please check my recent video

[@ShahRedmi-r9d]

I have created a Journal level Reporting ledger. I want to restrict only specific balancing segment to get converted to reporting ledger. It may transact in sources common to all. How can we achieve this?

[@OracleEbizandFusionVideos]

I think this is possible in Fusion Journal level Secondary ledger. Refer the White Paper in Oracle Support Doc id:- 2415848.1. In this document, there is a section titled - "Legal Entity Specific Secondary Ledgers". Refer that. Understand this and check if you can try to replicate the same for Reporting Ledger..

[@melvinp8875]

Thx Arvind..in R12 how can I have the adjustment secondary ledger be setup to use a new company segment (different from the PL). This new segment should not be considered in the statutory reporting of the PL. Thx for your help.

[@OracleEbizandFusionVideos]

Hi Melvin, lets say your company code of "01" used in Primary ledger and you want that to be pushed under "02" under Secondary ledger... If this is your requirement, you can do so in Primary and Secondary ledger mapping and also do not assign the company code of "02" under Primary Ledger either at Ledger level or Legal entity level so that this company code of "02" cannot be used in Primary Ledger

[@melvinp8875]

@@OracleEbizandFusionVideos Thx Arvind. Appreciate your help.

[@ankitaagarwal2685]

Hi Arvind, Nice video you have shared.I am having a question that can we use a single gl resp for primary and secondary ledger as well.As in gl we can change the ledger. So please guide it. Thanks, Ankita

[@OracleEbizandFusionVideos]

Yes, if Primary Ledger and Secondary ledger has same COA and Same Period type (used in GL calendar), then you can create a Ledger set to include these two ledgers and then assign the ledger set to a responsibility and then you can access both Primary and Secondary ledger using this responsibility

[@ankitaagarwal2685]

Oracle E-Business Suite Functional R12 Thanks

[@missfina18]

Hi Sir thank you very much for all your informative videos on oracle. Really learned a lot. I would just like to clarify the decision point in creating a secondary ledger. You mentioned that if the "subledger accounting method" is different, then we go for creating a secondary ledger. I'm also checking oracle user guide and it suggests secondary ledger for different "accounting method". May i ask if "subledger accounting method" and "accounting method" are the same or different? I'm trying to assess if we need to create a secondary ledger. Our currrent primary ledger is using IFRS 4. We need a new ledger that will adjust the balances of our primary ledger for IFRS 17 reporting. Which is more appropriate to do? Create a secondary ledger or create a new primary ledger? Thanks!

[@OracleEbizandFusionVideos]

Hi, Subledger Accounting method and Accounting Method are same. In your case you need to go for new secondary ledger. Your primary ledger should be aligned to IFRS4 and your secondary ledger should be aligned to IFRS17

[@missfina18]

@@OracleEbizandFusionVideos Thank you so much Sir. May i ask for your advice on how to address below feedback to us opposing the use of secondary ledger because they believe the best solution is to create a new primary ledger. Feedback to us >> "Secondary ledgers, as stated in the Oracle Financials Implementation Guide, “represents the primary ledger's accounting data in another accounting representation.” In other words, the secondary ledger is an optional, additional ledger that is associated with the primary ledger for an accounting setup. We don’t see the need to use a secondary ledger since it will use the same COA, calendar, currency, and accounting method of the Primary Ledger. The accounting representation requirement for IFRS 17 is being ‘accounted or accounting entries are created’ outside of Oracle EBS. You only need to interface these entries from 3rd party software to the target Oracle EBS Ledger (our recommendation is Book 2 which is a new 'primary ledger’). Thank you for all the help.

[@OracleEbizandFusionVideos]

If you do not want the entries in Primary ledger to be pushed to Secondary ledger and if you are bringing in the data from Third party system,then yes you can go for separate Primary ledger

[@missfina18]

@@OracleEbizandFusionVideos we're actually ok with pushing entries from primary ledger to secondary ledger. We're also ok with pushing the data from 3rd party system directly to the secondary ledger. We're looking for automated transfer of balances/journals from primary ledger to the new ledger.

[@OracleEbizandFusionVideos]

You can use consolidation process to transfer balances from one ledger to another ledger.... If the functional currency of both the ledgers are same, then you can use consolidation process to transfer journals as well... Look for videos on Consolidation process in my channel

[@ghodighosh9050]

nice video, Arvind. One question, if in subledger transaction we do a Create Accounting with both Transfer to GL and Posting as yes, will it move to both Subledger Lvl secondary ledger and Journal level secondary ledger directly ?

[@ankitaagarwal2685]

Ghodi Ghosh Yes.As posting is Yes .Primary ledger data move to secondary leger.

[@OracleEbizandFusionVideos]

When you run your Create Accounting, the data is transferred to Primary ledger and Subledger level secondary ledger and as you are entering parameter of Posting as Yes, the journal will be posted in Primary ledger and then immediately sent to Journal level secondary ledger

[@ShahRedmi-r9d]

Can you create a video for Reporting currency ledger types

[@abiihkam6854]

Sir, please tell How to Transfer Historical Balances to a New Journal Level Secondary Ledger ? Like I have posted a journal in primary but not yet create the secondary ledger. can we transfer the journal after i create the secondary ledger?

[@OracleEbizandFusionVideos]

If the Primary ledger was in use for a while and after that Secondary ledger is created, then on the date of Go live, you need to upload Opening Trial Balance which will initiliaze balances under Secondary ledger

[@pradnyabhosale5581]

Hi Aravind, how can we restrict some entry at primary ledger only and this entry not come in secondary ledger?

[@OracleEbizandFusionVideos]

I am assuming you want certain manual GL Journals entered in Primary Ledger should not be pushed to Secondary ledger... If this is the requirement, then follow the below steps:- Step 1:- Create a new Journal Category say "XXXXX" Step 2:- Under Primary to Secondary Ledger Mapping (part of GL Secondary Ledger setup), ensure that with Journal source "Manual" and Category "XXXXX", Transfer Journals to this Secondary Ledger should be set to "No". Step 3:- Perform the above Step 2 for Journal Source "Spreadsheet" and Category "XXXXX" as well Step 4:- Now try to enter a Manual journal in GL Primary ledger/Spreadsheet (Web ADI) Journal in GL Primary Ledger with Journal category "XXXXX" and post this journal... This journal will not be pushed to GL Secondary ledger.

[@pradnyabhosale5581]

@@OracleEbizandFusionVideos thank you

[@raghuraghu-hi7qm]

super

[@OracleEbizandFusionVideos]

Thanks

[@dippratimdan9965]

Once I run the Create Accounting Program with Posting Ability No in AP then it will only create the Journal in P/L and S/L . The Journal Status will be unposted . Now if you run the Posting Program in P/L will it automatically trigger the Posting program in S/L also .

[@OracleEbizandFusionVideos]

There is a Option in Secondary ledger setup, if you enable that then yes, if you post the journal in Primary ledger, journal in secondary ledger will also get posted

[@onlinealways9853]

Q:2 We have to again assign the Profile option for the Secondary ledger responsibility of GL to access the data converted , Right? GL:% (Thank u Sir)

[@OracleEbizandFusionVideos]

Yes, you need to assign GL: Data Access set profile option for GL Secondary ledger responsibility

[@sanjaypriyadarshi]

@@OracleEbizandFusionVideos hi sir is this mandatory>GL: Data Access set profile option for GL Secondary ledger responsibility?

[@OracleEbizandFusionVideos]

@@sanjaypriyadarshi Yes... You need to assign this profile option to GL resp so that you can access concerned Secondary Ledger... With out this profile option being assigned, you cannot access this ledger

[@sanjaypriyadarshi]

@@OracleEbizandFusionVideos thanks sir

[@OracleEbizandFusionVideos]

@@sanjaypriyadarshi You are welcome

[@lorenaqua9441]

Hello Guro - can we create secondary ledger from consolidated primary ledgers?

[@OracleEbizandFusionVideos]

Consolidated Primary ledger is like any other primary ledger and hence its absolutely possible to create secondary ledger under Consolidated primary ledger

[@lorenaqua9441]

@@OracleEbizandFusionVideos Thanks a lot!

[@shamikaranasinghe471]

How to do the SLA transfer historic balances in to secondary ledger ?

[@OracleEbizandFusionVideos]

In GL Secondary ledger, you need to upload opening trial balance... For subledgers, you need to run "SLA Secondary/ALC Historic upgrade program" which will update SLA tables in Subledger related to Secondary ledger

[@shamikaranasinghe471]

@@OracleEbizandFusionVideos in that case can’t we see the transferred past journal entries from Journal workbench ?

[@OracleEbizandFusionVideos]

I am assuming the scenario which you are referring is below:- 1. Primary ledger was created couple of months back... There are Subledger entries created under this Ledger 2. Secondary ledger is created now against this primary ledger.. In this business scenario, we run "SLA Secondary/ALC Historic Upgrade program".. this program updates SLA tables and do not transfer any entries to GL Secondary ledger

[@3170ccp]

can you share Oracle concepts this documents? thanks

[@OracleEbizandFusionVideos]

There are may worksheets within in excel spreadsheet and those are for my reference. Are you specifically looking for the worksheet which is discussed in this video?

[@NitishKumar-ly5ke]

Can you please share video how to create mapping set for difference COA for secondary ledger.

[@OracleEbizandFusionVideos]

In the below video, i covered the mapping process from consolidated ledger and subsidiary ledgefr perspective. More or less same applies for Primary and Secondary ledger as well:- kzbin.info/www/bejne/e3u3dKWBmtx9mqs

[@onlinealways9853]

Please tell Q1: The mapping of Primary to the secondary ledger, While making Sec.Ledger.(Thank You Sir)

[@OracleEbizandFusionVideos]

Sorry, i did not get your question. Can you elaborate your question?

[@onlinealways9853]

Oracle E-Business Suite Functional R12 Sir, while making the secondary ledger,do We have to define the mappings in the system, just like for consolidation process, conversion level= Subledger? -thank you sir.

[@OracleEbizandFusionVideos]

@@onlinealways9853 , yes you need to define the mapping between Primary and Secondary ledger in Chart of Accounts Mapping screen

[@vishnummenon5925]

@@OracleEbizandFusionVideos Hi Arvind- can you please do a video on the COA mapping in such cases

[@chackojoseph4877]

@@OracleEbizandFusionVideos I was checking the setup screen of secondary ledger, where do we specify the COA mapping between PL and SL? I meant in case where PL COA and SL COA are different.