ERPstuff - Oracle EBS Community

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

Check two things,

1- change 'DD-MON-YYY' to 'DD-MON-YYYY' .
2- Check effective date of your organization.

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,

Thanks folks my problem has been solve.