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

Last updated on APRIL 21, 2015

Applies to:

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

Goal

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:

 

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