How Can We Define The Mapping Set Based On SQL Query? (Doc ID 2242599.1)

Last updated on MARCH 10, 2017

Applies to:

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

Goal

How can we define the Mapping Set based on SQL query ?

While defining Mapping set for Labor Cost Account in Projects SLA, For one of the segment we have a requirement to derive the segment value based on the SQL query. Client has provided a unique code on the expenditure type (that is their naming convention for defining expenditure type). For example:

024 MEAL MEAL ALLOWANCE
098 FRGBN FRINGE BENEFITS
234 CMPHD COMPUTER HARDWARE

Client is using EBS as Legacy and we are implementing cloud for projects. In eBS, they have the below query to find the value of the segment.

select substr(name,1,4) from hr_all_organization_units where organization_id

Question: How can we define the same logic in Cloud?
Question: Can we build a mapping set based on query?
 

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