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.
 Forum Messages
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 |
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 |
| What is the exact error text following the ORA-20001 error? |
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
|
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 |
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.
|
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. |
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.
|
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 |
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
-----------------------------------------------------------------------------------
|
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
-----------------------------------------------------------------------------------
|
Add your message for ORA-20001
|
Home