My Oracle Support Banner

Prepost (reqext Post) Batch Aborts With ORA-02292 Error When Brazilian Localization Is Active (Doc ID 2094563.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Retail Merchandising System - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

When executing reqext post batch in RMS (Retail Management System) / RFM (Retail Fiscal Managment), Brazilian localization, the following error is occurring:



Steps to Reproduce:

  1. Ensure that you have at least one transfer which has a reference in TSFHEAD_L10N_EXT table
  2. Run prepost reqext post batch
  3. Notice the following error: 2292~ORA-02292: integrity constraint (ADMRMS.TLEXT_THD_FK) violated - child record found~DELETE: tsfhead

Changes

 

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