Page 1 of 1
Oracle HR&payroll, Saudi Localization,Hijra date
Posted: Thu May 08, 2008 4:44 am
by alruwaished
Is there any soluation for the Hijra date in oracle Hrms any payroll have anyone this type of soluation yet, and in which level this soluation if it is there? please try to put your comment here
alruwaished@hotmail.com
Posted: Sat May 10, 2008 11:38 am
by alruwaished
- Can we Enter any data in Oracle Standard Form date field using Hijra date.
- Can we display Hijra date in Oracle Standard Form.
- Can we make any inquiry in Oracle Standard From using Hijra date.
- Can we make payroll period and hijra date from to.
- If SOB calendar in Gregorian date and the Payroll period in Hijra date
- I know we can convert date from Gregorian to hijra
can we split the journal base on Gregorian date one or two or three journal transaction date using Oracle Function if it is have error and the adjusting function of oracle not work any one have solution for that.
more, please any one have more information put your comment here
alruwaished
Posted: Fri Jun 13, 2008 4:22 pm
by alruwaished
First you need to used the following:-
1) you need to use Forms personalization.
2) You need to write some function.
3) Also you need to setup some profile option.
4) You need to defined more element.
please think more and share this information with all ERPSTUFF member
Posted: Sun Jun 22, 2008 5:09 pm
by alruwaished
I receive a lot of question about [V] Hijrah date, from and to Hijrah and Gregorian, yes Oracle have a function to convert from Hijrah to Gregorian calendar put it have one day plus or minus and you can use the oracle adjustment Calendar function to correct this.
Put also when you convert the same from Gregorian to Hijrah maybe you will get the same deferent.
Posted: Thu Jul 10, 2008 12:25 pm
by alruwaished
There is SQL program to change Calendar from Gorgerin to Hijrah done by Oracle long time. And use can create profile option to switch between them
[:)]and you can used the Zoom for Translating date from Hijrah to Gorgerin[:)]
Posted: Tue Jul 15, 2008 4:08 am
by rb210002
Dear Alruwaished,
This seems to be an interesting solution. Can you please share some more details. What SQL program is that?
Posted: Sat Jul 19, 2008 5:03 am
by alruwaished
[quote]There is SQL program to change Calendar from Gorgerin to Hijrah done by Oracle long time. And use can create profile option to switch between them
[:)]and you can used the Zoom for Translating date from Hijrah to Gorgerin[:)]
<i><div align="right">Originally posted by alruwaished