ORA-20001: A user specified error message

Error messages starting from -20000 until -20999 are user specified error messages.

Oracle provides these range of codes so applications can raise an application specific error, which will be displayed after the chosen code.
This is done using the raise_application_error pl/sql function.

You'll have to contact the application provider should you want to have more detail about the error message.
Unless the error message is of an Oracle application or functionality, it is useless to contact Oracle for these errors.

Imagine I have a procedure which takes an argument. This arguments needs to be between 0 and 100:

create or replace procedure add_salary(pRaise number) is
begin
  if pRaise not between 0 and 100 then
    raise_application_error(-20000, 'Raise need to be between 0 and 100');
  end if;
  -- do further processing
end;
/
Procedure created.

SQL>

Now we test the procedure with a valid argument:

SQL> exec add_salary(0);

PL/SQL procedure successfully completed.

And now with an invalid argument:

SQL> exec add_salary(110);
BEGIN add_salary(110); END;

*
ERROR at line 1:
ORA-20000: Raise need to be between 0 and 100
ORA-06512: at "DEV01.ADD_SALARY", line 4
ORA-06512: at line 1

As one can see, we raised a custom error -20000 with a user defined error message.
The same thing happened with you, if you receive this error with one of our applications, you need to contact us in order to solve this problem.

So the only one who can help is the application vendor or service provider.

Welcome to our forum for Oracle error: ORA-20001 Add your own message

On 28-JAN-2008 21:46:22 amit asked: Address Update using UPDATE PERSON ADDRESS and CREATE PERSON ADDRESS APIs

Right now i am doing conversion for my client and at which they have existing address data for employees. And they have two ADDRESS_TYPE one is home address and one is work address and home is the PRIMARY address while the other is not. Now i need to check if the active primary address is present for the employee, i need to end_date the existing active address as of SYSDATE - 1 and create new primary address as of SYSDATE.

I am calling first the UPDATE api AND then the CREATE api for this scenario. When i do this I am getting the following error -
'"ORA-20001: A non Primary Address cannot exist without a corresponding Primary Address.
The Date change has left a Non Primary Address without a corresponding Primary Address."

Please guide me for the above issue. I need to resolve this ASAP.

Thanks a lot in advance.

Amit

On 29-JAN-2008 00:57:21 Sambhu Ghosh asked: ORACLE Error 20001

when I am going to import Project database from a file type *_m.zip in Smart plant PID software , I am getting following error msg " Import Failed:IMP 00017; Following statement failed with ORACLE error 20001"
Please guide me for the above issue. I need to resolve this ASAP.

Sambhu

On 29-JAN-2008 04:46:41 DbMotive asked: To Sambu

What is the exact error text following the ORA-20001 error?

On 29-JAN-2008 04:48:33 DbMotive asked: To Amit

You have to check the code for the UPDATE and CREATE api to see what is wrong.

It is a user defined error, and looking at the api code will probably tell you what causes this error

On 05-FEB-2008 10:20:05 Jim Borror asked: Oracle Developer

We are in the process of Installing Oracle Apps 11.5.10.2 on DB 9.206 and the OS is HP-UX 11.11.

I tried to create an Employee in the HRMS Module. I get this error Message.
APP-PER-289974: There has been a error processing this person. The error encountered is
'ORA-20001:HZ_API_MISSING_COLUMN:N,COLUMN, Party number', which occured in the procedure
per_hrtca_merge.create_tca_person at step 5.

Any help would be appreciated.
Thanks Jim Borror

On 05-FEB-2008 10:45:37 DbMotive asked: To Oracle Developer

Navigate to Profiles, you will see Site, Application, Responsibilty, User

Select Responsibility and a Valid HR resonsibilty, query up the given Profile and set this to "YES".
Whenever you create a new employee, the HR responsiblity number will be automatically generated.

On 14-FEB-2008 10:47:06 Jatin asked: intermittent stored procedure call failure with oracle 9.2.0.7

while calling a stored procedure the application is getting sqlException().
Are there any known issues?
Or any work around available.

Any clues would be highly appreciable?
Please revert as soon as possible.

On 14-FEB-2008 11:20:52 DbMotive asked: Catch all

