Problem in Oracle HRMS Self Service

Posted on 2009-02-16
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
Question by:amr_swg
    LVL 28

    Expert Comment

    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.

    Accepted Solution

    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

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now