Oracle Financials Interview Questions
Q. Make another GL module in a similar machine
I have to make another arrangement of database Oracle Finance and program in a similar machine having the Sun Solaris framework.
Will I simply duplicate the volume of the program and information?
Or on the other hand, do I have to make another establishment?
On the off chance that I have to make a duplicate of the GL module set database, is it conceivable on the off chance that I just duplicate the information, and make another pointing map from the program?
An: In request to make another arrangement of database Oracle Finance and program in a similar machine, you should make another occasion. You can make a new example in a similar machine.
Q. Prophet Receivables – Interface
Would you be able to disclose to me which tables get hit in the 'Receivables' module when the receivables interface is run from Order Entry?
A: We have the RA_INTERFACE_LINES_ALL table to be populated. From that point, AR picks information for making a receipt utilizing "autoinvoice".
While Autoinvoice gets information from ra_interface_lines_all, it likewise picks information from ra_interface_salescredits_all and ra_interface_distributions_all on the off chance that it is available.
I have introduced two cases (test, vision) of Oracle Financial 11i for vision example and everything appears to be alright. In any case, in testing a case subsequent to logging utilizing sysadmin/sysadmin ini IE5.0, a blunder comes after the applet has begun.
I discover this mistake:
"Application FND-01516: invalid username or secret key or database
The tns80listnerAPP_TEST isn't beginning."
How might I understand this?
A: You have quite recently discovered that the database would not begin accurately in getting the mistake in distinguishing control document;
Go to the COMMON_TOP/administrator/introduce catalog
/u202/train/d01/prophet/prodcomn/administrator/make
To understand this, run "adcrdb.sh". This made the control document.
Restart the database, and afterward, take a stab at interfacing with applications that will finish the association.
Q. Client versus Diary Entries Balances
This is the situation I have:
At the point when a receipt is made in AR AND the client changes to the AR (1070), it charges to an option that is other than 1070.
The client balance is expanded to mirror that he owes us cash however the Journal sections for 1070 stays at 0.
I accept the Aged VS and the diary passages for a client ought to be equivalent. I am mindful the receipt ought to have utilized 1070 yet it didn't, which implies a client blunder.
Do you realize how to fix this sort of mistake?
If it's not too much trouble note that it is past the point where it is possible to drop the receipt. There are different kinds of client botches that can toss out the JE VS AGED too.
A: The circumstance you referenced is the reasons why you ought not to change solicitations that are represented. This can likewise happen when the J/E is changed since the AR move to GL makes unnoted J/E. Changing the said solicitations puts GLA and the sub-record out of synchronizing.
You have to set the diary hotspot for receivables with the goal that the update banner isn't empowered.
In AR, don't change solicitations that are there. Rather use DM and CM usefulness to alter solicitations or make new ones.
Q. Prophet review potential outcomes
I like to know whether there are functionalities in Oracle Applications that will permit me to review the entrance clients to have certain structures.
Are there explicit solicitations that will permit me to look into all the clients that can characterize sellers, or do I need to characterize questions on the database tables?
A: You can choose unmistakable user_id from fnd_user where user_id in (select created_by from po_vendor_sites_all).
On the other hand, you can play with the client and obligation tables to see who approaches the duties. You have to PO super client and PO client, and different obligations that approach the structure to enter sellers. On the off chance that a client doesn't approach a 'duty used' to enter sellers, he can't enter merchants utilizing his login.
Note that po_vendors are at a nonexclusive level (no_org_id) while po_vendor_sites is at org_id level.
created_by and Updated_by are who segments that permit you to see who made or refreshed the information.
Q. Resource number age
In our framework, resource numbers are programmed created individually. Be that as it may, now and then, it skirts the grouping. For instance, we have shut a period with a last resource number 326, and when we open the following time frame, it gives an advantage number of 329. It implies we missed resource numbers 327 and 328. Some of the time, it additionally happens even without shutting the period.
How would I fix this?
A: You should check your Fa_distribution_history table to check whether you are missing holes there and afterward follow it to where resources where made, either in FA or in PA.
Q. What is the Flex field? What are the various kinds of Flex fields?
Flex field is utilized to catch data of your Organizations.
Q. Distinction between KFF and DFF.
KFF
Extraordinary identifier
Put away in fragment Column
DFF
Is utilized to catch extra data
Put away in quality Column
Q. What number of KFF are in GL. AP , AR.
1. Module KFF
2. GL Accounting FF
3. AP No KFF
4. AR Sales charge Location FF
5. Region Flexfield.
Q. What is the image of DFF in the Forms?
Square Bracket [ ].
Q. What is the structure of KFF in the Accounting Flexfields.
1. Organization
2. Cost focus
3. Record
4. Item
5. Future use.
Q. What the number of fragments are in AFF.
max 30 portions and min two.
Comments
Post a Comment