Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Movement Statistics operating unit set up

edited Mar 22, 2019 1:06PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center