My Oracle Support Banner

E1: 30: P30200 (Bill of Material Inquiry) Shows Wrong Result when Row Security Exists on Items (Doc ID 2982212.1)

Last updated on OCTOBER 23, 2023

Applies to:

JD Edwards EnterpriseOne Product Data Management - Version 9.2 and later
Information in this document applies to any platform.


Wrong result is obtained for a parent item when inquiring in P30200 (Bill of Material Inquiry). The parent item contains an item with Row Security for SRP2 (SalesReportingCode2) category code. When an item is "hidden" by row securities the previous item in BOM is doubled.

Steps to replicate:

  1. P92001 (Work With Data Dictionary Items - Data Item Specifications) enable Data Dictionary SRP2 (SalesReportingCode2) for Row Security. Update package for the change.
  2. Setup row security on F4101 (Item Master), F4102 (Item Branch File), for SPR2 to deny access to a value
  3. Setup Category Code SPR2 for an item in P4101 (Item Master) and P41026 (Item Branch). Make sure the item is included in BOM in P30200. Ideally this item should be in a second position in BOM.
  4. In P30200 review parent item that includes the child item setup above and notice that first item in the BOM is doubled.


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.