Oracle Order Management Setup Document in R12.2
Definition: Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system…
Read MoreMANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT ORACLE EBS R12.2
MANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT ORACLE EBS R12.2 Concept: Once the pick release and pick confirm process is over, the details will be assigned to deliveries. Deliveries will…
Read MoreOAF – Creating Dyanmic Table Region in ProcessFormRequest
Creating a Dynamic table region and attaching the VO to this dynamic Table region in ProcessFormRequest method of controller. Consider the requirement, If user selects “U” then it should create…
Read MoreUseful SQL Queries – Oracle EBS
Query to find Runtime, Status and Argument of a Concurrent Request SELECT fcp.user_concurrent_program_name, fcr.requested_by, fcr.request_id, fcr.request_date, fcr.phase_code, fcr.status_code,fcr.requested_start_date, fcr.actual_start_date,fcr.actual_completion_date, ROUND((nvl(fcr.actual_completion_date,sysdate) –fcr.actual_start_date) * 1440, 2) “Runtime (in…
Read MoreExcel Template for BI Publisher Report
This blog explains the process and steps to develop BI data templates with excel. Steps in Brief: Create xml data template. Create concurrent program with executable XDODTEXE. Create Data…
Read MoreAdding Condition While Calling the Bursting Program
In the Below Program we would be restricting the Mails for which the outstanding balance is Less that Zero. Statement Generation Program Bursting AR Statement Print report is used to send…
Read MoreSending E-mail with Excel Attachment Using UTL_SMTP
The utl_smtp package is used to send e-mails from any database to a valid recipient/receipents with or without attachements.The generic code is given to send e-mail with excel attachment ,…
Read MoreSetting VO query dynamically in OAF
Generally while creating the View Objects we define a query to it. While rendering the OAF page these view objects get executed (either by framework or by the java code). …
Read MoreWater Mark Text in XML Publisher report
This blog outlines the steps involved to include the Watermark Text to XML reports. Let’s assume a base template as below : Step 1: Create a xml tag for the…
Read MoreAP Invoice liability (Trial Balance) Query: R12 AP GL PO RCV XLA
SELECT NVL (f.currency_code, d.invoice_currency_code) currency_code, d.invoice_amount, d.wfapproval_status, d.invoice_num, d.invoice_id, i.segment1 v_code, i.vendor_name, NVL (d.invoice_amount, 0) – NVL (d.amount_paid, 0) amt, SUM (a.acctd_rounded_cr) – SUM (a.acctd_rounded_dr) amount, b.accounting_date, f.segment1 po_num, f.comments…
Read More