Top 100+ Oracle Financials Interview Questions And Answers
Question 1. 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 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?
Answer :
In order to create a brand new set of database Oracle Finance and software within the equal machine, you may want to create a brand new example. You can create the brand new instance inside the identical machine.
Question 2. Can You Tell Me Which Tables Get Hit In The ‘receivables’ Module When The Receivables Interface Is Run From Order Entry?
Answer :
We have the RA_INTERFACE_LINES_ALL table to be populated. From there, AR alternatives records for creating an bill the usage of “autoinvoice”.
While Autoinvoice receives statistics from ra_interface_lines_all, it additionally picks information from ra_interface_salescredits_all and ra_interface_distributions_all if it's far gift.
Question three. 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.Zero, 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?
Answer :
You have just observed out that database might no longer start successfully in getting the mistake in figuring out control report:
Go to the COMMON_TOP/admin/deploy directory/u202/teach/d01/oracle/prodcomn/admin/create.
To remedy this, run “adcrdb.Sh”. This created the control document.
Restart the database, after which strive connecting to programs with a view to complete the relationship.
Question 4. 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 Remains At zero. 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?
Answer :
The scenario you noted is the motives why you ought to now not change invoices that are accounted for. This also can take place when the J/E is changed since the AR switch to GL creates unnoted J/E. Changing the stated invoices puts GLA and the sub ledger out of sync.
You need to set the magazine source for receivables so that the update flag isn't always enabled.
In AR, don’t trade invoices which can be there. Instead use DM and CM functionality to regulate invoices or create new ones.
Question 5. 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 Period, It Is Gives An Asset Number Of 329. It Means We Missed Asset Number 327 & 328. Sometimes, It Also Happens Even Without Closing The Period. How Do I Fix This?
Answer :
You will need to test your Fa_distribution_history desk to peer in case you are missing gaps there after which hint it to wherein assets in which created, either in FA or in PA.
Question 6. What Is Flex Field?
Answer :
Flex discipline is used to capture records of your Organisations.
Question 7. Difference Between Kff And Dff?
Answer :
KFF:
Unique identifier
Stored in phase Column
DFF:
Is used to capture extra records
Stored in attribute Column
Question eight. How Many Kff Are In Gl. Ap , Ar?
Answer :
Module KFF
GL Accounting FF
AP No KFF
AR Sales tax Location FF
Territory Flexfield.
Question nine. What Is Symbol Of Dff In The Forms?
Answer :
Square Bracket [ ].
Question 10. What Is Structure Of Kff In The Accounting Flexfields?
Answer :
Company
Cost center
Account
Product
Future use.
Question 11. How Many Segments Are In Aff?
Answer :
max 30 segments and min .
Question 12. What Are Flexfield Qualifiers?
Answer :
Flexfield Qualifiers is used to identify the segments. Various kinds of flexfield qualifiers are listed beneath:
Balancing Segment Qualifier.
Cost Center section Qualifier.
Natural Account Segment Qualifier.
Intercompany Segment Qualifier.
Question 13. What Are Different Types Of Currency?
Answer :
Functional Currency
Foreign forex.
Question 14. What Are Different Types Of Calendars?
Answer :
Different kinds of Calendars are indexed beneath:
Fiscal
Accounting
Question 15. What Is Profile And What Are Different Types Of Profiles?
Answer :
Profile: Profile is the changeable choice that impacts the manner your software runs.
There are sorts of profile:
System described
User defined
Question sixteen. What Are Different Profiles Level Available In Oracle Apps?
Answer :
Below are the Profiles Level available in oracle apps:
Site(Lowest level)
Application
Responsibility
User.
Question 17. What Is Cycle Of Gl.?
Answer :
In simple and layman phrases:-
Open the length
Create Journal Enteries
Post the Journals.
