Process Recalculate Cube not loading GL journal facts due to c_calendar_id


Process "Recalculate Cube" does not load GL Journal accounting facts into fact_acct_summary under the following example conditions:

Org A is assigned to Calendar A
Org B is assigned to Calendar B

Cube A (for organization A) is assigned to Calendar A
Cube B (for organization B) is assigned to Calendar B

I record a GL journal with Org=A. The journal and the generated accounting facts are assigned to a c_period_id assigned to its default calendar_id=1000000 instead of Calendar A.
I record a GL journal with Org=B. Same as above: accounting facts are assigned to default calendar_id 1000000 instead of Calendar B.

Because of the difference in calendar_id between cube definition and accounting facts, the GL journal facts are not included in the aggregation in table fact_acct_summary.

A possible solution could be to derive the GL journal organization's Period_ID/Year/Calendar_ID instead of the
default Period_ID/Year/Calendar_ID.




Michael Powacht
April 19, 2019, 6:22 AM

Thanks @Carlos Ruiz ,
I performed some more tests today including a GL Journal with Special Period which gets loaded into the cube as expected. I use the following SQL query for a basic periodic checks for any differences between FACT_ACCT and FACT_ACCT_SUMMARY (Cube):

Michael Powacht
April 29, 2019, 1:40 AM

Hi Carlos, I noticed another problem today:
We use multiple accounting schemes.

  • When I create a new GL Journal header and select an organization, it populates PERIOD correctly and when I change ACCOUNT DATE, it updates PERIOD correctly. However, when I change accounting schema in the Journal header, PERIOD gets removed and there are no periods to be selected. Only after changing ACCOUNT DATE to some other date will PERIOD be re-derived.

  • The other thing that would be nice here is if a callout would update journal header CURRENCY based on Accounting Schema CURRENCY.


Heng Sin Low
May 4, 2019, 2:23 AM

Hi ,

  • Can't reproduce.

  • Please create a new ticket for that.


Michael Powacht
May 4, 2019, 2:31 AM

Thanks Heng Sin, will do.

Michael Powacht
May 4, 2019, 2:38 AM

Hello Heng Sin,
I have created a new JIRA:
To simulate this scenario, I have created a second accounting schema called "2nd schema" in Carlos' demo system so you'll be able to simulate it there.


Heng Sin Low


Michael Powacht



Tested By



Fix versions