300+[LATEST] Oracle Financials Interview Questions and Answers

Q1. What Is Structure Of Kff In The Accounting Flexfields?

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

Q2. What Are Flexfield Qualifiers?

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.

Q3. When An Invoice Is Created In Ar And The User Changes To The Ar (1070), It Debits To Something Other Than 107

  • The situation you mentioned is the reasons why you should not change invoices that are accounted for. This can also happen when the J/E is changed since the AR trfer 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.

Q4. 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

You have just found out that 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 which will complete the connection.

Q5. What Are Different Profiles Level Available In Oracle Apps?

Below are the Profiles Level available in oracle apps:

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

Q6. What Is Symbol Of Dff In The Forms?

Square Bracket [ ].

Q7. Difference Between Kff And Dff?

KFF:

  • Unique identifier
  • Stored in segment Column

DFF:

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

Q8. In Our System, Asset Numbers Are Automatic 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 Peri

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.

Q9. How Many Segments Are In Aff?

max 30 segments and min two.

Q10. What Is Profile And What Are Different Types Of Profiles?

Profile: Profile is the changeable option that affects the way your application runs.

There are two types of profile:

  1. System defined
  2. User defined

Q11. I Need To Create A New Set Of Database Oracle Finance And Program In The Same Machine Having The Sun Solaris System. Can I Just Copy The Volume Of Program And Data? Or Do I Need To Make A New Install

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

Q12. What Is Flex Field?

Flex field is used to capture information of your Organisations.

Q13. What Are Different Types Of Currency?

  • Functional Currency
  • Foreign currency.

Q14. What Is Cycle Of Gl.?

In simple and layman words:-

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

Q15. How Many Kff Are In Gl. Ap , Ar?

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

Q16. What Are Different Types Of Calendars?

Different types of Calendars are listed below:

  • Fiscal
  • Accounting