The data in PROJ_RESOURCE grows tremendously overtime. Due to this, the project costing processes may take longer time to complete. In order to improve the overall performance of the Project Costing processes, this optional summarization feature is introduced in 9.2 to summarize the feeder/pricing transactions before loaded to PROJ_RESOURCE. This will reduce the number of rows in PROJ_RESOURCE. The detailed transactions rows are stored in separate tables.
This feature allows users to define different levels of Summarization Templates for transactions coming from different sources. Users can always drill down to the detail transactions that make up the summarized rows in Transaction List page. From the details rows, the users can then drill down to the source feeder system
Available Sources for Summarization:
Currently, summarization can be enabled for : Expenses , General Ledger , Third Party Loader , Pricing Engine, Variance Pricing, Time and Labor, Payables / Purchasing.
Use case of Summarization Feature for General Ledger Transactions:
How to Configure Feeder and Pricing Summarization feature for General Ledger Transactions? (Doc ID 1929655.1)
The Feature is introduced in 9.2.
For 9.1 release, enhancements were delivered in phases. • 9.1 FMS/ESA bundle 2 (initial update). • 9.1 FMS/ESA bundle 9 (Pricing, time and labor summarization). • 9.1 FMS/ESA bundle 26 (payables and purchasing summarization)