My Oracle Support Banner

Data Collection Scripts and Process Flow for Periodic Average Costing ( PAC IPAC ) - Cost Management (Doc ID 1928724.1)

Last updated on MAY 09, 2019

Applies to:

Oracle Cost Management - Version 11.5.10.2 to 12.2.5 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Cost Management-> Periodic Costing -> Periodic Cost -> Periodic Acquisition Cost Processor (CMCACQ, CMCPAM)
Cost Management-> Periodic Costing -> Periodic Cost -> Periodic Acquisition Cost Adjustment Processor (CSTPACAP)
Cost Management-> Periodic Costing -> Reports -> Periodic Absorption Cost Processor (CST_INTERORG_TRANSFER)

---

Phase 1-4 (all cost groups)
Phase 1: Periodic Acquisition Cost Process
Phase 2: Copy Prior Period Balance
Phase 3: BOM Explosion
Phase 4: WIP Processor
Phase 7: Absorption Cost Process (all cost groups)
Phase 5: Periodic Cost Processor
Phase 6: Periodic Distribution Processor
Cost Management-> Periodic Costing -> Periodic Cost -> Periodic Cost Processor (CMCPAW)
Cost Management-> Periodic Costing -> Periodic Cost -> Periodic Cost Distribution Processor (CSTPDPPC)


**** Checked on Relevance on 04-FEB-2019 ****

Goal

PAC

Periodic Average Costing is an option that enables customers to value inventory on a periodic basis.
Periodic Costing is relevant for customers with fiscal inventory reporting requirement as it is invoice-based and allows you to include additional invoiced charges in the cost of the item.  
Periodic Costing is also used by customers who want invoice-price based valuation of their inventory to set standards or to update their perpetual costs.
An approach to inventory valuation in which variable costs and a portion of fixed costs are assigned to each unit of production. (APICS Dictionary, 2003

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. Common Resolution for PAC/IPAC Issues
 2. PAC/IPAC Process/Setup
 3. Identify whether customer is working with Localizations or not
 3.1 Confirm via SQL Script:
 3.2 Via Application:
 3.3 Via Log File:
 3.4 Via Database Objects:
 4. Review the latest Patches released for PAC/IPAC
 4.1 Release 11.5.10.2 (Minimum Patch Set)
 4.2 Release 12.0.X: None
 4.3 Release 12.1.X (Descending creation date):
 4.4 Release 12.2.X: None
 4.5 For issues with IPAC:
 5. Resolving PAC/IPAC Performance Issues
 5.1 Proceed Running Gather Schema Statistics
 5.2 Review the following Document
 6. Identify File Name and File Version for PAC/IPAC Processes
 7. Is the Issue still happening? then proceed with the following Actions
 7.1 For issues related to PAC/IPAC Processes
 7.2 For issues related to PAC/IPAC Performance Issues
 7.3 For issues related to Errors at PAC/IPAC Log Files
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.