Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle HRMS JOBS API error: ORA-20001: HR_289477_JOB_GROUP_ID (11.5.10 oracle dbms v 8/9 sql*plus)
Oracle HRMS JOBS API error: ORA-20001: HR_289477_JOB_GROUP_ID [message #333766] Mon, 14 July 2008 07:09 Go to next message
tovia123
Messages: 7
Registered: May 2008
Location: UK
Junior Member
Hi

I am trying to load jobs from my temp/staging table in oracle to oracle hrms:

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 in my code above as 21, which it is.
but Still gave me the same error.

Thanks in advance

Tovia Singer
Re: Oracle HRMS JOBS API error: ORA-20001: HR_289477_JOB_GROUP_ID [message #333788 is a reply to message #333766] Mon, 14 July 2008 07:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Any error between ORA-20001 and ORA-21000 is raised by an application, not by ORacel itself.

This is an error that is being raised by the package/procedure HR_JOBS_API, which was called by XXcompany_PKG_JOBS.

As I don't have a copy of Oracle HR to hand, that's all the help I can provide.
Re: Oracle HRMS JOBS API error: ORA-20001: HR_289477_JOB_GROUP_ID [message #334054 is a reply to message #333788] Tue, 15 July 2008 05:57 Go to previous messageGo to next message
tovia123
Messages: 7
Registered: May 2008
Location: UK
Junior Member
Hi

Sorry for delay my boyfriend also tried to help me, but he is not very very good, lol

Thanks for that, i have got further now:

code:
http://pastebin.com/da8ef0f2
I also attached code in file, thanks

I get the following now in sql* plus:

SQL> EXECUTE XXCOMPANY_PKG_JOBS.XXCOMPANY_LOAD_JOBS;
Ex:4087,1
Ex:4088,1
Ex:4089,1
Ex:4090,1
Ex:4091,1
Ex:4092,1
Ex:4093,1
Ex:4094,1
Error:ORA-20001: FLEX-ID DOES NOT EXIST:

PL/SQL procedure successfully completed.


It loaded 8 records.

Why doesnt it load all records?

I cheked table per_job, and also through hrms superuser.

I only have 8 records created.

How to do i load all the records?

Thanks in advance

tovia S
  • Attachment: code.sql
    (Size: 2.75KB, Downloaded 385 times)
icon14.gif  successfully loaded jobs via api (oracle hrms), see code attached if interested [message #334179 is a reply to message #333766] Tue, 15 July 2008 12:40 Go to previous message
tovia123
Messages: 7
Registered: May 2008
Location: UK
Junior Member
Hi

Just to share with you everyone.
I have succesfully loaded all my jobs through the api,

Full code is attached.

Thanks JRowbottom for your input and quick reply earlier.

Aurevoir

Tovia Singer
Previous Topic: Oracle iStore Application Error for Minisite Homepage
Next Topic: About Oracle fusion
Goto Forum:
  


Current Time: Thu Dec 08 08:42:51 CST 2016

Total time taken to generate the page: 0.08123 seconds