My Oracle Support Banner

How to break up Concatenated Account Segments into sub-segments using substr function (Doc ID 1947859.1)

Last updated on JANUARY 31, 2020

Applies to:

Oracle Fusion Application Toolkit - Version and later
Information in this document applies to any platform.


The goal of this document is to show how to break the Financials Account or Category segments into Segment1, Segment2, Segment3 etc...

For example, your Account segment may look like AAAA.BBB.CC.DDDDD and you want to break it into:



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

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