The Oracle EAM is based on WIP and Inventory modules, So Period Closing is used on
EAM organizations.
EAM Work Orders can be purged by using "Purge Discrete Jobs" feature. But this program will purge only WOs which are closed in already closed periods. (there are some validations which are not allowing purging of active work orders or WOs which are not in closed periods) Also you will have to run Inventory Transactions Purge program before being able to run WIP Purge.
There is no special program to purge only EAM Work Orders nor EAM Work Requests. Also it is not recommended to delete them from header tables (like wip_entities, wip_discrete_jobs or wip_eam_work_requests) as the records are related with records from detail or transaction tables by foreign keys.
In EAM, closing a period or closing an EAM Work Order act in same way: the costs incurred until that time are relieved by variance accounts. In either way, the costs can be pushed to GL. After that, as the WOs and related WRs are not necessary in the system, they could be deleted but at that time, all the material transactions and the resource transactions (and other transactions like capitalization or billing) will remain orphan and they could result in mismatch in reports and errors on user interfaces.
So purging this info from the system is not an easy task and also not recommended by Oracle
(version 11.5.10)
EAM Work Orders can be purged by using "Purge Discrete Jobs" feature. But this program will purge only WOs which are closed in already closed periods. (there are some validations which are not allowing purging of active work orders or WOs which are not in closed periods) Also you will have to run Inventory Transactions Purge program before being able to run WIP Purge.
There is no special program to purge only EAM Work Orders nor EAM Work Requests. Also it is not recommended to delete them from header tables (like wip_entities, wip_discrete_jobs or wip_eam_work_requests) as the records are related with records from detail or transaction tables by foreign keys.
In EAM, closing a period or closing an EAM Work Order act in same way: the costs incurred until that time are relieved by variance accounts. In either way, the costs can be pushed to GL. After that, as the WOs and related WRs are not necessary in the system, they could be deleted but at that time, all the material transactions and the resource transactions (and other transactions like capitalization or billing) will remain orphan and they could result in mismatch in reports and errors on user interfaces.
So purging this info from the system is not an easy task and also not recommended by Oracle
(version 11.5.10)
The information you convey really interesting and I think very useful. Thanks
ReplyDeleteOrder Management System