Meaning Accounting period that can start on any day of a calendar year but has twelve consecutive months (52 consecutive weeks) at t...
Oracle Applications : Generating Trace files
Generating the trace files The trace file helps us in finding the various queries executed while doing certain activities. The comp...
Oracle Applications : Tuning Techniques
Oracle Applications performance tuning issues take two forms: A) Simple issues that developers can fix themselves with an intermediate kn...
Oracle SQL : Simple Tuning Tips
Use aliases Whenever you issue a DML command, Oracle must match each column with its corresponding table. Aliases reduce that time. W...
Oracle Applications : Sending email from Procedure-Sample Code
CREATE OR REPLACE PROCEDURE SEND_MAIL_TCP (errbuf OUT VARCHAR2, retcode OUT VARCHAR2 ) IS ...
Oracle Applications Business Flows : Customer Return to Credit
Customer Return to Credit Enter customer returns by referencing Item, Sales Order Number, and Customer Purchase Order Number of Invo...
Oracle Applications: Receivables :Interview Questions
Oracle Receivables Interview Questions 1)Is it possible to apply a receipt from one customer to another customer’s transaction? If Yes...
Oracle Order management- : R12 Enhancements
Item Orderability Businesses need the ability to define which customers are allowed to order which products, and the ability to apply th...