Friday, March 5, 2010
ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply
Error :
“Error Call the API. CREATE_AND_APPLY: Document sequence
does not exist for the current document even though profile
option Sequential Numbering is set to Partially Used.
Customer transaction identifier has taken precedence over
the transaction number. Invalid customer transaction identifier.
APPLY : ORA-01403: no data found ORA-01403: no data found in Package
AR_RECEIPT_API_PUB Procedure Apply”
does not exist for the current document even though profile
option Sequential Numbering is set to Partially Used.
Customer transaction identifier has taken precedence over
the transaction number. Invalid customer transaction identifier.
APPLY : ORA-01403: no data found ORA-01403: no data found in Package
AR_RECEIPT_API_PUB Procedure Apply”
Possible Reasons are:
- Transaction is closed
- Invalid Customer Transaction Identifier.
- Transaction Type Allows Over application
Fix:
Enter the parameter:
Enter the parameter:
p_show_closed_invoices => 'Y' in the AR_RECEIPT_API_PUB.APPLY()
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
7 Responses to “ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply”
October 18, 2011 at 8:50 PM
I have add parameter p_show_closed_invoices => 'Y' in the AR_RECEIPT_API_PUB.APPLY() but i still get same error message :
Status U
Message count 3
Message.Invalid customer transaction identifier.
Message.APPLY : ORA-01403: no data found
Message.ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply
November 14, 2012 at 1:56 PM
Did this get resolved, i am facing the same issue ?
August 9, 2013 at 8:11 PM
hi
any one have solution for issuse
February 19, 2018 at 10:45 PM
hi..
am also facing the same issue
please can any one help me...
August 10, 2022 at 2:36 AM
Hello, Is this issue resolved
December 20, 2022 at 11:28 PM
May 15, 2023 at 3:01 AM
For me, I faced the same issue and I used "p_show_closed_invoices => 'Y' ". It didn't solve the issue, but it changes the error message to "You have paid the same transaction twice. Please correct." . And I realized that I am trying to apply Receipt to the same transaction twice. And then I fixed that problem and the Receipt got applied. However I still don't understand is as I was doing it in loop, why I got this error not just once but twice in the loop.
Post a Comment