My Oracle Support Banner

Need the Ability to Automatically Reset Errored Records in Staging Tables (Doc ID 2513787.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 18 and later
Information in this document applies to any platform.

Goal

In WMS Cloud (Version 18C):

The 'Run Stage Interface' job type is used to process records in the staging tables that are ready to be processed.
Currently, there does not appear to be any existing job type, to correct (or reset) errorred records in the staging tables.

In order to correct interface errors, one can reprocess certain failed records directly in the 'Input Interfaces' screen, OR
can 'Clear Stage Records' and then correct the data issues directly in the input datafile (such as .xml file). Then, reload the staging tables with the corrected records.

In order to correct interface errors, there is a need that it is automated with a job whenever the amount to correct is very high for many facilities.


 

Solution

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
Goal
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.