My Oracle Support Banner

Failed Resource Transactions After Upgrade From 12.1.3 To 12.2.8 (Doc ID 2558568.1)

Last updated on APRIL 09, 2020

Applies to:

Oracle Work in Process - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Transactions

When attempting to process resource transactions, the following error occurs.

ERROR
-----------------------
APP-FND-01564: ORACLE error 1400 in witvrir_insert_op_resources

Cause: witvrir_insert_op_resources failed due to ORA-01400: cannot insert NULL into ("WIP"."WIP_OPERATION_RESOURCES"."STANDARD_RATE_FLAG")
.

The SQL statement being executed at the time of the error was: and was executed from the file .


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Work in Process
2. Discrete - > Discrete
3. Release the Work Order
4. Insert the Record into WIP_COST_TXN_INTERFACE table.
5. After the cost manager/resource cost worker runs. Please note there is not any record in wip_interface_errors.


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.