Movement Statistics operating unit set up
Hi, we are on Oracle 12.1.3, and I have a question regarding set up of a new operating unit in relation to Movement Statistics.
For the Movement Statistics Processor to pull sales orders/deliveries, the table HR_ORGANIZATION_INFORMATION needs to be populated for the appropriate operating unit.
We have created a new operating unit and have made sales that should be appearing for that op unit when running the Movement Statistics Processor job, but the sales are not being selected because it seems to be failing on the links to HR_ORGANIZATION_INFORMATION and in particular the line "AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id)" from the below sql.