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

Report message to a moderator

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.

Report message to a moderator

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 1620 times)

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jun 17 06:23:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.