Value Transformation While Loading Data Onto Custom Object Using "Manage File Import Activities" (Doc ID 2214951.1)

Last updated on DECEMBER 16, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

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?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms