Wednesday, April 15, 2015

How to Improve Data Quality

Here's some best practice to improve data quality in your Oracle EBS:


  1. Master data especially item should be managed by a dedicated team. keep the team size small and each item category is managed by a single person only.
  2. Use catalog and personalize purchase order form to prevent users from miss typing currency. While it seems simple, enter the wrong currency may ruin your item cost.
  3. Value your data input operator. They are the role player here. If they did it wrong, it'll carry forward till GL, the company financial report may suffer as the result. Punishment and reward schema may apply. 
  4. Keep an eye on Cost Manager and cost workers. If cost workers are idle for sometime then it may indicate there are some rows with error flag in material transactions table. 
  5. Make sure the inventory data FLOWS.
  6. Build your team to manage Oracle EBS and database. DBA must keep an eye on table space and log issue. The number of pending concurrent in concurrent manager is also something to monitor tightly, if it is high then a quick action must be taken.

so far that's all I can tell right now.

No comments:

Post a Comment