How to report output like below
supplier name date amount
abc software jan/11 10000 /* jan month total transactions*/
abc software feb/12 30000 /* feb month total transactions*/
dell computers jan/13 45000 /* jan month total transactions*/
1. when we r doing interface/conversion which things u will
take care to improve the perfrmonce?(except bulk collect)
2. In conversion,u r loading the data using sql*loader,I dnt
want to use sql*loader,& i have millions of records,Id der
any way to load the data withing fraction of time
considering best performance.
3. When u r doing conversion,taht using sql*loader u r
loading data into staging table,u r writing control file bt
I dnt want to use sql*loader,when u r creating con prog that
time can we pass all values from flat file using
4. In flat file u got 50 records,out of 50 ,30 records are
proceesed & inserted into base table,after taht clien
understood that 1 item having wrong name e.g insted of ABC
he given DCE, so can we delete?hw?(client permission is der)
i have lot of wrong item name randomly spreaded,can we
5.after doing validation hw u will follow approach to error
out records?if i want to send all the error out records to
client daily,whats ur approach?
6. In outbound interface is der any way to load the
data(large data-millions of records) except UTL_FILE package?
7. what is parsing?
8. In technical doc.s which section will mention?except code?
9. Do u have any idea about code depository tool?
10.whats is performance tunning,DB link?
11, How u will do RMA?
What are the FAQ's asked Functional consultants in SCM ?
If any one knows please send.
we track suppliers information from legacy to oracle apps
what is the programe?in technical scenario we use sql
loader or adi but in functional what is the program ?
In support project one ticket alloted which steps follows
manualy tell me ?
What is difference between Pricing and Repricing?
how can we put sales order is on hold whenever we open the sales order form i want it will automatically go to hold without using credit check.How?
Please post the setups required to approve the payable
invoice in AP.
how install base integrate with asset-management?
Explain Customization process?
what is VAT claim process?
Difference between header level tax calculation and line level
how do you describe O2C along with tables
How many schemas we have? how many you have used?
2. what is receipt method.
Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
how do u explain what are revaluation reserve, revaluation
reserve retired, and revaluation amortization accounts