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.


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


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.




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.