E1: 05: Payroll Exception Report (R053191) cannot be run standalone when row security is implemented (Doc ID 1618702.1)

Last updated on DECEMBER 03, 2015

Applies to:

JD Edwards EnterpriseOne Time and Labor - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

 If R053191 is run after time entry but before running R07200 Pre-payroll it does not return exception records.  If row security is implement (for example, over business unit) but the user has access to the business unit the business view over F06116 and F07350 (no records yet) uses a SQL 92 Left Outer Join which with security treats the select like a simple join and returns no records.

Cause

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 hundreds of Community platforms