My Oracle Support Banner

Fusion FDC: ESS Import Electronic Fiscal Documents Error: Exception on PreprocessingValidations/VALIDATE: ORA-01427 (Doc ID 2820891.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.21.07.0 and later
Oracle Fusion Purchasing Cloud Service - Version 11.13.21.07.0 and later
Oracle Fusion Cost Management Cloud Service - Version 11.13.21.07.0 and later
Information in this document applies to any platform.

Symptoms

ESS Import Electronic Fiscal Documents - ERROR for Fiscal Document Capture (FDC)

When trying to run FDC processors to import and XML, process stuck in status
"Retry" and all transactions are not processed.

This error occurs because in product HUB there are associated items cross referenced
using one XML item(supplier) associated with more than one item Oracle.

When this association is made and we receive an invoice system do not decide
which item they need to use to convert and stuck transactions.

On checking Manage Interface Exception UI, there is no data for affected Fiscal Document (FD)
and hence no way to correct.

Users looking for help in order to process invoices in sequence that do not have
association with this transaction or an easy way to check this error because actually they
do not know what happens.  Due to this issue, users cannot import FD


Error

ESS Job Result: BP:ERROR: Process rolled back and aborted due to SQL Exception on PreprocessingValidations/VALIDATE: ORA-01427: single-row subquery returns more than one row




Steps To Reproduce

1. Import the FD using Import Electronic Fiscal Documents
2. Job goes to Retrying


 

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
References


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