My Oracle Support Banner

Receipt Application Using Webservice Gives Error: In package AR_RECEIPT_API_PUB and procedure Apply the following error occurred: ORA-01403: no data found. (Doc ID 2737816.1)

Last updated on MAY 21, 2021

Applies to:

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

Symptoms

Unable to apply receipt using webservice


Soap Webservice:
---------
https://<Server URL>/fscmService/StandardReceiptService


Request Payload:
-------------------------
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/receivables/receipts/shared/standardReceiptService/commonService/types/" xmlns:com="http://xmlns.oracle.com/apps/financials/receivables/receipts/shared/standardReceiptService/commonService/" xmlns:app="http://xmlns.oracle.com/apps/flex/financials/receivables/receipts/shared/standardReceiptService/commonService/ApplyReceiptDff/">
<soapenv:Header/>
<soapenv:Body>
<typ:createApplyReceipt>
<typ:applyReceipt>
<!--Optional:-->
<com:AmountApplied>100</com:AmountApplied>
<com:ReceiptNumber>REC_01</com:ReceiptNumber>
<com:TransactionNumber>TRX_01</com:TransactionNumber>
<com:ApplicationDate>2020-12-14</com:ApplicationDate>
<com:AccountingDate>2020-12-14</com:AccountingDate>
</typ:applyReceipt>
</typ:createApplyReceipt>
</soapenv:Body>
</soapenv:Envelope>
  

ERROR
-----------------------
<faultstring>
<![CDATA[JBO-FND:::FND_GENERIC_MULTI_MESSAGE: <MESSAGE>
<NUMBER></NUMBER>
<TEXT>Multiple errors occurred while processing this request. See Details. </TEXT>
<CAUSE> </CAUSE>
<ACTION> </ACTION>
<DETAILS> </DETAILS>
<INCIDENT> </INCIDENT>
</MESSAGE>
JBO-AR:::AR_RAPI_RCPT_NUM_IGN:
<MESSAGE>
<NUMBER>AR-855741</NUMBER>
<TEXT>The cash receipt ID takes precedence over the receipt number. </TEXT>
<CAUSE> </CAUSE>
<ACTION></ACTION>
<DETAILS></DETAILS>
<INCIDENT></INCIDENT>
</MESSAGE>
JBO-AR:::AR_RAPI_TRX_NUM_IGN:
<MESSAGE>
<NUMBER>AR-855799</NUMBER>
<TEXT>The customer transaction ID takes precedence over the transaction number.</TEXT>
<CAUSE></CAUSE>
<ACTION></ACTION>
<DETAILS></DETAILS>
<INCIDENT></INCIDENT>
</MESSAGE>
JBO-AR:::GENERIC_MESSAGE:
<MESSAGE>
<NUMBER>AR-855636</NUMBER>
<TEXT>APPLY : ORA-01403: no data found</TEXT>
<CAUSE></CAUSE>
<ACTION></ACTION>
<DETAILS></DETAILS>
<INCIDENT></INCIDENT>
</MESSAGE>
JBO-FND:::FND_AS_UNEXPECTED_ERROR:
<MESSAGE>
<NUMBER>FND-3323</NUMBER>
<TEXT>An unexpected error has occurred.</TEXT>
<CAUSE></CAUSE>
<ACTION></ACTION>
<DETAILS>In package AR_RECEIPT_API_PUB and procedure Apply the following error occurred: ORA-01403: no data found.</DETAILS>
<INCIDENT></INCIDENT>
</MESSAGE>]]>
</faultstring>


Multiple errors occurred while processing this request. See Details.





JBO-AR:::AR_RAPI_RCPT_NUM_IGN:

AR-855741
The cash receipt ID takes precedence over the receipt number.





JBO-AR:::AR_RAPI_TRX_NUM_IGN:

AR-855799
The customer transaction ID takes precedence over the transaction number.





JBO-AR:::GENERIC_MESSAGE:

AR-855636
APPLY : ORA-01403: no data found





JBO-FND:::FND_AS_UNEXPECTED_ERROR:

FND-3323
An unexpected error has occurred.


In package AR_RECEIPT_API_PUB and procedure Apply the following error occurred: ORA-01403: no data found.


]]>


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply receipt using webservice



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


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