Fusion HR: Need to Store up to 999 Characters That Can Be Reported on in BI (Doc ID 2131736.1)

Last updated on DECEMBER 10, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.11.1.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

There is a requirement to store a text up to 999 characters and it must be easily accessible via a BIP report.

Initially solution was to use Person EIT EFF but issue is Flexfield segments have character limitation of 150.

Another solution was to store this data as a 'Documents of Record' (DOR). However, this option would not work because attachments cannot be reported on.

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