R12.1: Advise On The INIT Parameter _GBY_HASH_AGGREGATION_ENABLED (Doc ID 1056796.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 23-Dec-2015***

Goal

Noticed that after the 12.1.1 upgrade the database initialization parameter _gby_hash_aggregation_enabled is set to false.
After checking the log files,  found out that the parameter is set via the apintbal.sql script.
We haven't found any reference to the fact this is a recommended R12 parameter, and I wondered if the apintbal.sql script is incorrectly setting it at system level, and maybe it is supposed to be set at session level for use within the script only.

Can you please confirm as to whether the parameter should be set during normal operation of a 12.1.1 system ?


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