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

Last updated on MARCH 13, 2017

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms