EBS Customizations (MOSC)

MOSC Banner

ORA-20001 When Trying to Create Single Invoice using AR_INVOICE_API_PUB

edited Jan 26, 2020 3:54PM in EBS Customizations (MOSC) 3 commentsAnswered
After populating the header, batch_source_rec, and 1 line I called AR_INVOICE_API_PUB.create_single_invoice and I get an error with it's x_msg_data having this value only "Fatal ErrorORA-20001 : ". Is there any way to read the complete message from the x_msg_data, so that I can find the problem.  The message seems to be truncated. Note that I am working on SQLDeveloper tool, that's where I'm running my procedure for testing only.
My Code Flows like this :

create or replace
PROCEDURE        "TEST_CRT_SNGL_INVOICE" (l_customer_trx_id OUT number,
l_return_status OUT varchar2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center