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”

Possible Reasons are:

  1. Transaction is closed
  2. Invalid Customer Transaction Identifier.
  3. Transaction Type Allows Over application
Fix:  
Enter the parameter:
p_show_closed_invoices => 'Y' in the AR_RECEIPT_API_PUB.APPLY()

6 Responses to “ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply”

Heru said...
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


MD said...
November 14, 2012 at 1:56 PM

Did this get resolved, i am facing the same issue ?


Anonymous said...
August 9, 2013 at 8:11 PM

hi
any one have solution for issuse


Unknown said...
February 19, 2018 at 10:45 PM

hi..
am also facing the same issue
please can any one help me...


Anonymous said...
August 10, 2022 at 2:36 AM

Hello, Is this issue resolved


Prashant said...
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

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.