Migrated Transaction Raise ORA-1403 When Clicking On Sales Credit Button
(Doc ID 2136278.1)
Last updated on FEBRUARY 03, 2019
Oracle Receivables - Version 12.1.3 and later Information in this document applies to any platform.
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') );
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!