How Can We Define The Mapping Set Based On SQL Query?
Last updated on MARCH 10, 2017
Applies to:Oracle Fusion Project Costing Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms