Ans: 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.
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.
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.”
Ans: 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.
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 remains 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 reasons 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.
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 super user 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 org_id level.
created_by and Updated_by are who columns that allow you to see who created or updated the data.
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?
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.
Ans: Flex field is used to capture information of your Organisations.
Q8. Difference between KFF and DFF.
Ans:
KFF
DFF
Ans:
Ans: Square Bracket [ ].
Ans:
Ans: max 30 segments and min two.
Ans: Flexfield Qualifiers is used to identify the segments. Various types of flexfield qualifiers are listed below:
Ans: You can create Code Combinations at run time.
Ans: GL_CODE_COMBINATIONS.
Ans: 1. fnd_ flex_Values
2. fnd_ flex_Values_tl
Ans: Set of Books is a Financial Reporting entity which Consist of three C.
Set of Books is stored in GL_SETS_OF_BOOKS
Ans: Currency – FND_CURRENCIES
Period – GL_PERIOD_STATUSES
Ans:
Ans:
Ans:
Different types of Calendars are listed below
Ans: through Profile. GL SETS OF Books Name.
Ans: Profile: Profile is the changeable option that affects the way your application runs. There are two types of profile.
Ans: Below are the Profiles Level available in oracle apps
Ans:
Ans: In simple and layman words-
Ans: Important tables are-
Ans: GL_BALANCES.( Column Period_net_cr, period_net_dr).
Ans:
Ans: Supplier information can be found in following tables
Related Interview Questions...