My Oracle Support Banner

Security at Merchandise Level Not Working Properly in Cost Discrepancy Review List (Doc ID 2517304.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.


User can resolve discrepancies of another dept hierarchy (merchandise level) when DATA_LEVEL_SECURITY_IND='Y' and dept does not exists in FILTER_GROUP_MERCH table.

Steps to Recreate:

  1. Create GROUP (USER_GROUP).
  2. Assign user to this GROUP(SEC_USER, SEC_USER_GROUP).
  3. Add this group in tables FILTER_GROUP_ORG and FILTER_GROUP_MERCH to restrict user access.
  4. Thus expect user to have access to cost discrepancies of specific hierarchy level, but it does not work as expected and user has access to all documents in the system.




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

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