API date Issue

Oracle Human Resource (Core HR), Payroll, Time & Labor, Self Service HR, Advance Benefit, Talent Management (Performance Management, Competency Management, Performance Appraisal, Goal Management), iRecruitment, Compensation Workbench
Post Reply
Moin Ahmed
Posts: 8
Joined: Fri Apr 03, 2009 2:06 am
Location: Pakistan

API date Issue

Post by Moin Ahmed »

hi all

My problem is when i am trying to insert date value to_date('01-JAN-1948', 'DD-MON-YYY') api gives an error.

ORA-20001: The organization is not valid for the current date


when i passed the sysdate to API the script run successfully.

please help its very urgent.

pls find API script in attched file.

regards
Top
admin
Posts: 2096
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:
Contact admin

Post by admin »

Check two things,

1- change 'DD-MON-YYY' to 'DD-MON-YYYY' .
2- Check effective date of your organization.
Top
eng_ahmad_2007
Posts: 258
Joined: Sun Oct 12, 2008 1:50 pm
Location: Saudi Arabia
Contact:
Contact eng_ahmad_2007

Post by eng_ahmad_2007 »

Dear Moin,

The problem is that your organization effective startt date is after the date you are entering in the API; thus, it is not found.
Correct the date either in the API or in Organization form and retry again.

Regards,
Top
Moin Ahmed
Posts: 8
Joined: Fri Apr 03, 2009 2:06 am
Location: Pakistan

Post by Moin Ahmed »

Thanks folks my problem has been solve.
Top
Post Reply

Return to “HCM (Human Capital Management)”



Who is online

Users browsing this forum: No registered users and 1 guest