Error In Resource Form When Empolyee Has Future Dated Changes
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.
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.
ORA-01400: Cannot insert NULL into
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
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