Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Extracting large amounts of base data from FCCS

edited Jan 22, 2021 5:46PM in Financial Consolidation and Close 3 comments

Summary

Requesting best method for extracting large amount of base level data from FCCS

Content

What is the best method of extracting large amounts of base data from FCCS? We have attempted extracting this data set through data management and smartview and been unsuccessful due to the following:

Data Management - extract times out due to the size of data which is expected to exceed the 65,000 row limit in XLS files.  An SR with Oracle suggested splitting up the extract however this is not desirable.

SmartView - exceeds Excel limits.

Are there other methods available to extract this data from FCCS?  The preference is to have this in a CSV or similar delimited format which was previously done in HFM through Extended Analytics.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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