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
Data Management - NZP Values from ERP - what accounts are included? Any account that has ever had d — 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

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!