Hi all,
what are the mandatory sql/plsql commands functional consultant need to know, let me know please.....
Answer Posted / newbie
I would say basic select statement to query some data from base table , knowledge of various types of Joints( Inner/Outer ) , ability to convert data into specific format Like ( YYYY/MM/DD HH:MM:SS ) , truncate , delete
I think if you know these command you should be fine . I think w3schools is a good place to learn it
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?
Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?
How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12
I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.
What is the Invoicing System in Oracle R12
how service tax work.
I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.
How will account an advance of Rs.10000/- which is a permanent prepayment, can I make payment for this?
What is automation of accounts payable activities (evaluated receipt settlement)?
What is the use of operating unit, while configure multiorg?
1.what is the name of program to create invoice automatic from po.? 2.How to auto upload the bank statement? 3.PO tax has not flown to invoice . why? Debit memo not generated for return of goods.??
What is the meaning holding tax?
How do you adjust receivables?
Can Adjustments be imported?
Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.