My Oracle Support Banner

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 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?


To view full details, 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 a vibrant support community of peers and Oracle experts.