Oracle Application Blog

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 Resolve the Shipping Exception Issue – Schedule Date has been Postponed – Exception Name "WSH_CHANGE_SCHED_DATE"

Issue: Sometimes, we may change the Schedule Ship Dates in the Sales Orders. When we try to do the Ship Confirm for those changed orders, system will not allow us…

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

How to Process the Stuck Purchase Orders with an Pending "Respond to Changes" Action

Issue: Requisitions are created using either from the Core Purchasing or Internet Procurement responsibilities. Then the requisitions will be converted into Purchase Orders using either Buyers Work Centre form or…

Read More

Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120

RECEIVING TRANSACTION PROCESSOR ERROR ISSUE Title: Receiving Transaction Processor errors out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120 Issue Description: When attempting to take a receipts against the Purchase Orders,…

Read More

PO Workflow Error – Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX

Reset a Purchase Order Statuses From In Process or Pre-Approved To Incomplete/Requires Reapproval Title: Document Manager Failed with Error Number 3 while processing  Standard Purchase Order XXXXXX Issue Description: PO…

Read More