Oracle error when using api: ORA-20001: HR_289477_JOB_GROUP_ID, ORA-06512: at "APPS.HR_JOB_API", line 878

Question

Hi

Code for my api call package is here:
http://pastebin.com/m704097f6

I setup jobs flexfield as:

2 segments

job name
job desc

allow dynmic insert is set to on, etc..

then i ran the above api to load jobs information into oracle but i get strange error:

ERROR at line 1:
ORA-20001: HR_289477_JOB_GROUP_ID
ORA-06512: at "APPS.HR_JOB_API", line 878
ORA-06512: at "APPS.XXcompany_PKG_JOBS", line 58
ORA-06512: at line 1

I am confused, i even set job_group_id manually in the api call which is 21.

Still gave me same error.

Thanks in advance

Answer 1

You should go to metalink.oracle.com. That is the best forum for this question. Before you go there, you should look the code in data dictionary view DBA_SOURCE.

Answer 2

Ora-20001

Answer 3

I don't know if it qualifies as a pick up line, but: I hit it off with a woman I met one night, she asked me, "Want to come back to my place and help me move some furniture?" And I did want to help!