My Oracle Support Banner

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

Last updated on SEPTEMBER 28, 2017

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Oracle Enterprise Asset Management - Version 12.1.3 to 12.1.3 [Release 12.1]
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.