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