Skip to main content
Solved

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

  • April 11, 2023
  • 1 reply
  • 154 views

hrdilshan
Hero (Employee)
Forum|alt.badge.img+10

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

 

 

Best answer by hrdilshan

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

1 reply

hrdilshan
Hero (Employee)
Forum|alt.badge.img+10
  • Author
  • Hero (Employee)
  • Answer
  • April 11, 2023

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