FUSION: SCM: RCV: Error in package name RCV_PROCESS_RCPT_CONF_PVT.insert_rti_for_confrec with error code -1422 and error text ORA-01422: exact fetch returns more than requested number of rows
(Doc ID 2784701.1)
Last updated on AUGUST 28, 2023
Applies to:
Oracle Fusion Purchasing Cloud Service - Version 11.13.21.01.0 and laterOracle Fusion Receiving - Version 11.13.21.10.0 and later
Information in this document applies to any platform.
Symptoms
Try to process a Receipt Confirmations via OIC using processReceiptConfirmations and receive the following error message Response:
<ns1:ReceiptConfirmationError>
<ns1:ErrorMessage>The receiving transaction cannot be processed because an error occurred in package name RCV_PROCESS_RCPT_CONF_PVT.insert_rti_for_confrec with error code -1422 and error text ORA-01422: exact fetch returns more than requested number of rows.</ns1:ErrorMessage>
<ns1:ErrorMessageName xsi:nil="true" />
</ns1:ReceiptConfirmationError>
STEPS
-----------------------
1. Try to process a Receipt Confirmations via SOAP UI:
<processReceiptConfirmations>
<nstrgmpr:ReceiptConfirmation>
<tns:OrganizationCode>ABC_DEFG</tns:OrganizationCode>
<tns:StagedReceiptConfirmationLine>
<tns:ItemNumber>ABC1012023</tns:ItemNumber>
<tns:SourceDocumentCode>PO</tns:SourceDocumentCode>
<tns:DocumentNumber>DC000012</tns:DocumentNumber>
<tns:DocumentLineNumber>7</tns:DocumentLineNumber>
<tns:DocumentScheduleNumber>1</tns:DocumentScheduleNumber>
<tns:SoldtoLegalEntity>ABBA</tns:SoldtoLegalEntity>
<tns:UnitOfMeasure>UNIT</tns:UnitOfMeasure>
<tns:QuantityReceived>100</tns:QuantityReceived>
<tns:Subinventory>CC01</tns:Subinventory>
<tns:RMALineId/>
</tns:StagedReceiptConfirmationLine>
</nstrgmpr:ReceiptConfirmation>
</processReceiptConfirmations>
2. Get error message
Changes
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 |
Changes |
Cause |
Solution |
References |