EBS Technical

Adding 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 More

Sending 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 More

Setting 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 More

Water 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 More

AP 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

Query to Link Shipments, AP Invoice, GL and SLA Tables: R12 AP GL RCV XLA

SELECT gjh.doc_sequence_value vch_num, gjl.effective_date, xal.currency_code,       xal.currency_conversion_rate con_rate, xal.entered_dr entered_dr,       xal.entered_cr entered_cr, xal.accounted_dr amount_dr,       xal.accounted_cr amount_cr, xal.description, aia.invoice_num,       aia.SOURCE, rsh.receipt_num  FROM ap_invoices_all aia,       ap_invoice_lines_all aila,       ap_invoice_distributions_all aida,       xla.xla_transaction_entities xte,       xla_ae_headers xah,      …

Read More

Query to Link AP Invoices, Payments, GL and SLA Tables: R12 AP GL XLA

SELECT          /*+ Index(xdl XLA_DISTRIBUTION_LINKS_N3) */       DISTINCT gjh.doc_sequence_value gl_vou_num, ac.check_id, xal.source_id,                aipa.invoice_payment_id, gjl.effective_date accounting_date,                xal.accounted_dr, xal.accounted_cr, aps.segment1 vendor_code,                aps.vendor_name vendor_name, aipa.invoice_id, aia.invoice_num,                aia.invoice_date, aia.invoice_currency_code cur,                aia.invoice_amount inv_amt_frc,                aia.exchange_rate inv_exc_rate,                aia.exchange_date inv_exc_date,               …

Read More

Query to Link AP Payments, GL and SLA Tables: R12 AP GL XLA

SELECT   SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount,         invoice_num    FROM ap_invoices_all aia,         ap_invoice_payments_all aipa,         ap_checks_all aca,         xla.xla_transaction_entities xte,         xla_ae_headers xah,         xla_ae_lines xal,         gl.gl_import_references gir,         gl_je_lines gjl,         gl_je_headers gjh   WHERE 1 = 1    …

Read More

Query to Link AP Invoices, GL and SLA Tables: R12 AP GL XLA

SELECT   SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount,         invoice_num    FROM ap_invoices_all aia,         xla.xla_transaction_entities xte,         xla_ae_headers xah,         xla_ae_lines xal,         gl.gl_import_references gir,         gl_je_lines gjl,         gl_je_headers gjh   WHERE 1 = 1     AND aia.invoice_id = NVL…

Read More

JBO-25006: Invalid parameter value – Resolution

Error: JBO-25006: Invalid parameter value PosViewShipmentsVO for destination passed to method ViewLinkImpl.setDestination.  Explanation: view def mismatch. Root Cause for the Error : While extending  a Seeded VO ( that has a Seeded…

Read More