About Configuring Projects Costing Burden Cost for PeopleSoft

Actual Costs are extracted from Project Costing for all Analysis Types within the project's Actual Cost Analysis Group.

All costs extracted will be loaded into the Cost Fact Line table as Raw Cost unless you perform one or both of these configurations:

Identifying Project Cost Burden Costs Based on Analysis Type
Identifying Project Cost Burden Costs based on a Source Type, Category, and Subcategory Combination of Values

Identifying Project Cost Burden Costs Based on Analysis Type

The ETL process uses the file_Project_Cost_Burden_Analysis_Type_psft.csv flat file to list all Analysis Types for Project Cost Burden Cost.

To use this identification during the ETL process, you need to set the variable BURDEN_ANALYSIS_TYPE to 1 in FSM

If the ETL process finds the Analysis Type in this flat file, it will not perform further lookups against other lookup tables to determine Project Cost Burden Cost.

FSM parameter BURDEN_ANALYSIS_TYPE is common to both Cost and Budget subject areas to identify Burden Costs.

If the requirements differ between Project Budget and Project Cost in your implementation you can create separate FSM and ODI variables for the same. In the case of creating separate FSM variables for budget and cost facts to identify burden costs, the ETL would need to be modified to use these new variables.

To identify the Project Cost Burden Costs based on Analysis Type:

Edit the file file_Project_Cost_Burden_Analysis_Type_psft.csv.
Note:

The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:
- Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.
- Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.
Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.
Enter the list of Analysis Types to be considered as Burden Costs.
The format is XXX,1, where XXX is an Analysis Type. The 1 is a return value that indicates that this is a Burden Cost.

The following example shows how to classify Costs with BUR and BRD Analysis Types as Burden Costs:
```
BUR,1
BRD,1
```
Save and close the file.

Identifying Project Cost Burden Costs Based on a Source Type, Category, and Subcategory Combination of Values

You must configure the following flat files to identify Project Cost Burden Costs based on a Source Type, Category, and Subcategory combination of values: file_Project_Cost_Burden_TypeCatSub_config_psft.csv. Use this flat file to specify all the columns among (Source Type, Category, and Subcategory) to use in the lookup: file_Project_Cost_Burden_TypeCatSub_psft.csv.

To use this identification during the ETL process, you need to set the variable BURDEN_TYPECATSUB to 1 in FSM.

Based on the columns entered in the previous csv file, use this flat file to list all Source Type, Category, and Subcategory combination of values to use as Project Cost Burden Cost.

Note:

Both Project Budget and Project Cost use these flat files to load data to W_PROJ_LOOKUP_PS table, along with a FSM parameter, to identify Burden Costs.

You can customize these files if the requirements differ between Project Budget and Project Cost in your implementation.

Configuring file_Project_Cost_Burden_TypeCatSub_config_psft.csv file

Configure the file_Project_Cost_Burden_TypeCatSub_config_psft.csv file (Config file).

Edit the file file_Project_Cost_Burden_TypeCatSub_config_psft.csv.
The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:
- Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.
- Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.
Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.
Enter only one row with RowID of 1. Enter a Y in each column that represents the combination to be evaluated as a Project Cost Burden Cost. The columns are:
```
Row ID
Source Type
Category
Subcategory
```
The following is an example of using a combination of Source Type and Category:
```
1,Y,Y
```
(For Source Type and SubCategory combination it would be 1,Y,,Y.)
Save and close the file.

Configuring file_Project_Cost_Burden_TypeCatSub_psft.csv

Configure the file_Project_Cost_Burden_TypeCatSub_psft.csv file (Data file).

Edit the file file_Project_Cost_Burden_TypeCatSub_psft.csv.
Note:

The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:
- Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.
- Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.
Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.
Enter a list of Resource Type, Resource Category, and Resource Subcategory combinations to be considered as Project Cost Burden Costs. The format is:

XXXXX,XXXXX,XXXXX,1

XXXXX represents each combination of Resource Type, Resource Category, and Resource Subcategory.

The 1 is a return value that indicates that this is a Burden Cost. Each combination of lookup values must be specified. Wildcards are not supported.

The following example shows how to classify Costs with G&A or FRNG Source Types as Project Cost Burden Costs:

G&A,,,1

FRNG,,,1

This CSV file is used in conjunction with the file_Project_Cost_Burden_TypeCatSub_config_psft.csv configuration file. In this example, this configuration file would contain the value 1,Y.
Save and close the file.