My Oracle Support Banner

Migrated Transaction Raise ORA-1403 When Clicking On Sales Credit Button (Doc ID 2136278.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Generic problem
============
For upgraded transactions, user receives “ORA-1403: no data found” error when attempting to click on the Sales Credits button in Transactions form.




SQL provided for transactions identification
=========================

select distinct ct.customer_trx_id, ct.trx_number, h.account_number
from ra_customer_trx_all ct
  ,xla.xla_transaction_entities xte
  ,ar_payment_schedules_all ps
  ,HZ_CUST_ACCOUNTS h
where ct.upgrade_method = 'R12_11ICASH'
and ct.customer_trx_id=ps.customer_trx_id
and ps.status = 'OP'
and ps.gl_date between to_date('&start_date','DD-MON-YYYY') and to_date('&end_date','DD-MON-YYYY')
and ct.customer_Trx_id = nvl(xte.source_id_int_1,-99)
and xte.upg_batch_id is not null
and xte.application_id = 222
and xte.entity_code = 'TRANSACTIONS'
and h.cust_account_id = ct.bill_to_customer_id
and
( exists
  ( select 'x' from ar_distributions_all ard,ar_Receivable_applications_all ra
  where ra.applied_customer_trx_id = ct.customer_trx_id
  and ra.application_type = 'CASH'
  and ard.source_id = ra.receivable_application_id
  and ard.source_Table = 'RA'
  and ard.source_type = 'REC'
  and ard.ref_customer_Trx_line_id is null
  and ard.ref_cust_trx_line_gl_dist_id is null)
  or
  exists
  (SELECT 'x'
  FROM ar_distributions_all ard,
  ar_adjustments_all ra
  WHERE ra.customer_trx_id = ct.customer_trx_id
  AND ard.source_id = ra.adjustment_id
  AND ard.source_Table = 'ADJ'
  AND ard.source_type = 'REC'
  AND ard.ref_customer_trx_line_id IS NULL
  AND ard.ref_cust_trx_line_gl_dist_id IS NULL
  AND ra.upgrade_method = '11I')
);

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.