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
FCCS Data management by default does not load zero balances — 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

FCCS Data management by default does not load zero balances

Received Response
22
Views
5
Comments
edited Jul 24, 2018 3:22PM in Financial Consolidation and Close 5 comments

Summary

FCCS Data management by default does not load zero balances

Content

Hi Guys,

We have experience interesting fact on Data management load, DM default does not load 0 (zero ) balances. It loads when explicitly we provide NZP in Amount expression while defining import format.

If we do not setup NZP we gets below warning in DM log file :

ERROR_INVALID_PERIOD.............. Invalid period specified in the file.

[ZP] - [Amount=0] "Total","0000","Actual","CEIX Primary Ledger","0000000","0000","1040","20272","YTD","211225","0000","Ending Balance","000","USD",0.0
Is this obvious behavior or DM?

Thanks!

Sandeep

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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