My Oracle Support Banner

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

Last updated on AUGUST 13, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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