OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » AR INVOICE API PUB error when creating single invoice

Home » Applications » Oracle Fusion Apps & E-Business Suite » AR INVOICE API PUB error when creating single invoice (Oracle EBusiness)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AR INVOICE API PUB error when creating single invoice [message #557070]

Fri, 08 June 2012 10:35

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 2870 times)

Report message to a moderator

Re: AR INVOICE API PUB error when creating single invoice [message #557071 is a reply to message #557070]

Fri, 08 June 2012 10:53

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: AR INVOICE API PUB error when creating single invoice [message #557079 is a reply to message #557071]

Fri, 08 June 2012 12:26

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... and read WHEN OTHERS.

Regards
Michel

Report message to a moderator

Re: AR INVOICE API PUB error when creating single invoice [message #557221 is a reply to message #557079]

Mon, 11 June 2012 01:54

tautttee
Messages: 3
Registered: June 2012
Location: Harare Zimbabwe

Junior Member

thanks guys. let me try what u have said.

Report message to a moderator

Re: AR INVOICE API PUB error when creating single invoice [message #557222 is a reply to message #557221]

Mon, 11 June 2012 02:03

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:

Report message to a moderator