Oracle Financials Interview Questions

If you're looking for Oracle Financials Interview Questions for Experienced or Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle Financials has a market share of about 2.6%. So, You still have the opportunity to move ahead in your career in Oracle Financials Development. Mindmajix offers Advanced Oracle Financials Interview Questions 2024 that helps you in cracking your interview & acquiring a dream career as Oracle Financials Developer.

We have categorized Oracle Financials Interview Questions - 2024 (Updated) into 2 levels they are

• Freshers
• Experienced

Top 10 Frequently Asked Oracle Financials Interview Questions

1. Oracle Audit Possibilities
2. Asset number generation
3. What is the difference between KFF and DFF
4. What is the structure of KFF in the Accounting Flexfields?
5. In which table flex values are stored?
6. How will you attach a set of Books to the Responsibility?
7. What are different Profiles Level available in oracle apps?
8. What is the cycle of GL?
9. What are the Important tables in GL?
10. What is the difference between org_id and Organization_id?

Want to become a certified Oracle Financials Professional? then Enrol here to get Oracle Financials Online Training & Certification Course from MindMajix.

Oracle Financials Interview Questions and Answers

1. Create a new GL module in the same machine

I need to create a new set of databases Oracle Finance and program in the same machine having the Sun Solaris system.

Can I just copy the volume of the program and data?

Or do I need to make a new installation?

If I need to make a copy of the GL module set database, is it possible if I only copy the data, and make a new pointing map from the program?

Ans: In order to create a new set of databases Oracle Finance and program in the same machine, you will need to create a new instance. You can create a new instance in the same machine.

2. Oracle Receivables – Interface

Can you tell me which tables get hit in the ‘Receivables’ module when the receivables interface is run from Order Entry?

Ans: We have the RA_INTERFACE_LINES_ALL table to be populated. From there, AR picks data for creating an invoice using “autoinvoice”.

While Autoinvoice gets data from ra_interface_lines_all, it also picks data from ra_interface_salescredits_all and ra_interface_distributions_all if it is present.

3. Oracle Financial problem

I have installed two instances (test, vision) of Oracle Financial 11i for vision instance and everything seems ok. But in testing an instance after logging using sysadmin/sysadmin ini IE5.0, an error comes after the applet has started.

I find this error:

“APP-FND-01516: invalid username or password or database

The tns80listnerAPP_TEST is not starting.”

How can I solve this?

Ans: You have just found out that the database would not start correctly in getting the error in identifying control file;

Go to the COMMON_TOP/admin/install directory

/u202/train/d01/oracle/prodcomn/admin/create

To solve this, run “adcrdb.sh”. This created the control file.

Restart the database, and then try connecting to applications that will complete the connection.

4. Customer vs. Journal Entries Balances

This is the scenario I have:

When an invoice is created in AR AND the user changes to the AR (1070), it debits to something other than 1070.

The customer balance is increased to reflect that he owes us money but the Journal entries for 1070 remain at 0.

I assume the Aged VS and the journal entries for a customer should be equal. I am aware the invoice should have used 1070 but it didn’t, which means a user error.

Do you know how to undo this type of error?

Please note that it is too late to cancel the invoice. There are other types of user mistakes that can throw out the JE VS AGED as well.

Ans: The situation you mentioned is the reason why you should not change invoices that are accounted for. This can also happen when the J/E is changed since the AR transfer to GL creates unnoted J/E. Changing the said invoices puts GLA and the sub-ledger out of sync.

You need to set the journal source for receivables so that the update flag is not enabled.

In AR, don’t change invoices that are there. Instead, use DM and CM functionality to adjust invoices or create new ones.

5. Oracle Audit Possibilities

I like to know if there are functionalities in Oracle Applications that will allow me to audit the access users to have certain forms.

Are there specific requests that will allow me to look up all the users that can define vendors, or do I have to define queries on the database tables?

Ans: You can select distinct user_id from fnd_user where user_id in (select created_by from po_vendor_sites_all).

Alternatively, you can play with the user and responsibility tables to see who has access to the responsibilities. You need to PO superuser and PO user, and other responsibilities that have access to the form to enter vendors. If a user does not have access to a ‘responsibility used’ to enter vendors, he cannot enter vendors using his login.

Note that po_vendors is at a generic level (no_org_id) while po_vendor_sites is at the org_id level.

created_by and Updated_by are columns that allow you to see who created or updated the data.

Oracle Financial Services Interview Questions For Freshers

6. Asset number generation

