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

Last updated on JUNE 07, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms