My Oracle Support Banner

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

Last updated on APRIL 05, 2019

Applies to:

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


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 = '<context_name>'
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

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

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


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

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