Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Splitting DFF column after first blank — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Splitting DFF column after first blank

13
Views
7
Comments
edited Jul 25, 2018 11:54AM in General Transactional Reporting (OTBI) 7 comments

Content

I am still struggling with advanced edits in OTBI so this post for a (seemingly) easy task came up:

 

Due to a rushed implementation we have cost centers to which our employees are assigned not from the general booking key setup (cross pillar) but solemly in HR core via a DFF. The DFF is setup in a way that makes its data unusable for any further analysis/export - it combines the cost center ID and its name in the same field:

eg: 00-00-000 HQ - CostCenter

This should be divided into CostCenterID column (00-00-000) and CostCenterName column (HQ - Cost Center). So delimitated by the first blank a split has to occur.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!