Hi CT
Thanks for the reply, your a genius,
i set the business group id manually, and alsi did trunc on sysdate, and set: v_job_definition_id NUMBER:=NULL;
updated code:
http://pastebin.com/d7ce018bbWhats happend now is its said procedure succesfully completed,
Howevere when i checked: per_jobs only old jobs where ion there not teh ones i tried to load using the api. And i also checke teh application:
hrms uk super user
workstructures > job > Description
So i then ran the proceudre again and it said:
ERROR at line 1:
ORA-20001: The job you have entered already exists in this Business Group. Please enter a unique na
ORA-06512: at "APPS.HR_JOB_API", line 878
ORA-06512: at "APPS.XXH3G_PKG_JOBS", line 46
ORA-06512: at line 1
but thats not true,
the only thing i can think of is:
Application Developer > Application: Lookups > Common
COMPANY_HR_JOB_FUNCTION
HERE I ENETERD ALL THE JOB FUNCTIONS MANUALLY.
AND UNDER THE LOOKUP:
COMPANY_HR_JOB_TITLE
I ENTERED ALL THE JOB TITLES MANUALLY AS WELL.
Now i was atempting to load job_codes, eg:
Personal Assistant.Administration
Personal Assistant.Human Resources
Planner.Engineering (Networks)
Planner.Engineering (Operations)
Planner.Engineering (Technology)
Planner.Marketing
However Personal Assistant only exists under COMPANY_HR_JOB_TITLE lookup, and Administration for the first job above exists only in the lookups: COMPANY_HR_JOB_FUNCTION,
They dont exist as a combination in: per_Jobs name field.
So does that mean i have to create all my jobs using the above two lookup values which are visible when i go to:
workstructures > job > Description
?
I have too many jobs: 436 jobs in total.
Shall i remove the lookup value values?
by the way job_code in my temp table where i loaded all my jobs stores the values as:
Planner.Engineering (Operations)
Planner.Engineering (Technology)
Thanks in advance
Tovia Singer