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?
Tagged:
0