Error In Resource Form When Empolyee Has Future Dated Changes (Doc ID 2299547.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Bills/Routings Setup

Whenever there is a change made to the HR Maintain Employees form in which the change is future dated, there is an error that occurs when trying to add the employee to a Resource in the Resource(BOMFDORS) form.

ERROR
-----------------------
ORA-01400: Cannot insert NULL into
("BOM"."BOM_RESOURCE_EMPLOYEEES"."EFFECTIVE_START_DATE")


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using proper HR responsibility, navigate to the People form.
2. Make any change to the employee information and future date changes, so that the change will be effective, say tomorrow.
3. Navigate to Bills of Materials>Routings>Resources, query a Resource.
4. Click Employees button.
5. Attempt to add an employee, press Save.
6. See the error

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms