Autoinvoice Ora-01427 When One Segment Of Line Transaction Flexfield Is Disable (Doc ID 2231753.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION
==================
On 11.1.11.1.0
Import Autoinvoice is ending with Error status. No Autoinvoice Execution report is being generated.

The log file of Autoinvoice Import shows the following:

raadri()+ UTIL-CURRENT TIME (DATE=18-JAN-2017) (TIME=14:37:54)
update ra_interface_lines_gt l
set reference_line_id =
(select cm.customer_trx_line_id
from ra_customer_trx_lines cm
where l.reference_line_context = 'BENDFF-L'
and l.reference_line_context = cm.interface_line_context
and l.reference_line_ATTRIBUTE2 = cm.interface_line_ATTRIBUTE2
and l.reference_line_ATTRIBUTE3 = cm.interface_line_ATTRIBUTE3
and l.reference_line_ATTRIBUTE4 = cm.interface_line_ATTRIBUTE4
and l.reference_line_ATTRIBUTE5 = cm.interface_line_ATTRIBUTE5
)
where request_id = :request_id
and nvl(interface_status, '~') != 'P'
and reference_line_id is null
and reference_line_attribute1
|| reference_line_attribute2
|| reference_line_attribute3
|| reference_line_attribute4
|| reference_line_attribute5
|| reference_line_attribute6
|| reference_line_attribute7
|| reference_line_attribute8
|| reference_line_attribute9
|| reference_line_attribute10
|| reference_line_attribute11
|| reference_line_attribute12
|| reference_line_attribute13
|| reference_line_attribute14
|| reference_line_attribute15 is not null
and exists
(select 'x'
from ra_cust_trx_types_all t
where t.cust_trx_type_seq_id = l.cust_trx_type_seq_id
and t.type = 'CM')

len = 1268

UTIL-CURRENT TIME (DATE=18-JAN-2017) (TIME=14:37:56)
AFDICT_APP_PREFIX-AR-855636: ORA-01427: single-row subquery returns more than
one row


EXPECTED BEHAVIOR
-----------------------
Autoinvoice should ends without error and should create an Autoivoice Execution report listing any error

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate records into interface tables
2. Run Import Autoinvoice


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