EBS Technical

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

How to Add or Assign the Printer to a desired Reports

How to Add/Assign the Printer to a desired Report Responsibility: Order Management Super User Navigation: Setup > Shipping > Documents > Choose Printers “Choose Document and Label Printers” Page will…

Read More

Setups for Discoverer Desktop

Setups for Discoverer Desktop The following steps have to be implemented after installation of Discoverer Administrator and Discoverer Desktop: 1. In Discoverer Desktop, go to tools –> options –> Connections…

Read More

Eliminating block.field issue while upgrading from EBS R11i to R12 versions

Eliminating block.field issue while upgrading from EBS R11i to R12 versions Problem In 11i, Customers are accessed through Oracle forms where :block.field reference is allowed to dynamically bring values in value…

Read More