My Oracle Support Banner

Wip_massload_pub.massLoadJobs Fails When Updating Discrete Jobs Due to Error VALIDATION ERROR HAPPENED! (Doc ID 3010787.1)

Last updated on JULY 15, 2024

Applies to:

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

Symptoms

Have an interface from an third party application that creates discrete jobs and subsequently updates a few details on the newly created discrete jobs based on various conditions.
The interface uses wip_massload_pub.massLoadJobs API to create and update discrete jobs.
This process works flawlessly in 12.1.3 environment. In 12.2.12 the APi is failing with the following error when trying to update discrete jobs.
The discrete job creation works fine. It's the discrete job update that fails with this error.

ERROR

VALIDATION ERROR HAPPENED!

STEPS

1. Load data into wip_job_schedule_interface and wip_job_dtls_interface tables.
2. Call wip_massload_pub.massloadjobs API from a pl/sql program or run WIP Mass Load concurrent program.
3. The error occurs regardless of the method used (API call vs Concurrent Program).


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.