Which Delimiters To Use in PBSM for the File To Load Dimension and Hierarchy Data? (Doc ID 3029035.1)

Last updated on JUNE 20, 2024

Applies to:

Oracle Financial Services Profitability Management Cloud Service - Version 23B and later
Information in this document applies to any platform.
Profitability and Balance Sheet Management Cloud Service (PBSMCS)
Oracle Financial Services Enterprise Performance Management (EPM)
Modern Risk and Finance (MRF)

Goal

You want to know the file formats which can be used to load Dimensions and Hierarchies in the PBSMCS environment. The User Guide contains samples of the Dimension and Hierarchy files and the option is comma separated dat files.

There is one concern though about using the comma separated delimiter. If there is a comma in the description column from stg_dimensions_tl_inft for any member, there will be issue during loading.

What other delimiters can be used?

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Which Delimiters To Use in PBSM for the File To Load Dimension and Hierarchy Data? (Doc ID 3029035.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!