Customer Form Issue: Customer Bill To Accounting Details Form Shows Incomplete List of Values for Company (CO) Segment (Doc ID 1370633.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In R12.1.3, the Company (CO) Segment on Customer Bill To Details for Accounting shows incomplete list of values (lov). The expectation is that users should have a valid list of values listing all valid Company segments. However, it only displays one company.

In the case reported, the only valid value is 064 which is Balancing Segment Value (BSV) of the US operating unit.

For example:

If looking at customer site in OU OracleCorp France (E), the CO segment 082 should appear in the CO segment list of values.
If looking at customer site in OU OracleCorp Spain (E), the CO segment 081 should appear in the CO segment list of values.

Instead users only see 003, which is Balancing Segment Value for OracleCorp Europe Ltd in the CO segment list of values if:

-MO: Operating Unit = OracleCorp Europe Ltd
-MO: Security Profile = Setup Business Group at Site Level, OracleCorp Europe Ltdat Responsibility Level (for EU AR Responsibility)

Or users only see 064, which is Balancing Segment Value for OracleCorp USA Company in the CO segment list of values if:

-MO: Operating Unit = OracleCorp (USA) Company
-MO: Security Profile = Setup Business Group at Site Level, OracleCorp European Unit at Responsibility Level (for EU AR Responsibility)

All the CO segments appear in the list of values if the value setting of MO: Operating Unit is changed to 'OracleCorp Europe Ltd #2':

-MO: Operating Unit = OracleCorp Europe Ltd #2
-MO: Security Profile = Setup Business Group at Site Level, OracleCorp European Unit at Responsibility Level (for EU AR Responsibility)

It is verified that the security profile 'OracleCorp European Unit' is defined to include the following operating units:
-OracleCorp Europe Ltd
-OracleCorp France (E)
-OracleCorp Spain (E)

This should give the responsibility 'EU AR' access to the above 3 operating units assigned to the security profile 'OracleCorp European Unit' but it did not.

It seems that the CO segment values LOV are coming from whatever is set at MO: Operating Unit.
Multi-Org_access (MOAC) is used and therefore users expect the Customer Bill To Accounting Details form to look at the MO: Security Profile instead of MO: Operating unit.

Steps to reproduce:

1) Define security profile 'OracleCorp European Unit '

Responsibility: HRMS Super User
Navigation: Security > Define Security Profile

-Name = OracleCorp European Unit
-Under Organization tab, select 'Secure organizations by organization hierarchy and/or organization list' for 'Security Type'
-Enter rows with the following organization names with 'Operating Unit':
-OracleCorp Europe Ltd
-OracleCorp France (E)
-OracleCorp Spain (E)

2) Run Security List Maintenance request
Responsibility: HRMS Super User
Navigation: Processes & Reports > Submit Process & Report

3) Assign Custom Responsibilities to User

Responsibility: System Administrator
Navigation: Security : User > Define
-Query the user
-Add the responsibility 'EU AR' to the user

4) Assign the Security Profile 'OracleCorp European Unit' to responsibility 'EU AR'
Responsibility: System Administrator
Navigation: Profile > System

-MO: Default Operating Unit = OracleCorp Europe Ltd
-MO: Security Profile = OracleCorp European Unit

5) Test the issue
Responsibility: EU AR
Navigation: Customers > Customers

-Query a customer
-Navigate to Customer Site
-Select Business Purpose tab
-Click on Details button on BILL TO
-Click on LOV for Revenue Account
-Click to open the CO Segment LOV.
-In the Search and Select window for CO segment, enter the wild card % and click Go. Company Segment LOV shows incorrect value (003 or 064 depending upon the value setting of MO: Operating Unit)

Changes

 

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