We help IT Professionals succeed at work.

Problem in Oracle HRMS Self Service

Medium Priority
2,540 Views
Last Modified: 2012-05-06
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 10.2.0.4
self-service-issue.JPG
Comment
Watch Question

Naveen KumarProduction Manager / Application Support Manager
CERTIFIED EXPERT

Commented:
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.
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:
tar:6283453.994
Issue caused due to use of User Hooks

We commented it and the problem was solved.

Thanks guys and see you soon

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.