• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2341
  • Last Modified:

Problem in Oracle HRMS Self Service

Dear Experts

We had the following error in the Self Service screens related to SIT, however it works fine from the core application:

Error - Program error: Please inform your support representative that: FLEXFIELDS SERVER-SIDE VALIDATION Package reports error: call_userval() exception: ORA-01841: (full) year must be between -4713 and +9999, and not be 0

This error appears just after upgrading the DB to 10g version
1 Solution
Naveen KumarProduction Manager / Application Support ManagerCommented:
I have not worked on HRMS but have worked on discrete manufactuing applications and i guess some setup/initialization is missing after the upgrade.

I also think the error is coming from flex fields for one of the fields in your page. i am not sure whether that field is a hidden field or a visible field. Also i am not really sure about the whether the error is related to KFF ( key flex field ) or DFF ( descriptive flex field ).

I think logging a tar/SR would be right but parallely you can look at other options on how to resolve this.
amr_swgAuthor Commented:
Hi Guys

As per the Note: 295208.1 (Dependencies in KFF (SIT)).

The database procedure "FND_FLEX_PLSQL.VALIDATE" can be used to add "user hook" routine you can use to implement dependencies in
KFF segments.

We found customization using a date conversion that seems it is not suppported by 10G.

The statement that may caused the problem was:
AND to_date(user_segment8, 'YYYY/MM/DD HH24:MI:SS') >=
to_date(a.segment8, 'YYYY/MM/DD HH24:MI:SS')
AND to_date(user_segment8, 'YYYY/MM/DD HH24:MI:SS')<=
to_date(a.segment9, 'YYYY/MM/DD HH24:MI:SS')

I guess this was related to your first research:
Issue caused due to use of User Hooks

We commented it and the problem was solved.

Thanks guys and see you soon

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now