Value Transformation While Loading Data Onto Custom Object Using "Manage File Import Activities"
Last updated on DECEMBER 16, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
We want to transform values automatically while data is being loaded onto Custom Object using Manage File Import Activities.
Legacy system is passing feed with values as 0 and 1 for Boolean attributes. We want them to be stored ans No and Yes respectively. Since we want to automate the processing, we can not change the values manually.
1. Is this value transformation possible while defining mapping for custom objects using Manage File Import Mappings
2. Can we use triggers on Custom object to transform these values?
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