Process Recalculate Cube not loading GL journal facts due to c_calendar_id

Description

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.

Environment

None

Status

Assignee

Heng Sin Low

Reporter

Michael Powacht

Labels

None

Tested By

None

Components

Fix versions

Priority

Minor
Configure