In our system, asset numbers are automatically generated one by one. But sometimes, it skips the sequence. For example, we have closed a period with a last asset number 326, and when we open the next period, it gives an asset number of 329. It means we missed asset numbers 327 & 328. Sometimes, it also happens even without closing the period.

How do I fix this?

Ans: You will need to check your Fa_distribution_history table to see if you are missing gaps there and then trace it to where assets where created, either in FA or in PA.

7. What is the Flex field? 

Ans: Flex field is used to capture information about your Organisations.

8. What is the difference between KFF and DFF?

Ans: 

KFF

• Unique identifier
• Stored in segment Column

DFF

• Is used to capture additional information
• Stored in attribute Column

9. How many KFF are in GL. AP, AR.

Ans: 

1. Module KFF
2. GL Accounting FF
3. AP No KFF
4. AR Sales tax Location FF
5. Territory Flexfield.

10. What is a symbol of DFF in the Forms?

Ans: Square Bracket [ ].

11. What is the structure of KFF in the Accounting Flexfields?

Ans: 

1. Company
2. Cost center
3. Account
4. Product
5. Future use.

12. How many segments are in AFF.

Ans:  Maximum 30 segments and minimum two segments.

13. What are Flexfield Qualifiers?

Ans: Flexfield Qualifiers is used to identify the segments. Various types of flexfield qualifiers are listed below:

• Balancing Segment Qualifier.
• Cost Center segment Qualifier.
• Natural Account Segment Qualifier.
• Intercompany Segment Qualifier.

14. What are Dynamic Insertions?

Ans: You can create Code Combinations at run time.

15. In which table Code Combinations id is stored?

Ans: GL_CODE_COMBINATIONS.

Oracle Financial Services Interview Questions For Experienced

16. In which table flex values are stored?

Ans: 

1. fnd_ flex_Values
2. fnd_ flex_Values_tl

17. What is a set of Books and in which table set of books is stored?

Ans: Set of Books is a Financial Reporting entity that Consists of three C.

• Chart Of Accounts
• Currency
• Calendar.

Set of Books is stored in GL_SETS_OF_BOOKS

18. In which table Currency and Period Type Name are stored?

Ans: 

Currency – FND_CURRENCIES

Period – GL_PERIOD_STATUSES

19. In which table Segment Values are stored and concatenated values are stored?

Ans: 

GL_CODE_COMBINATIONS

GL_CODE_COMBINATIONS_KFV.

20. What are the different types of Currency?

Ans: 

1. Functional Currency
2. Foreign currency.

21. What are the different types of Calendars?

Ans: Different types of Calendars are listed below

• Fiscal
• Accounting

22. How will you attach a set of Books to the Responsibility?

Ans: Through Profile. GL SETS OF Books Name.

23. What is Profile and what are the different types of Profiles.

Ans: Profile: Profile is the changeable option that affects the way your application runs. There are two types of profiles.

1. System defined
2. User-defined

24. What are different Profiles Level available in oracle apps?

Ans: Below are the Profiles Level available in oracle apps

1. Site(Lowest level)
2. Application
3. Responsibility
4. User.

25. Write the Name of some Profile options.

Ans: 

GL Sets of Books Name

GL sets of Books id

MO: Operating unit (multi org).

HR: User type.

26. What is the cycle of GL?

Ans: In simple and layman words-

1. Open the period
2. Create Journal Entries
3. Post the Journals.

27. In Which tables Journal entries created.

Ans: Important tables are-

Batch: GL_JE_BATCHES

Header: GL_JE_HEADERS

Lines: GL_JE_LINES

28Q. After Posting data goes in which tables?

Ans: GL_BALANCES.( Column Period_net_cr, period_net_dr).

29. What are the Important tables in GL?

Ans: 

1. GL_JE_BATCHES
2. GL_JE_HEADERS
3. GL_JE_LINES
4. GL_BALANCES
5. GL_SETS_OF_BOOKS
6. GL_CODE_COMBINATIONS
7. GL_PERIOD_STATUES
8. GL_INTERFACE

Explore Oracle Financials Sample Resumes! Download & Edit, Get Noticed by Top Employers!

30. In which table Supplier information is stored.

Ans: Supplier information can be found in the following tables

1. PO_VENDORS
2. PO_VENDOR_SITES_ALL
3. PO_VENDOR_CONTACTS

31. What is the difference between org_id and Organization_id?

Ans: Org_id is for operating units and organization_id is for inventory organization.