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()

3 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


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.