My Oracle Support Banner

E1: 43: Row Security Fails to Select One View Purchase Order Receipts Inquiry Records (P43260 / V43260A) (Doc ID 2637125.1)

Last updated on FEBRUARY 18, 2020

Applies to:

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

Symptoms

One View Purchase Order Receipts Inquiry (P43260) does not return records for user with row security over one of the join tables, such as the F4102 Item Branch File.  P43260 uses a business view (V43260A) that is a join over F4102 and F43121 and F4311. The application should display records that exist in the primary table even when there are no matching records in the secondary table. Expect Join between F4102 and F43121 and F4311 to return F43121 records.

The issue can be reproduced at will with the following steps:

  1. Set user row security by Company number.
  2. Enter Purchase order and report receipts.
  3. Using P43260, inquire on receipts for voucher match.
  4. Records that do not match F4102 row security are not returned

 

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.