SLA Payroll Costing - GL Segment Security Is Ignored On Drilldown (Doc ID 1313681.1)

Last updated on JULY 17, 2024

Applies to:

Symptoms

Security restrictions in the GL are not reflected in the Payroll subledger.

 
The following has been tried as a solution but did not work:

1) Tried setting the following profile options to Yes at User level.

• SLA: Enable Data Access Set Security in Subledger
• SLA: Enable Subledger Transaction Security in GL

This made no difference but these settings were left in place.

2) Tried updating the xla_subledgers table to set the security_function_name = 'XLA_SECURITY_POLICY_PKG.MO_POLICY' which is what a number of other modules are set to.

This caused an error to occur on the drilldown itself. The security_function_name was set back to null.

Steps to Reproduce:

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

1. Run Process Payroll, Costing, Transfer to SLA, Create Accounting (final mode) => this generates GL entries and related SLA entries
2. Using responsibility with restricted access via flexfield security rules, navigate Inquiry\Journal and query for the Payroll source journal created from step 1.
3. Review Journal => this shows only the detail lines that the user/responsibility has access to
4. Select a line and click on Line Drilldown => this opens the subledger screens and displays the subledger journal entry lines related to the GL line
5. Click on View Journal Entry => this opens the subledger journal entry and displays ALL lines including those that the user/responsibility does not have access to

Cause

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