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:

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

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