Home » Applications » Oracle Fusion Apps & E-Business Suite » AR INVOICE API PUB error when creating single invoice (Oracle EBusiness)
AR INVOICE API PUB error when creating single invoice [message #557070] Fri, 08 June 2012 10:35 Go to next message
tautttee
Messages: 3
Registered: June 2012
Location: Harare Zimbabwe
Junior Member

After populating the necessary parameters I call this method : AR_INVOICE_API_PUB.create_single_invoice, in PL/SQL Developer and I get this error : Fatal ErrorORA-20001. I don't know where am I going wrong, the batch source id is -1, and it has auto trx numbering flag enable.Please find the attached file

Print out is as below :

>>>> l_msg_count=
>>>> l_msg_data=Fatal ErrorORA-20001:
>>>> l_return_status=U
>>>> l_customer_trx_id=
>>>> unexpected errors found!
>>>> Exception Thrown : Code => -20001 , Msg => ORA-20001: Fatal ErrorORA-20001:
  • Attachment: tauttee.sql
    (Size: 4.73KB, Downloaded 2325 times)
Re: AR INVOICE API PUB error when creating single invoice [message #557071 is a reply to message #557070] Fri, 08 June 2012 10:53 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
One problem is the exception handler.

It does NOTHING beside hiding the real error. Remove the exception handler completely to see where the actual error happens.
Re: AR INVOICE API PUB error when creating single invoice [message #557079 is a reply to message #557071] Fri, 08 June 2012 12:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... and read WHEN OTHERS.

Regards
Michel
Re: AR INVOICE API PUB error when creating single invoice [message #557221 is a reply to message #557079] Mon, 11 June 2012 01:54 Go to previous messageGo to next message
tautttee
Messages: 3
Registered: June 2012
Location: Harare Zimbabwe
Junior Member

thanks guys. let me try what u have said.
Re: AR INVOICE API PUB error when creating single invoice [message #557222 is a reply to message #557221] Mon, 11 June 2012 02:03 Go to previous messageGo to next message
tautttee
Messages: 3
Registered: June 2012
Location: Harare Zimbabwe
Junior Member

I have removed the Exception Handler and the raise_application_error. And I'm getting the below message after calling AR_INVOICE_API_PUB.create_single_invoice (which is the value of the l_msg_data from the x_msg_data):

Fatal ErrorORA-20001:
Re: AR INVOICE API PUB error when creating single invoice [message #591317 is a reply to message #557222] Fri, 26 July 2013 06:04 Go to previous messageGo to next message
orclfaq
Messages: 1
Registered: July 2013
Junior Member
Were you able to resolve this error? We are getting similar error when calling the single invoice public API.

Thanks.
Re: AR INVOICE API PUB error when creating single invoice [message #615773 is a reply to message #591317] Mon, 09 June 2014 03:24 Go to previous messageGo to next message
Alamine
Messages: 1
Registered: June 2014
Junior Member
Hi,
I have a same message error when i try to create invoice with ar_invoice_api_pub.create_single_invoice.
I need a quick helph
Re: AR INVOICE API PUB error when creating single invoice [message #616933 is a reply to message #557070] Mon, 23 June 2014 05:28 Go to previous message
extra777
Messages: 1
Registered: June 2014
Location: India
Junior Member
Hi,

Please restart your database & check. My issue has resolved.

Previous Topic: Setup Required to run "Item Organization Assignment" program
Next Topic: Problem installing EBS on linux box
Goto Forum:
  


Current Time: Thu Mar 28 10:43:49 CDT 2024