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…

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 ,…

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). …

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…

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…

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, …

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, …

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 …

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…

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…

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey