Profile "GMF: Log All Subledger Variances" does not seem to be working in R12 (Doc ID 2109983.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Subledger Accounting

ACTUAL BEHAVIOR
---------------
Profile "GMF: Log All Subledger Variances" does not seem to be working.

Set profiles "GMF: Log All Subledger Variances" to Yes & "GMF: Subledger Variance Type" to "Scale to Actual". Want to see variances for both Scale to Plan and Scale to Actual. Per note 1096287.1, when "GMF: Log All Subledger Variances" is set to Yes, the data for all variances was stored in gl_subr_test_var and gl_subr_led_var in 11i, but in R12 is stored in gmf_xla_extract_headers and gmf_xla_extract_lines.

But gmf_xla_extract_lines is only showing variances for Scale to Actual.

The main situation that we are trying to solve is this:
In 11i, we have 2 organizations that belong to one legal entity. They had different values for the profile GMF: Subledger Variance Type. The accounting process was run independently.
In R12, the opm accounting preprocessor runs by legal entity and cannot have different values for this profile. Thats why we need to log all the variances and solve this with an accounting rule in SLA.

We have tried with all the possible values of both profiles and only the variances for the GMF: Subledger Variance Type are put in the tables. Setting "GMF: Log All Subledger Variances" to Yes does not seem to do anything.

EXPECTED BEHAVIOR
-----------------------
Expect to see both types of variance calculations since "GMF: Log All Subledger Variances" is set to Yes

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set "GMF: Log All Subledger Variances" to Yes & "GMF: Subledger Variance Type" to "Scale to Actual"
2. Run OPP and Create Acctg

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the types of variances they want in each org.

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