Solved

Group Consolidation Issue - ORA-01400: cannot insert NULL into ("IFSAPP"."CONSOL_INTER_COMP_BALANCES_TAB"."ROW_ID")

  • 11 April 2023
  • 1 reply
  • 67 views

Userlevel 3
Badge +9

When Running Group Consolidation , we are getting this Error

 

Note - Please note that we have recently added a new entity under this node, IE10, which could be the reason for this error, but we don't know what the issue is.

This error is happening with all four structures mentioned above. Attached is an example of the error in Opera

 

 

icon

Best answer by hrdilshan 11 April 2023, 15:32

View original

1 reply

Userlevel 3
Badge +9

I found the Solution 

 

1) Check whether Consolidation Structure is in Active (Please refer to the attachment).
2) Roll Back the 'Consolidation Status' from the Consolidation Status window.
3) Then you will notice there is a button to 'update the consolidation structure'. Then update it (since you add a new entity you need to update it)
4) Then run the 'Consolidation Status' again.

 

Resolved

Reply