Oracle HR&payroll, Saudi Localization,Hijra date

[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

[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

[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

[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.

[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[:)]

[rb210002]

Dear Alruwaished,
This seems to be an interesting solution. Can you please share some more details. What SQL program is that?

[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