How to select multiple values in HCM Extract parameter (table value set)?

(Doc ID 2402132.1)

Last updated on MAY 22, 2018

Applies to:

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

Goal

Would like to fetch Assignment data within a given date range (defaulting to 90 days range) except HIRE and REHIRE action codes on a report. The user should be able to select multiple actions and action reasons values from the runtime parameters.

Proposed Solution:- Considering the high volume of data, they have opted for HCM extract tool for development.

Challenge is Selection of multiple values in a parameter (Value set) is a limitation of the product. They can replace HCM extract by BI publisher but it might hit on report performance due to the high volume of data.

Please provide recommendations on the best alternative for extracting multiple values considering HCM Extract Limitation and Performance of BI Publisher.

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