Hello All,
We are using SOAP Request processApplyReceipt to apply multiple Transactions to a Receipt in one request. Whenever there are errors, the Request sends back the Response where we are unable to link which error belongs to which data set.
How do we extract the faultstring/faultcode for each of these dataset separately ?
Below is the Request Payload and Response Payload for your reference:
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/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:processApplyReceipt>
<typ:changeOperation>Create</typ:changeOperation>
<!--Zero or more repetitions:-->
<typ:applyReceipt> (-- DataSet 1)
<com:ReceiptId></com:ReceiptId>
<com:AmountApplied>75.26</com:AmountApplied>
<com:ReceiptNumber>1527714</com:ReceiptNumber>
<com:TransactionNumber>12140741</com:TransactionNumber>
</typ:applyReceipt>
<typ:applyReceipt> (-- DataSet 2)
<com:ReceiptId></com:ReceiptId>
<com:AmountApplied>93.91</com:AmountApplied>
<com:ReceiptNumber>1527714</com:ReceiptNumber>
<com:TransactionNumber>12142328</com:TransactionNumber>
</typ:applyReceipt>
<typ:applyReceipt> (-- DataSet 3)
<com:ReceiptId></com:ReceiptId>
<com:AmountApplied>84.82</com:AmountApplied>
<com:ReceiptNumber>1527714</com:ReceiptNumber>
<com:TransactionNumber>12144668</com:TransactionNumber>
</typ:applyReceipt>
</typ:processApplyReceipt>
</soapenv:Body>
</soapenv:Envelope>
Response Payload:
RAW:
HTTP/1.1 500 Internal Server Error
Content-Type: multipart/related;type="application/xop+xml";boundary="----=_Part_1577_331723123.1688118975500";start="<23222c15-e462-487f-9d5b-e4516c0f4760>";start-info="text/xml"
Referrer-Policy: origin
X-Content-Type-Options: nosniff
X-ORACLE-DMS-ECID: 005zpNJpqfGDoYNpuGL6iX0000BV0003SE
X-ORACLE-DMS-RID: 0:3
SOAPAction: ""
X-XSS-Protection: 1; mode=block
Content-Language: en
Strict-Transport-Security: max-age=31536000; includeSubDomains
Date: Fri, 30 Jun 2023 09:56:15 GMT
Connection: close
Vary: Accept-Encoding
Set-Cookie: JSESSIONID=; expires=Thu, 01-Jan-1970 01:00:00 GMT; path=/; HttpOnly;SameSite=None;Secure
Set-Cookie: _WL_AUTHCOOKIE_JSESSIONID=; expires=Thu, 01-Jan-1970 01:00:00 GMT; path=/; secure; HttpOnly;SameSite=None;Secure
AKGRN: 0.1c2d2d17.1688118974.1966a79
------=_Part_1577_331723123.1688118975500
Content-Type: application/xop+xml;charset=UTF-8;type="text/xml"
Content-Transfer-Encoding: 8bit
Content-ID: <23222c15-e462-487f-9d5b-e4516c0f4760>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header/><env:Body><env:Fault><faultcode>env:Server</faultcode><faultstring>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:::AR_RAPI_TRX_ID_INST_INVALID: <MESSAGE><NUMBER>AR-855792</NUMBER><TEXT>You must enter a valid combination of customer transaction ID and installment.</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><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>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:::AR_RAPI_RCPT_NUM_IGN</tns:code><tns: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></tns:message><tns:severity>SEVERITY_ERROR</tns:severity><tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName></tns:detail><tns:detail xsi:type="tns:ServiceErrorMessage"><tns:code>AR:::AR_RAPI_TRX_NUM_IGN</tns:code><tns: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></tns:message><tns:severity>SEVERITY_ERROR</tns:severity><tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName></tns:detail><tns:detail xsi:type="tns:ServiceErrorMessage"><tns:code>AR:::AR_RAPI_TRX_ID_INST_INVALID</tns:code><tns:message>JBO-AR:::AR_RAPI_TRX_ID_INST_INVALID: <MESSAGE><NUMBER>AR-855792</NUMBER><TEXT>You must enter a valid combination of customer transaction ID and installment.</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><tns:detail xsi:type="tns:ServiceErrorMessage"><tns:code>AR:::GENERIC_MESSAGE</tns:code><tns: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></tns:message><tns:severity>SEVERITY_ERROR</tns:severity><tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName></tns:detail><tns:detail xsi:type="tns:ServiceErrorMessage"><tns:code>FND:::FND_AS_UNEXPECTED_ERROR</tns:code><tns: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></tns:message><tns:severity>SEVERITY_ERROR</tns:severity><tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName></tns:detail><tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName></tns:ServiceErrorMessage></detail></env:Fault></env:Body></env:Envelope>
------=_Part_1577_331723123.1688118975500--
XML:
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Header/>
<env:Body>
<env:Fault>
<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:::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:::AR_RAPI_TRX_ID_INST_INVALID: <MESSAGE><NUMBER>AR-855792</NUMBER><TEXT>You must enter a valid combination of customer transaction ID and installment.</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>
<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:::AR_RAPI_RCPT_NUM_IGN</tns:code>
<tns:message><![CDATA[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>]]></tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName>
</tns:detail>
<tns:detail xsi:type="tns:ServiceErrorMessage">
<tns:code>AR:::AR_RAPI_TRX_NUM_IGN</tns:code>
<tns:message><![CDATA[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>]]></tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName>
</tns:detail>
<tns:detail xsi:type="tns:ServiceErrorMessage">
<tns:code>AR:::AR_RAPI_TRX_ID_INST_INVALID</tns:code>
<tns:message><![CDATA[JBO-AR:::AR_RAPI_TRX_ID_INST_INVALID: <MESSAGE><NUMBER>AR-855792</NUMBER><TEXT>You must enter a valid combination of customer transaction ID and installment.</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>
<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>APPLY : 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>
<tns:detail xsi:type="tns:ServiceErrorMessage">
<tns:code>FND:::FND_AS_UNEXPECTED_ERROR</tns:code>
<tns:message><![CDATA[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>]]></tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName>
</tns:detail>
<tns:exceptionClassName>oracle.apps.fnd.applcore.messages.ApplcoreException</tns:exceptionClassName>
</tns:ServiceErrorMessage>
</detail>
</env:Fault>
</env:Body>
</env:Envelope>