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

IGNORE Mappings in SQL

Accepted answer
234
Views
4
Comments
edited Oct 11, 2019 12:01AM in Financial Consolidation and Close 4 comments

Summary

Error exporting to FCCS when mapping to IGNORE utilizing SQL scripting

Content

Was hoping someone could help with this.  I setup Data Load Mapping using SQL script, if the criteria isn't met I have it map to 'IGNORE'.  In Workflow all appears to be working (no validation errors and all the accounts are mapped properly) however when I export the data the it errors out saying 'Fetch of Driver Member "IGNORE" failed.'  All the data loads properly however the process fails which is unacceptable.  I know this was a bug in the past since the VALID_FLAG did not get updated when using SQL scripts which mapped to ignore so I included the code to set

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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