Is there more information available with this error message?
The ORA-20001 is a user defined error, with user defined messages. So it can be virtual anything that's wrong.

On 22-FEB-2008 03:45:48 Sneha bhatt asked: give me solution

My insert query is in this manner "INSERT INTO OT_SO_HEAD(SOH_SYS_ID, SOH_COMP_CODE, SOH_LOCN_CODE, SOH_TXN_CODE, SOH_NO, SOH_DT, SOH_DOC_SRC_LOCN_CODE, SOH_AMD_DT, SOH_DEL_LOCN_CODE, SOH_CUST_CODE, SOH_CURR_CODE, SOH_EXGE_RATE, SOH_DISC_PERC, SOH_PRINT_STATUS, SOH_APPR_STATUS, SOH_CLO_STATUS, SOH_EXC_YN, SOH_ST_CODE, SOH_SUBMIT_STATUS, SOH_CUST_NAME, SOH_CR_UID, SOH_CR_DT ) VALUES ('112176','IPA1160028', 'NERUL-G', 'B2B_SOH', '2007080931', '22-Feb-2008', 'DS', '22-Feb-2008', '', 'IPA1160028', 'INR', '1', '0', '', '1', '', '1', 'L', '1', '', 'ABC', '22-Feb-2008')"
when i execute this query it occure error "ORA-20001: OP-164-Invalid parameter passed for selecting Transaction set-up recordERR1: ERR2: ERR3: ERR4: ERR5: ERR6: ERR7: ERR8:

ORA-06512: at "K105.RAISE_APPLICATION", line 48 ORA-06512: at "K105.O_DGET_TXN_SETUP", line 21

ORA-06512: at "K105.O_DCHECK_APPR_VALUES", line 11 ORA-06512: at "K105.ODBPROC102_SOH", line 99

ORA-06512: at "K105.ODBTRG102_SOH", line 66 ORA-04088: error during execution of trigger 'K105.ODBTRG102_SOH' "
Please solve my problem

On 27-JUN-2008 13:28:11 Maxual asked: ORA-20001

Hi,
when i tried to run a refresh procedure following error occurs.

--------------------------------------------------------------------------------
ERROR at line 1:
ORA-20001: No data processed
ORA-06512: at line 1
-----------------------------------------------------------------------------------

On 27-JUN-2008 13:28:52 Maxual asked: ORA-20001

On 19-SEP-2008 13:42:18 MILIND JOG asked: Inventory -> Items -> Master Items -> Order Management Tab -> Check Internal Ordered attribute

In above nevigation we are facing problem on

FRM-40735 ON-LOCK trigger raised unhandled exception ORA-20001

On 06-OCT-2008 12:22:29 prabhakar asked: INVIDITM.fmx ISSUE

we
couldn't able to save or create the new item in master inventory.

We couldn't able to save the master item in inventory form. There
is no action in the form. No status messages. Oracle says bug. No resolution
from oracle.

Error Message: FRM-40735: ON-INSERT trigger raised unhandled exception
ORA-20001.

ON-ERROR Trigger Fired:
Form: INVIDITM
Block: MTL_SYSTEM_ITEMS

On 08-JAN-2009 18:55:40 sumit b. asked: Error-:-ORA-20001: HR_51056_ASG_INV_POS_JOB_COMB:

how solve this Error-:-ORA-20001: HR_51056_ASG_INV_POS_JOB_COMB:

On 19-JAN-2009 08:32:49 gobinath asked: ORA-20001 + ORA-06512

ORA-20001:Error on the passage of: 130017188
ORA-20001:Value is not encrypted in the database operations

On 17-APR-2009 07:37:21 prabhat kumar asked: ORA-20001 error

System.Data.OleDb.OleDbException: ORA-20001: Atn for this is already processed: Updates not allowed ORA-06512: at "HRM.TG_ATN_BUPD", line 9 ORA-04088: error during execution of trigger 'HRM.TG_ATN_BUPD' at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at _Default.lnkok_click(Object sender, EventArgs e) in what does it mean and how i resolve it.

On 17-APR-2009 09:52:21 DbMotive replied

This is an application specific message, the company which supplied you the application need to answer this

Add your message

Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.

Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.

Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.