FCL LOV Depending Upon Business Unit (Doc ID 2263152.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Customer Question
=================
 
We have a requirement in which Sales Cloud Opportunity Data has to be pushed to Fusion Financials AR Invoice.
I am having an issue with one field: 'Transaction Type'.
Transaction Type is a Fixed Choice List field in AR, whose values are derived based on the LE / Ledger / Profit Center.
 
In Sales Cloud, the requirement will suffice if I am able to define a FCL (TransactionType_c).
The list of values which should be available for selection are to be with respect to the LE / BU of the logged in Sales User who is creating the opportunity.
 
For Example:-
Transaction Type field in AR:
For LE 1 / BU 1 -> a,b,c (list of values)
For LE 2 / BU 1 -> p,q,r (list of values)
 
Transaction Type custom field in Sales Cloud Opportunity Page (the requirement):
If Sales user is defined in LE 1, BU 1 -> The list of values available for selection will be a,b,c (other values in the LOV like p,q,r will not be available for selection)
If Sales user is defined in LE2, BU2 -> The list of values available for selection will be p,q,r (other values in the LOV like p,q,r will not be available for selection)

Please assist in achieving this requirement.
 

Solution

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