Transactional Balances Real Time subject area balancing segment code missing data

Summary

Missing certain values in balancing segment code, in the General Ledger - Transactional Balances Real Time OTBI subject area

Content

Hey guys

Wonder if anyone might be able to point me in the right direction as to what's going on here.
The client have created a journal on the EURO ledger, Entity 632 and revalued successfully but this is not showing in the General Ledger – Transactional Balances Real Time subject area in the Balancing Segment Code field for reporting purposes.

If we query on the value sets table we can see the data.

 

I used the cursor cache to see what query the subject area is using, and it is :