We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Data Management - NZP Values from ERP - what accounts are included? Any account that has ever had d

Received Response
25
Views
4
Comments
edited Feb 16, 2021 10:47PM in Account Reconciliation 4 comments

Summary

What 0 value is ERP including during a pull from ERP, any account that ever had data? All accounts?

Content

I have a direct connect set to Oracle ERP.  I have disabled the zero suppression.  What zero values are pulling from ERP?  Would it include any account that ever had data? Every Account?  If a new account is set up does it have a zero?

From the definition in the Administering Data Management For Oracle EPM cloud.

The NZP expression is used to disable zero suppression during the data-load process. By default, Data Management bypasses accounts in the trial balance that have zero balances. In certain circumstances, you may want to load all accounts, to ensure that values that should be zero are replaced. You enter: 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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