Create Receipt Using SOAP Fails With Error ORA-01403: no data found While Manual creation through UI works correctly (Doc ID 2801793.1)

Last updated on SEPTEMBER 02, 2021

Applies to:

Symptoms

CreateStandardReceipt through SOAP fails with following exception while the same values can be used to create receipt manually with out any errors.

Error:
=====

<faultcode>env:Server</faultcode>
<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:::GENERIC_MESSAGE: <MESSAGE><NUMBER>AR-855636</NUMBER><TEXT>CREATE_CASH : 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 Create_cash the following error occurred: ORA-01403: no data found.</DETAILS><INCIDENT></INCIDENT></MESSAGE>]]></faultstring>
<detail>
<tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<tns:code>FND:::FND_GENERIC_MULTI_MESSAGE</tns:code>
<tns:message><![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>]]></tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:detail xsi:type="tns:ServiceErrorMessage">
<tns:code>AR:::GENERIC_MESSAGE</tns:code>
<tns:message><![CDATA[JBO-AR:::GENERIC_MESSAGE: <MESSAGE><NUMBER>AR-855636</NUMBER><TEXT>CREATE_CASH : ORA-01403: no data found</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>]]></tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName>
</tns:detail>

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.