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

Last updated on APRIL 15, 2024

Applies to:

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:

001 MEAL ALLOWANCE
002 FRINGE BENEFITS
003 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

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