My Oracle Support Banner

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

Last updated on OCTOBER 20, 2021

Applies to:

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


On : 12.2.8 version, Transactions

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

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 .

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.


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

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