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
Flat File Options on Data Extract from TRCS — 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

Flat File Options on Data Extract from TRCS

Received Response
11
Views
3
Comments
edited May 28, 2019 3:49AM in Tax Reporting 3 comments

Summary

When extracting data from TRCS into a flat file are there better options for extracting Entity and Currency dimensions?

Content

I'm creating a flat file extract from TRCS to then be loaded to HFM. The file is created successfully, however, there remains 2 questions:

1. Entity - On extract, the Entity is in the format [Parent Name].[Entity Name]. I really only want the Entity member name. Last time I set this up, only the Member Name was included in the extract.

Is there a setting or means of only extracting the member name? For example 3030 instead of [EMEA].[3030].

My preference is not to manage this with mapping on load to HFM that would have to be maintained going forward.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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