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

File based load that works will start failing if database isn't refreshed

edited Oct 6, 2020 9:21PM in Financial Consolidation and Close 4 comments

Content

Hi. Wanted to see if something is common behavior or not. Please comment if you're seeing or not seeing this behavior (or you know what's going on). In all cases we're running this with an admin ID and it happens whether we run manually or via EPM Automate.

We can load a data file via Data Management (replace mode) and have it load successfully. Then, if we add a new account or custom member and not refresh the database, loading the SAME file, that just worked, will now fail. The new member is not in the file. The reported error points to a FIX statement with the new member that is not part of our insertion rules. Once we do the refresh, the file will now load successfully again. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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