<div>
I have not worked on HRMS but have worked on discrete manufactuing applications and i guess some setup/initialization is missing after the upgrade.<br />
<br />
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 ).<br />
<br />
I think logging a tar/SR would be right but parallely you can look at other options on how to resolve this.
</div>


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.

<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
We had the following error in the Self Service screens related to SIT, however it works fine from the core application:<br />
<br />
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<br />
<br />
This error appears just after upgrading the DB to 10g version 10.2.0.4<br />
<a href="https://filedb.experts-exchange.com/incoming/2009/02_w08/107011/self-service-issue.JPG" target="_blank" class="file-inline" title="self-service-issue (144 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>self-service-issue.JPG</a>
</div>
</div>


self-service-issue.JPG

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

Problem in Oracle HRMS Self Service

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.