DLYPRG Program Does Not Delete Data From All L10N Tables When A Store Is Deleted (Doc ID 2165727.1)

Last updated on JULY 27, 2016

Applies to:

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

Symptoms

DLYPRG (Daily Purge) program does not delete data from L10N_BR_ENTITY_CNAE_CODES and L10N_BR_ENTITY_TAX_REGIME tables when a store is deleted.

 Steps to Reproduce:

  1. Create a new store using Store Maintenance [store] screen.
  2. Add the localization attributes (Options->localization attributes).
  3. Ensure to add CNAE Codes, Tax Regimes and Tributary Substitution.
  4. Save the store.
  5. Now open the store in edit mode and click the delete button.
  6. Run dlyprg program and verify data.
  7. Note that Store related data in STORE_L10N_EXT and L10N_BR_ENTITY_TRIB_SUBS tables is successfully deleted.
  8. Data is not deleted from L10N_BR_ENTITY_CNAE_CODES and L10N_BR_ENTITY_TAX_REGIME tables.

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