1. What responsibility should I use when doing the set up for General Ledger?
Use a seeded responsibility like 'Oracle General Ledger Super User'.
You may also need to use the System Administrator responsibility.
2. What are the pre-requisites required to define a new calendar?
According to your business needs you need to decide the calendar type required
i.e. monthly, weekly or biweekly, the number of periods, adjusting periods
and the maximum number of periods within a fiscal year.
3. What are the pre-requisites required to define a new set of books?
Define a Calendar, Chart of Accounts and enable the functional Currency
for the set of books.
4. Why must I check the calendar definition before assigning to a set of books?
The calendar definition cannot be changed once it is assigned to a set of books
so it is very important to check that the calendar definition is suitable
to the specific business needs, has been defined correctly without any gaps
and that the period type is in accordance with the business requirements.
5. What General Ledger profile options need to be set up for using a new
set of books with a responsibility.
The profile option GL Set of Books Name. Once this profile option is set,
the profile option GL Set of Books ID will be populated automatically
with the appropriate id. You may also need to set up other profile options as mentioned
in the Oracle General Ledger User's Guide.
6. Can I define more than one set of books?
Multiple sets of books may be defined within Oracle General Ledger,
however for a given installation of Oracle subledgers you can use only one set of books
(unless you are multi-org).
7. What type of set of books do I need: Primary, Reporting or None?
The Primary and Reporting options are used with the MRC feature of
Oracle Applications. If you are not using MRC then you may choose 'None'
8. Are there any mandatory accounts that are required for the
Set of books definition?
A valid Retained Earnings account needs to be assigned on the set of books form.
Depending on the other options you may choose, such as Translation,
Suspense Accounting, Encumbrance, etc. you need to enter valid accounts
for those as well.
9. What is Dynamic Insertion? Is it required during setup?
Dynamic insertion is an Accounting Flexfield feature whereby you can allow users
to create new combinations upon entering a flexfield combination.
For every new flexfield combination entered, a unique code combination id is also
created which is used to enter and retrieve data.
You may enable or disable this Accounting Flexfield feature at any time,
on the Key Segments form.
10. Do I need Cross Validation rules set up before entering journals in
General Ledger?
If you plan to restrict certain accounts to be used only with certain company
or cost centers then you have to plan on this and define cross validation rules before
the code combination id is created. Once the code combination id is created,
new cross validation rules will not restrict the account's usage.
11. Do I need to turn Suspense posting on?
It is not mandatory but if suspense posting is checked, a valid suspense account
must be entered in the set of books form. It is used to balance journal entries
for which the entered amounts are out of balance.
12.Is there an automated tool to load the account segment values in
Oracle General Ledger?
No, the values have to be entered using the Segment Values form in
Oracle General Ledger.
(N) Setup > Financials > Flexfields > Key > Values
ReferencesàOracle General Ledger User Guide
13. Do I need to set up Journal Approval?
It can be set up at any time and is not a mandatory step for completing the
General Ledger setup.
14. What does the check box Balance Intercompany mean on the
set of books form?
If journals are created for different balancing segment values, the journal must be
balanced by balancing segment value (debits must equal credits for a particular
balancing segment value). Checking this option on the set of books form will allow
GL to balance these journals by using the default intercompany accounts set up
in Oracle General Ledger. If it is not checked, the journal must be balanced
(by balancing segment value) before it is imported or posted.
15. Is there any setup at the journal source level to view subledger data in GL?
Check the option 'Import Journal Reference' for each journal source/category
combination for which you wish to transfer the subledger reference data from the
subledgers during the Journal Import process. Please note that the following may
also have to be verified to view subledger data in GL:
1. Subledger setup.
2. The parameters for the transfer process from the subledgers.
3. Journal import process parameters.
16. What is the option Rounding Differences Account in the Set of Books form?
When transactions are entered in foreign currencies the conversion to the functional
currency may cause rounding differences. The Rounding Differences account is
used to balance any journal entry for which the converted amounts are out of balance.
When this option is checked, a valid account combination must be defined to track
the rounding differences.
17. Is there any additional maintenance for Sources and Categories in
General Ledger after these items are initially setup?
Once General Ledger Sources and Categories are setup, there is no additional
maintenance.
18. Is there a script to check each ORG_ID and the associated setting?
The organization ids are stored in HR_ALL_ORGANIZATION_UNITS table.
SELECT distinct (organization_id), (name)
FROM hr_all_organization_units;
19. How to review GL: Set of Books rofile options at all levels ?
Responsibility = System Administrator
Navigation = Profile/System
1. Check the desired display boxes: Site, Application, Responsibility and User
2. In the Profile field, enter GL Set of Books% and click on the [Find] button.
20. Can I change the functional currency for an existing set of books?
It is neither recommended nor supported to change the currency of a Set of Books
that is currently in use.
Hello There,
ReplyDeleteGreat info! I recently came across your blog and have been reading along.
I thought I would leave my first comment. I don’t know what to say except that I have
I have a problem on selecting my Data , i have this query.
SELECT DISTINCT [Classification]
,[Index]
,[IndexID]
,[Schedule]
,[Year]
,[Month]
,[WWeek]
,[Day]
,[Plan] as Plan1
,[Result] as Result1
,[Ach] as Achvt1
FROM vw_MyView
WHERE [Schedule] = 'Monthly'
AND [Year] = 2018
AND [Month] = 1
the Plan1,Result1 and Achvt1 is the result for the month of january, i want to display all the result of the remaining month in one row,e.g. the result of Feb will be, Plan2,Result2,Achvt2 and aim to get this kind of result
Classification|Index|IndexID|Schedule|Year|Month|WWeek|Day|Plan1|Result1|Achvt1|Plan2|Result2|Achvt2
i have an existing query but it is very slow because i am using subqueries
Very useful post !everyone should learn and use it during their learning path.
Grazie,
Ajeeth Kapoor
Hello Dayakar,
ReplyDeleteGeneral Ledger Setup Questions and answers in oracle applications being contrived to exist for many projects simply so it can be run will be the first to hit the wall, but those projects where the functions to make existing transactions cheaper in real world applications will find the elusive real world demand.
I am trying to use this in a materialized view and got below error:
SQL Error: ORA-12015: cannot create a fast refresh materialized view from a complex query
12015. 00000 - "cannot create a fast refresh materialized view from a complex query"
*Cause: Neither ROWIDs and nor
primary key constraints are supported for
complex queries.
*Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE
option or create a simple materialized view.
select IR.rowid MV_INST_LOBR_ROWID, J.rowid Job_ROWID, J.* FROM JOB J
LEFT JOIN MV_INST_LOB_R IR ON
(IR.I1503_CUST_AC_NO_PT1 = J.I3200_CUST_AC_NO_PT1 AND IR.I1503_CUST_AC_NO_PT2 = J.I3200_CUST_AC_NO_PT2 AND IR.I1503_INST_SEQ_NO = J.I3200_INST_SEQ_NO)
WHERE IR.I1503_CUST_AC_NO_PT1 IS NOT NULL AND IR.I1503_CUST_AC_NO_PT2 IS NOT NULL
UNION SELECT null, J.rowid Job_ROWID, J.* FROM JOB J WHERE J.I3200_CUST_AC_NO_PT1 IS NULL AND J.I3200_CUST_AC_NO_PT1 IS NULL;
Basically, the intention is to get all the records joining MV_INST_LOB_R and JOB table
where MV_INST_LOB_R do not have record for the joining condition J.I3200_CUST_AC_NO_PT1 / J.I3200_CUST_AC_NO_PT2
Can you help me in converting to simple query, so that I can use simple materialized view.
Follow my new blog if you interested in just tag along me in any social media platforms!
Thanks & Regards,
Morgan
Merhaba,
ReplyDeleteGeneral Ledger Setup Questions and answers in oracle applications being contrived to exist for many projects simply so it can be run will be the first to hit the wall, but those projects where the functions to make existing transactions cheaper in real world applications will find the elusive real world demand.
This is my question that needs to be answered.
option or create a simple materialized view.
select IR.rowid MV_INST_LOBR_ROWID, J.rowid Job_ROWID, J.* FROM JOB J
LEFT JOIN MV_INST_LOB_R IR ON
(IR.I1503_CUST_AC_NO_PT1 = J.I3200_CUST_AC_NO_PT1 AND IR.I1503_CUST_AC_NO_PT2 = J.I3200_CUST_AC_NO_PT2 AND IR.I1503_INST_SEQ_NO = J.I3200_INST_SEQ_NO)
WHERE IR.I1503_CUST_AC_NO_PT1 IS NOT NULL AND IR.I1503_CUST_AC_NO_PT2 IS NOT NULL
UNION SELECT null, J.rowid Job_ROWID, J.* FROM JOB J WHERE J.I3200_CUST_AC_NO_PT1 IS NULL AND J.I3200_CUST_AC_NO_PT1 IS NULL;
Basically, the intention is to get all the records joining MV_INST_LOB_R and JOB table
where MV_INST_LOB_R do not have record for the joining condition J.I3200_CUST_AC_NO_PT1 / J.I3200_CUST_AC_NO_PT2
I am trying to use this in a materialized view and got below error:
SQL Error: ORA-12015: cannot create a fast refresh materialized view from a complex query. I have searched for help on the internet and still have not found a solution.
12015. 00000 - "cannot create a fast refresh materialized view from a complex query"
*Cause: Neither ROWIDs and nor primary key constraints are supported for
complex queries.
*Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE
Can you help me in converting to simple query, so that I can use simple materialized view.
It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
Keep up the good work!
Thank you,
Radhey
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDeleteOracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDeleteThanks for sharing this great information on Oracle Fusion. Actually I was looking for the same information on internet for Oracle Fusion HCM Interview Questions and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Fusion financial by attending Oracle Fusion Financials Training.
ReplyDeletebuy twitch followers Enjoy family night with these 10 Best Xbox 360 Family Games! These game picks are very enjoyable and you won't feel guilty for ignoring the kids! The majority of these great games can be purchased at budget prices,and each will provide hours of family fun. Just don't get mad when your ego is bruised because you got powned by your 6 year old in Sega Superstars Tennis or Viva Pinata...You have been warned!
ReplyDeletehttps://dynamichealthstaff.com/nursing-jobs-in-canada-for-indian-nurses Over time, video games have become a major source of entertainment for children and adults alike. Everybody loves to play video games, maybe because video games allow one to do the impossible, like driving a car at break neck speed, taking on the role of a superhero, do somersaults, fly and even take part in shoot-em-ups. The world of video games has changed and evolved into a new type of gaming that now allows for controller free gameplay.
ReplyDeletehttps://www.buyyoutubesubscribers.in/2021/11/30/how-to-increase-youtube-views-by-yourself/ In a world where Facebook, YouTube, and other social media become a common platform for people all over the world to communicate, comes a new breed of internet citizen which you yourself might have encountered in your sojourn within the world wide web. Ladies and gentlemen, introducing the YouTube desperado.
ReplyDeletehttps://www.visualaidscentre.com/lasik-eye-surgery-in-delhi/ The SEO consultant can help your business capitalize on the ever-growing shift toward online research and marketing. Recently, The National Association of Realtors (NAR), the country largest trade organization, released a report indicating that that more than 70% of homebuyers first became aware of the home they eventually purchased through online research.
ReplyDeletedofollow backlinks Are you sick and tired with endless days and weeks of boring SEO work? SEO is taking all the time, but gives almost no results? The solution for your problem is SEO software. Here are 10 reasons to set your choice on it to lead your website to the top of Google.
ReplyDeletehttps://hostinglelo.in Making money on YouTube is easier said than done, but it's possible! It isn't right for those who want get-rich-quick schemes because you have to spend time and money if you want to succeed in this moneymaking venture. You actually need to become a YouTube partner to be able to insert ads on your videos.
ReplyDelete