How Can We Define The Mapping Set Based On SQL Query?
(Doc ID 2242599.1)
Last updated on APRIL 15, 2024
Applies to:
Oracle Fusion Project Costing Cloud Service - Version 11.1.11.1.0 and laterInformation 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:
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
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 |