Cannot Change LEAF_ONLY_FLAG OPTION On Dimension Load Using STG_XXXXX_MASTER

(Doc ID 1266362.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 and later [Release: 7 and later ]
Information in this document applies to any platform.
OFSAA

Goal

Field DIM_ORG_UNIT_B.leaf_only_flag, is always set to 'Y' when trying to populate from staging table STG_ORG_UNIT_MASTER through the procedure 'fn_STGDimDataLoader'.
Why the value of the 'leaf_only_flag' flag cannot be set to 'N'?

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