My Oracle Support Banner

Unique Constraint Violation When Creating An Item_loc After Creating Fiscal Reclassification (Doc ID 2387253.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle Retail Fiscal Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

Unique Constraint violation occurs when creating an item location after creating  fiscal reclassification

Error:


Steps To Recreate:

1. Create more than one fiscal reclassification for the same item, and both should be on the L10N_BR_FISCAL_RECLASS.
2. The effective date(vdate) should be greater than the active date of the fiscal reclassification created on the first step.
3. Run the stub to create an item location.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.