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

Clear TO DATE of Account Combination using FBDI - Error ORA-01841

Summary:

Hello, I am attempting to use FBDI to clear the value out of the TO DATE field (return it to default, empty, blank or null). If I leave it blank, it skips over the field. If I enter #NULL, then when I run Import Account Combinations, it gives me error "ORA-01841: (full) year must be between -4713 and +9999, and not be 0".

If I manually go into Manage Account Combinations, I am able to select the field and clear it manually by pressing backspace or delete. However, I need to be able to change 2000+ combinations, so updating it manually is not really feasible. How can I use FBDI to update this field?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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