Subject Areas

8 Subject Areas

Subject Areas

Overview

This section details subject area information for Enterprise Resource Planning data using Oracle Fusion ERP Analytics.

Download this ZIP file that contains available subject area information that applies to the current version of Oracle Fusion ERP Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 24R2_Fusion_ERP_Analytics_SubjectAreas.html.

These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:

Description of the subject area.
Business questions that can be answered by data in the subject area, with a link to more detailed information about each business question.
Job-specific groups and duty roles that can be used to secure access to the subject area, with a link to more detailed information about each job role and duty role.
Primary navigation to the work area that is represented by the subject area.
Time reporting considerations in using the subject area, such as whether the subject area reports historical data or only the current data. Historical reporting refers to reporting on historical transactional data in a subject area. With a few exceptions, all dimensional data are current as of the primary transaction dates or system date.
The lowest grain of transactional data in a subject area. The lowest transactional data grain determines how data are joined in a report.
Special considerations, tips, and things to look out for in using the subject area to create analyses and reports.

Note:

Job roles are the same as job-specific groups.

Offerings and Functional Areas

This table shows the offerings in Oracle Fusion ERP Analytics.

Functional Area Name	Dependency	Associated Subject Areas	Initial Release
Accounts Payable	NA	Financials - AP Aging, Financials - AP Expense, Financials - AP Holds, Financials - AP Invoices, Financials - AP Liabilities, Financials - AP Payments	19.R3
Accounts Receivable	NA	Financials - AR Aging, Financials - AR Credit Memo Applications, Financials - AR Receipts and Applications, Financials - AR Revenue, Financials - AR Transactions	19.R3
AR Unaccounted Transactions	NA	Financials - AR Revenue, Financials - AR Transactions	22.R2
Assets	NA	Financials - Assets Analysis, Financials - Assets Transactions	21.R2
Customer Collections Date Prediction	Accounts Receivable, Customer Collections Risk Prediction	Financials - AR Aging, Financials - AR Transactions	20.R1
Customer Collections Risk Prediction	Accounts Receivable	Financials - AR Aging, Financials - AR Transactions	20.R1
Employee Expense	NA	Financials - EXM Employee Expenses	20.R4
ERP Primary UOM Conversion (Preview)	NA	All Procurement Subject Areas	21.R3
ERP Procurement Contracts (Preview)	NA	Enterprise Contracts - Contracts (Preview)	23.R4
ERP Receipt Accounting (Preview)	NA	Procurement - Receipt Accounting (Preview), Procurement - Accrual Balances at Period End (Preview), Procurement - Accrual Balances at Receipt (Preview)	24.R2
General Ledger	NA	Financials - GL Balance Sheet, Financials - GL Detail Transactions, Financials - GL Profitability	19.R3
GL Budgets Analysis	General Ledger	Financials - GL Budgets	21.R1
Grant Management (Preview)	NA	PPM - Grants Award Funding (Preview)	23.R1
Payable Aging	Accounts Payable	Financials - AP Aging	24.R2
Procurement Spend	NA	Procurement - Spend	20.R4
Project Asset (Preview)	Project Costing	PPM - Project Assets (Preview)	22.R1
Project Billing	NA	PPM - Project Funding, PPM - Project Invoices, PPM - Project Revenue	22.R1
Project Commitment	NA	PPM - Project Commitments	21.R2
Project Control	NA	PPM - Project Budgets, PPM - Project Forecasts	22.R1
Project Costing	NA	PPM - Project Costs	21.R2
Project Invoices Prior to Acceptance	Project Billing	PPM - Project Invoices	22.R4
Project Labor Distribution (Preview)	NA	PPM – Project Labor Distribution Costs (Preview), PPM - Project Labor Schedules (Preview)	24.R2
Purchasing	NA	Procurement - Agreements, Procurement - Purchase Orders, Procurement - Receipts, Procurement - Requisitions	21.R4
Receivable Aging	Accounts Receivable	Financials - AR Aging	21.R4
Spend Classification (Preview)	Purchasing, Procurement Spend	Procurement - Purchase Orders, Procurement - Requisitions, Procurement - Spend	23.R2
Supplier On-time Payments Prediction	Accounts Payable	Financials - AP Aging, Financials - AP Invoices, Financials - AP Payments	20.R1

Data Validation

Description

As a functional administrator, you can validate a library of metrics between your Oracle Fusion Data Intelligence instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Fusion Data Intelligence. You can validate the data after loading the source data in to your data warehouse. You can schedule the validation of your data using the prebuilt validation sets or custom validation sets that you create. You can create a validation set and define the subject area, metrics, and columns that you want to validate and schedule the validation frequency and date. You see the validation sets that you create under Custom Validation Sets in the Scheduled Validation tab. Based on the schedule and the validation set, Oracle Fusion Data Intelligence validates the data and stores the details in the Data Validation workbook available in the Common folder in Oracle Analytics Cloud. Use the report tabs such as Validate data for ERP Analytics and Validate data for HCM Analytics available in this workbook to view the data validation details.

Business Questions

This subject area can answer the following business questions:

Did my data get loaded into Oracle Autonomous Data Warehouse accurately?
Can I schedule a regular data validation on a periodic basis?
If there is a variance between my Oracle Transactional Business Intelligence source and Oracle Fusion Data Intelligence destination data, then how can I pinpoint which data is different?
Are there built-in metrics for this data validation?
Can I create my own (custom) metrics for specific data to validate?

Duty Roles

The System Administration duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Data Validation tile under Application Administration on the Console

Folder: /Shared Folders/Common/Data Validation

Special Considerations

None.

Security Assignment

Description

Using the Security Assignment subject area, you can create reports about the current security assignments. These reports enable you to track the security contexts and the users who have access to the security contexts.

Business Questions

This subject area can answer the following business questions:

What is the total number of security contexts?
What is the number of users by security context?
Which user is assigned to which security context and when was the assignment done?

Duty Roles

The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Security Assignment

Workbook: Security Audit

Special Considerations

None.

Security Audit History

This section is applicable for CX Subscription Management Analytics only.

Description

Using the data in the Security Audit History subject area, you can create reports to track assignment of users to groups, groups to roles, and security context members to users.

Business Questions

This subject area can answer the following business questions:

When was a group created?
When was a role created?
When was a user assigned to or removed from a group?
When was a user assigned to or removed from a role?
When was a user assigned to or removed from a security context?

Duty Roles

The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Security Audit History

Workbook: Security Audit

Special Considerations

None.

Special Considerations for Comparing Invoices between Oracle Fusion Data Intelligence and Oracle Transactional Business Intelligence

Invoices without invoice schedules or installments defined aren't loaded into Oracle Fusion Data Intelligence.

Invoices may be incomplete due to the invoice schedules or installment not being defined.

Use the Oracle Transactional Business Intelligence Payables Installment subject area to compare data with the Oracle Fusion Data Intelligence AP Invoices subject area. Oracle Fusion Data Intelligence doesn't load the closed invoices before the initial extract date, for example 2012/01/01 00:00:00. Some transactions created since the last data load may be missing in Oracle Fusion Data Intelligence as well. Be sure to complete the incremental data refresh before validating such transactions.

Use the Data Validation feature for the Total Transaction Amount metric from the Oracle Fusion Data Intelligence AP Invoices subject area. If there are any differences between Oracle Fusion Data Intelligence and Oracle Transactional Business Intelligence, check for possible mismatches by selecting the columns such as Invoice Number or Validation Status.

Usage Tracking

Description

Usage Tracking is a powerful feature that has been available in Oracle Analytics Cloud. In Oracle Fusion Data Intelligence you can track usage to determine which user queries are creating performance bottlenecks, based on query frequency and response time. Administrators set up the criteria to track user queries and generate usage reports that you can use in a variety of ways such as reports optimization, user session strategies, or plan usage by users, and departments based on the resources that they consume. When reviewing the business metrics, it is important to keep the usability considerations in mind including trends, slice-and-dice, and drilldowns. Where applicable, benchmark information showcasing performance with the peer group is available. Companies typically set strategic quarterly goals in terms of key metrics; where applicable, the business metrics show progress towards such goals.

This subject area includes details of logical queries that provide insights on the types of queries generated and their performance. Along with it, the Common - Usage Tracking - Physical Query subject area provides details of physical queries sent to the database. These details can help you understand query execution plans in Autonomous Data Warehouse to identify areas of improvement in report creation. Both subject areas have the Logical query folder with a common set of attributes, that you can use to join a logical or semantic query to its physical database queries. Together, they provide valuable insights to track performance of the Oracle Analytics platform and help you design reports and visualizations that can perform optimally.

Business Questions

This subject area can answer the following business questions:

What are the average queries ran by the user by month?
How many number of user sessions were created per month?
How many distinct queries were run per month?
How many distinct users used the system?
How many distinct users used the system in a week?
What are the average queries ran by the user in a week?
How many logical queries ran by the top users?
What are the top 10 logical and physical queries by execution time?
Which dashboards and visualizations are the slowest performing?

Duty Roles

The Usage Tracking Analysis Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Usage Tracking

Workbook: Usage Tracking

Special Considerations

None.

Warehouse Refresh Statistics

Description

The Warehouse Refresh Statistics subject area provides valuable information on pipeline activity and performance. You can use this subject area to create analytics on data refreshes, pipeline jobs, job failures, and details on rejected records. Together with data validation, this subject area helps reconcile data between the Oracle Fusion Cloud Applications source module and Oracle Fusion Data Intelligence, and improve data quality over time.

Business Questions

This subject area can answer the following business questions:

When was the warehouse last refreshed, by each module?
Which modules have high percentage of rejected records?
What are the specific records that have been rejected for a certain module?
What errors did the pipeline encounter, by specific jobs?
Which jobs fail most frequently?
What are the cascading effects, for example what other related records also fail due to a certain failure of a job?

Duty Roles

The Data Warehouse Refresh Analysis Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Warehouse Refresh Statistics

Workbook: Warehouse Refresh Statistics

Special Considerations

None.

Business Questions

Overview

For each business question in this section, click the links for more detailed information about the subject areas, job-specific groups, and duty roles associated with the business question.

Download this ZIP file that contains available business questions that apply to the current version of Oracle Fusion ERP Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 24R2_Fusion_ERP_Analytics_BusinessQuestions.html.

Note:

Job roles are the same as job-specific groups.

Job-Specific Groups

Overview

This section provides job-specific groups that can be used to secure access to the subject area and analyses.

Note:

Job roles are the same as job-specific groups.

Job-Specific Group Code	Job-Specific Group Name	Description	Associated Application Roles	Functional Area
ORA_AP_ACCOUNTS_PAYABLE_INVOICE_SUPERVISOR_JOB	Account Payable Invoice Supervisor	Account Payable Invoice Supervisor Job Group	OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY OA4F_FIN_AP_AGING_ANALYSIS_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_AGING_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_CONTENT_DUTY	AP
ORA_AP_ACCOUNTS_PAYABLE_MANAGER_JOB	Accounts Payable Manager	Accounts Payable Manager Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY OA4F_FIN_AP_AGING_ANALYSIS_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_AGING_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_CONTENT_DUTY	Procurement, AP
ORA_AP_ACCOUNTS_PAYABLE_PAYMENT_SUPERVISOR_JOB	Account Payable Payment Supervisor	Account Payable Payment Supervisor Job Group	OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY OA4F_FIN_AP_AGING_ANALYSIS_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_AGING_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_CONTENT_DUTY	AP
ORA_AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB	Accounts Payable Specialist	Accounts Payable Specialist Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY OA4F_FIN_AP_AGING_ANALYSIS_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_AGING_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_CONTENT_DUTY	Procurement, AP
ORA_AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB	Accounts Payable Supervisor	Accounts Payable Supervisor Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY OA4F_FIN_AP_AGING_ANALYSIS_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_INVOICES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_PAYMENTS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_LIABILITIES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_AGING_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_EXPENSES_ANALYSIS_CONTENT_DUTY OA4F_FIN_AP_HOLDS_ANALYSIS_CONTENT_DUTY	Procurement, AP
ORA_AR_ACCOUNTS_RECEIVABLE_MANAGER_JOB	Accounts Receivable Manager	Accounts Receivable Manager Job Group	OA4F_FIN_AR_BUSINESS_UNIT_DATA OA4F_FIN_AR_RECEIPT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AR_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_DUTY OA4F_FIN_AR_AGING_ANALYSIS_DUTY OA4F_FIN_AR_CREDITMEMO_ANALYSIS_DUTY OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_DUTY OA4F_FIN_AR_APPLICATIONS_ANALYSIS_DUTY OA4F_FIN_AR_REVENUE_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_AGING_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_CREDITMEMO_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_APPLICATIONS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_REVENUE_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY	AR
ORA_AR_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB	Accounts Receivable Specialist	Accounts Receivable Specialist Job Group	OA4F_FIN_AR_BUSINESS_UNIT_DATA OA4F_FIN_AR_RECEIPT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AR_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_DUTY OA4F_FIN_AR_AGING_ANALYSIS_DUTY OA4F_FIN_AR_CREDITMEMO_ANALYSIS_DUTY OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_DUTY OA4F_FIN_AR_APPLICATIONS_ANALYSIS_DUTY OA4F_FIN_AR_REVENUE_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_AGING_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_CREDITMEMO_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_APPLICATIONS_ANALYSIS_CONTENT_DUTY OA4F_FIN_AR_REVENUE_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY	AR
ORA_CMR_RECEIPT_ACCOUNTING_DISCRETIONARY	Receipt Accounting	Receipt Accounting Job Group	OA4F_SCM_CMR_BUSINESS_UNIT_DATA OA4F_CMR_RECEIPT_ACCOUNTING_DUTY	ERP - Receipt Accounting
ORA_EXM_EXPENSE_MANAGER_JOB	Expense Manager	Expense Manager Job Group	OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_EXM_EMPLOYEE_EXPENSE_ANALYSIS_DUTY OA4F_FIN_EXM_EMPLOYEE_EXPENSE_ANALYSIS_CONTENT_DUTY	EXM
ORA_FA_ASSET_ACCOUNTANT_JOB	Asset Accountant	Asset Accountant Job Group	OA4F_FIN_FA_ASSET_BOOK_DATA OA4F_FIN_FA_ASSETS_ANALYSIS_DUTY OA4F_FIN_FA_ASSETS_TRANSACTIONS_DUTY OA4F_FIN_FA_ASSETS_ANALYSIS_CONTENT_DUTY OA4F_FIN_FA_ASSETS_TRANSACTIONS_CONTENT_DUTY	FA
ORA_FA_ASSET_ACCOUNTING_MANAGE_JOB	Asset Accounting Manager	Asset Accounting Manager Job Group	OA4F_FIN_FA_ASSET_BOOK_DATA OA4F_FIN_FA_ASSETS_ANALYSIS_DUTY OA4F_FIN_FA_ASSETS_TRANSACTIONS_DUTY OA4F_FIN_FA_ASSETS_ANALYSIS_CONTENT_DUTY OA4F_FIN_FA_ASSETS_TRANSACTIONS_CONTENT_DUTY	PJC, PJB
ORA_GL_FINANCIAL_ANALYST_JOB	Financial Analyst	Financial Analyst Job Group	OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_AR_BUSINESS_UNIT_DATA OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_AR_RECEIPT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_AR_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_PROFITABILITY_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_BUDGETS_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY	GL
ORA_GL_GENERAL_ACCOUNTANT_JOB	General Accountant	General Accountant Job Group	OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_AR_BUSINESS_UNIT_DATA OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_AR_RECEIPT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_AR_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_PROFITABILITY_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_BUDGETS_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY	GL
ORA_GL_GENERAL_ACCOUNTING_MANAGER_JOB	General Accounting Manager	General Accounting Manager Job Group	OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_FIN_AR_BUSINESS_UNIT_DATA OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA OA4F_FIN_AR_RECEIPT_BUSINESS_UNIT_DATA OA4F_FIN_RECON_OTHER_JOURNALS_DATA OA4F_FIN_RECON_AP_APPS_DATA OA4F_FIN_RECON_AR_APPS_DATA OA4F_FIN_RECON_GL_APPS_DATA OA4F_FIN_GL_ACCESS_SET_DATA OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_PROFITABILITY_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_BUDGETS_ANALYSIS_CONTENT_DUTY OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY	GL
ORA_INV_WAREHOUSE_MANAGER_JOB	Warehouse Manager	Warehouse Manager Job Group	OA4F_PROC_INV_ORG_DATA OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY	Procurement
ORA_OKC_ENTERPRISE_CONTRACT_ADMINISTRATOR_JOB	Enterprise Contract Administrator	Enterprise Contract Administrator Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_ENTERPRISE_CONTRACT_MANAGER_JOB	Enterprise Contract Manager	Enterprise Contract Manager Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_ENTERPRISE_CONTRACT_TEAM_MEMBER_ABSTRACT	Enterprise Contract Team Member (Abstract Role)	Enterprise Contract Team Member (Abstract Role) Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_SUPPLIER_CONTRACT_ADMINISTRATOR_JOB	Supplier Contract Administrator	Supplier Contract Administrator Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_SUPPLIER_CONTRACT_MANAGER_JOB	Supplier Contract Manager	Supplier Contract Manager Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_SUPPLIER_CONTRACT_TEAM_MEMBER_ABSTRACT	Supplier Contract Team Member (Abstract Role)	Supplier Contract Team Member (Abstract Role) Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_PJF_GRANTS_ACCOUNTANT_JOB	Grants Accountant	Grants Accountant Job Group	OA4F_PPM_EXPENDITURE_BUSINESS_UNIT_DATA OA4F_PPM_PROJECTS_CONTRACTS_BUSINESS_UNIT_DATA OA4F_PPM_GRANTS_COSTING_DUTY OA4F_PPM_GRANTS_REVENUE_DUTY	PJC, PJB
ORA_PJF_GRANTS_ADMINISTRATOR_JOB	Grants Administrator	Grants Administrator Job Group	OA4F_PPM_PROJECTS_CONTRACTS_BUSINESS_UNIT_DATA OA4F_PPM_PROJECT_BUSINESS_UNIT_DATA OA4F_PPM_GRANTS_COSTING_DUTY OA4F_PPM_GRANTS_BUDGETS_DUTY OA4F_PPM_GRANTS_REVENUE_DUTY OA4F_PPM_GRANTS_INVOICE_DUTY OA4F_PPM_GRANTS_AWARD_FUNDING_DUTY	PJC, PJB, PJO, GMS
ORA_PJF_LABOR_DISTRIBUTION_ACCOUNTANT_DISCRETIONARY	Labor Distribution Accountant	Has Author privileges	OA4F_PPM_LABOR_DISTRIBUTIONS_COST_DUTY	PJC
ORA_PJF_LABOR_DISTRIBUTION_ADMINISTRATOR_DISCRETIONARY	Labor Distribution Administrator	Has Author privileges	OA4F_PPM_LABOR_SCHEDULES_DUTY	PJC
ORA_PJF_PRINCIPAL_INVESTIGATOR_JOB	Principal Investigator	Principal Investigator Job Group	OA4F_PPM_PRINCIPAL_INVESTIGATOR_DATA OA4F_PPM_GRANTS_COSTING_DUTY OA4F_PPM_GRANTS_BUDGETS_DUTY OA4F_PPM_GRANTS_AWARD_FUNDING_DUTY	PJC, PJO, GMS
ORA_PJF_PROJECT_ACCOUNTANT_JOB	Project Accountant	Project Accountant Job Group	OA4F_PPM_EXPENDITURE_BUSINESS_UNIT_DATA OA4F_PPM_PROJECTS_CONTRACTS_BUSINESS_UNIT_DATA OA4F_PPM_PROJECTS_COSTS_DUTY OA4F_PPM_PROJECTS_COMMITMENTS_DUTY OA4F_PPM_PROJECTS_REVENUE_DUTY OA4F_PPM_PROJECTS_ASSETS_DUTY OA4F_PPM_PROJECTS_COSTS_CONTENT_DUTY OA4F_PPM_PROJECTS_COMMITMENTS_CONTENT_DUTY OA4F_PPM_PROJECTS_REVENUE_CONTENT_DUTY	PJC, PJB
ORA_PJF_PROJECT_ADMINISTRATOR_JOB	Project Administrator	Project Administrator Job Group	OA4F_PPM_PROJECT_BUSINESS_UNIT_DATA OA4F_PPM_PROJECT_ORGANIZATION_DATA OA4F_PPM_PROJECTS_COSTS_DUTY OA4F_PPM_PROJECTS_COMMITMENTS_DUTY OA4F_PPM_PROJECTS_BUDGETS_DUTY OA4F_PPM_PROJECTS_FORECASTS_DUTY OA4F_PPM_PROJECTS_FUNDING_DUTY OA4F_PPM_PROJECTS_REVENUE_DUTY OA4F_PPM_PROJECTS_INVOICE_DUTY OA4F_PPM_PROJECTS_COSTS_CONTENT_DUTY OA4F_PPM_PROJECTS_COMMITMENTS_CONTENT_DUTY OA4F_PPM_PROJECTS_BUDGETS_CONTENT_DUTY OA4F_PPM_PROJECTS_FORECASTS_CONTENT_DUTY OA4F_PPM_PROJECTS_FUNDING_CONTENT_DUTY OA4F_PPM_PROJECTS_REVENUE_CONTENT_DUTY OA4F_PPM_PROJECTS_INVOICE_CONTENT_DUTY	PJC, PJO, PJB
ORA_PJF_PROJECT_BILLING_SPECIALIST_JOB	Project Billing Specialist	Project Billing Specialist Job Group	OA4F_PPM_PROJECTS_CONTRACTS_BUSINESS_UNIT_DATA OA4F_PPM_PROJECTS_FUNDING_DUTY OA4F_PPM_PROJECTS_INVOICE_DUTY OA4F_PPM_PROJECTS_FUNDING_CONTENT_DUTY OA4F_PPM_PROJECTS_INVOICE_CONTENT_DUTY	PJB
ORA_PJF_PROJECT_MANAGER_JOB	Project Manager	Project Manager Job Group	OA4F_PPM_PROJECT_MANAGER_DATA OA4F_PPM_PROJECTS_COSTS_DUTY OA4F_PPM_PROJECTS_COMMITMENTS_DUTY OA4F_PPM_PROJECTS_BUDGETS_DUTY OA4F_PPM_PROJECTS_FORECASTS_DUTY OA4F_PPM_PROJECTS_FUNDING_DUTY OA4F_PPM_PROJECTS_REVENUE_DUTY OA4F_PPM_PROJECTS_INVOICE_DUTY OA4F_PPM_PROJECTS_ASSETS_DUTY OA4F_PPM_PROJECTS_COSTS_CONTENT_DUTY OA4F_PPM_PROJECTS_COMMITMENTS_CONTENT_DUTY OA4F_PPM_PROJECTS_BUDGETS_CONTENT_DUTY OA4F_PPM_PROJECTS_FORECASTS_CONTENT_DUTY OA4F_PPM_PROJECTS_FUNDING_CONTENT_DUTY OA4F_PPM_PROJECTS_REVENUE_CONTENT_DUTY OA4F_PPM_PROJECTS_INVOICE_CONTENT_DUTY	PJC, PJO, PJB
ORA_PO_BUYER_JOB	Buyer	Buyer Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement
ORA_PO_PROCUREMENT_CONTRACT_ADMIN_JOB	Procurement Contract Administrator	Procurement Contract Administrator Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement
ORA_PO_PROCUREMENT_MANAGER_JOB	Procurement Manager	Procurement Manager Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement
ORA_PO_PURCHASE_ANALYSIS_ABSTRACT	Purchase Analysis	Purchase Analysis Job Group	OA4F_PROC_REQ_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement
ORA_PON_CATEGORY_MANAGER_JOB	Category Manager	Category Manager Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY NEXUS_BASE_OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Procurement

Common Job-Specific Groups

The common job-specific groups are applicable across the analytics applications that are part of Oracle Fusion Data Intelligence such as Oracle Fusion HCM Analytics and Oracle Fusion ERP Analytics.

Job-Specific Group Code	Job-Specific Group Name	Description	Associated Application Roles	Associated Application Role Names	Functional Area
ORA_FND_INTEGRATION_SPECIALIST_JOB	Integration Specialist	Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges.	Author OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY	Not applicable	Common

Job-Specific Group Code

Job-Specific Group Name

Description

Associated Application Roles

Associated Application Role Names

Functional Area

ORA_FND_INTEGRATION_SPECIALIST_JOB

Integration Specialist

Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges.

Author

OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY

Not applicable

Common

Data Roles

Overview

This section provides data roles that can be used to secure access to the subject area.

Data Role Code	Data Role Name	Description	Functional Area
OA4F_FIN_AP_BUSINESS_UNIT_DATA	Accounts Payable Business Unit Data Security	Allows access to the accounts payable business unit based data.	AP, EXM, Procurement
OA4F_FIN_AP_PAYMENT_BUSINESS_UNIT_DATA	Accounts Payable Payment Business Unit Data Security	Allows access to Accounts Payable Payment business unit based data.	AP
OA4F_FIN_AR_BUSINESS_UNIT_DATA	Accounts Receivable Business Unit Data Security	Allows access to Accounts Receivable business unit based data.	AR
OA4F_FIN_AR_RECEIPT_BUSINESS_UNIT_DATA	Accounts Receivable Receipt Business Unit Data Security	Allows access to Accounts Receivable Receipt business unit based data.	AR
OA4F_FIN_FA_ASSET_BOOK_DATA	Fixed Asset Book Data Security	Allows access to the fixed asset book based data.	FA
OA4F_FIN_GL_ACCESS_SET_DATA	General Ledger Access Set Data Security	Allows access to ledger set based data.	GL
OA4F_FIN_RECON_AP_APPS_DATA	Account Reconciliation Accounts Payable Application Data Security	Allows access to Account Reconciliation Accounts Payable application based data.	GL
OA4F_FIN_RECON_AR_APPS_DATA	Account Reconciliation Accounts Receivable Application Data Security	Allows access to Account Reconciliation Accounts Receivable application based data.	GL
OA4F_FIN_RECON_GL_APPS_DATA	Account Reconciliation General Ledger Application Data Security	Allows access to Account Reconciliation General Ledger application based data.	GL
OA4F_FIN_RECON_OTHER_JOURNALS_DATA	Account Reconciliation Other Journals Data Security	Allows access to Account Reconciliation Other Journals data.	GL
OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA	Contract Business Unit Data Security	Data security role to access contracts business unit-based data.	Enterprise Contracts
OA4F_PPM_EXPENDITURE_BUSINESS_UNIT_DATA	Project Expenditure Business Unit Data Security	Allows access to the PPM Project Expenditure business unit based data.	PJC
OA4F_PPM_PRINCIPAL_INVESTIGATOR_DATA	Principal Investigator Data Security	Allows access based on the Awards that the Pricipal Investigator is assigned to.	GMS
OA4F_PPM_PROJECT_BUSINESS_UNIT_DATA	Project Business Unit Data Security	Allows access to the PPM Project business unit based data.	PJC
OA4F_PPM_PROJECT_MANAGER_DATA	Project Manager Data Security	Allows access based on the Projects that the Project Manager is assigned to.	PJC
OA4F_PPM_PROJECT_ORGANIZATION_DATA	Project Organization Data Security	Allows access to the PPM Project Organization hierarchy based data.	PJC
OA4F_PPM_PROJECTS_CONTRACTS_BUSINESS_UNIT_DATA	Contract Business Unit Data Security	Allows access to the Projects Contract business unit based data.	PJB
OA4F_PROC_BUSINESS_UNIT_DATA	Procurement Business Unit Data Security	Allows access to the procurement business unit based data.	Procurement
OA4F_PROC_INV_ORG_DATA	Procurement Inventory Organization Data Security	Allows access to the Receipts subject area based on the receiving organization.	Procurement
OA4F_PROC_REQ_BUSINESS_UNIT_DATA	Procurement Requisition Business Unit Data Security	Allows access to the procurement Requisition business unit based data.	Procurement
OA4F_SCM_CMR_BUSINESS_UNIT_DATA	Profit Center Business Unit Data Security for Receipt Accounting Business Function	Data security role to access Receipt Accounting business unit-based data.	Receipt Accounting

Duty Roles

Overview

This section provides subject area and content-related duty roles that you can use to secure access to the subject areas and specific content. For each duty role in this section, links are provided for detailed information about the job-specific groups, subject areas, and business questions associated with the duty role.

Duty Role Code	Duty Role Name	Duty Role Description	Functional Area	Gets access to Subject Area Display Name OR Associated Role
NEXUS_BASE_OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Nexus Base Procurement Spend Analysis Content Duty	Nexus Base Controls presentation catalog access to DV projects built against the Procurement - Spend subject area	Procurement	Procurement - Spend
OA4F_CMR_RECEIPT_ACCOUNTING_DUTY	Receipt Accounting Duty	Controls presentation catalog access to Receipt Accounting subject area.	ERP - Receipt Accounting	Procurement - Receipt Accounting (Preview), Procurement - Accrual Balances at Period End (Preview), Procurement - Accrual Balances at Period End (Preview)
OA4F_FIN_AP_AGING_ANALYSIS_CONTENT_DUTY	Accounts Payable Aging Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AP Aging subject area.	AP	Financials - AP Aging
OA4F_FIN_AP_AGING_ANALYSIS_DUTY	Accounts Payable Aging Analysis Duty	Controls presentation catalog access to Financials Accounts Payable Aging subject area.	AP	Financials - AP Aging
OA4F_FIN_AP_EXPENSES_ANALYSIS_CONTENT_DUTY	Accounts Payable Expenses Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AP Expenses subject area.	AP	Financials - AP Expenses
OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY	Accounts Payable Expenses Analysis Duty	Controls presentation catalog access to Financials Accounts Payable Expenses subject area.	AP	Financials - AP Expenses
OA4F_FIN_AP_HOLDS_ANALYSIS_CONTENT_DUTY	Accounts Payable Holds Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AP Holds subject area.	AP	Financials - AP Holds
OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY	Accounts Payable Holds Analysis Duty	Controls presentation catalog access to Financials Accounts Payable Holds subject area.	AP	Financials - AP Holds
OA4F_FIN_AP_INVOICES_ANALYSIS_CONTENT_DUTY	Accounts Payable Invoices Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AP Invoices subject area.	AP	Financials - AP Invoices
OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY	Accounts Payable Invoices Analysis Duty	Controls presentation catalog access to Financials Accounts Payable Invoices subject area.	AP	Financials - AP Invoices
OA4F_FIN_AP_LIABILITIES_ANALYSIS_CONTENT_DUTY	Accounts Payable Liabilities Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AP Liabilities subject area.	AP	Financials - AP Liabilities
OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY	Accounts Payable Liabilities Analysis Duty	Controls presentation catalog access to Financials Accounts Payable Liabilities subject area.	AP	Financials - AP Liabilities
OA4F_FIN_AP_PAYMENTS_ANALYSIS_CONTENT_DUTY	Accounts Payable Payments Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AP Payments subject area.	AP	Financials - AP Payments
OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY	Accounts Payable Payments Analysis Duty	Controls presentation catalog access to Financials Accounts Payable Payments subject area.	AP	Financials - AP Payments
OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_CONTENT_DUTY	Accounts Receivable Adjustments Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AR Adjustments subject area.	AR	Financials - AR Adjustments
OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_DUTY	Accounts Receivable Adjustments Analysis Duty	Controls presentation catalog access to Financials Accounts Receivable Adjustments subject area.	AR	Financials - AR Adjustments
OA4F_FIN_AR_AGING_ANALYSIS_CONTENT_DUTY	Accounts Receivable Aging Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AR Aging subject area.	AR	Financials - AR Aging
OA4F_FIN_AR_AGING_ANALYSIS_DUTY	Accounts Receivable Aging Analysis Duty	Controls presentation catalog access to Financials Accounts Receivable Aging subject area.	AR	Financials - AR Aging
OA4F_FIN_AR_APPLICATIONS_ANALYSIS_CONTENT_DUTY	Accounts Receivable Receipts and Applications Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AR Receipts and Applications subject area.	AR	Financials - AR Receipts and Applications
OA4F_FIN_AR_APPLICATIONS_ANALYSIS_DUTY	Accounts Receivable Receipts and Applications Analysis Duty	Controls presentation catalog access to Financials Accounts Receivable Receipts and Applications subject area.	AR	Financials - AR Receipts and Applications
OA4F_FIN_AR_CREDITMEMO_ANALYSIS_CONTENT_DUTY	Accounts Receivable Credit Memo Applications Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AR Credit Memo Applications subject area.	AR	Financials - AR Credit Memo Applications
OA4F_FIN_AR_CREDITMEMO_ANALYSIS_DUTY	Accounts Receivable Credit Memo Applications Analysis Duty	Controls presentation catalog access to Financials Accounts Receivable Credit Memo Applications subject area.	AR	Financials - AR Credit Memo Applications
OA4F_FIN_AR_REVENUE_ANALYSIS_CONTENT_DUTY	Accounts Receivable Revenue Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AR Revenue subject area.	AR	Financials - AR Revenue
OA4F_FIN_AR_REVENUE_ANALYSIS_DUTY	Accounts Receivable Revenue Analysis Duty	Controls presentation catalog access to Financials Accounts Receivable Revenue subject area.	AR	Financials - AR Revenue
OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_CONTENT_DUTY	Accounts Receivable Transactions Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - AR Transactions subject area.	AR	Financials - AR Transactions
OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_DUTY	Accounts Receivable Transactions Analysis Duty	Controls presentation catalog access to Financials Accounts Receivable Transactions subject area.	AR	Financials - AR Transactions
OA4F_FIN_EXM_EMPLOYEE_EXPENSE_ANALYSIS_CONTENT_DUTY	Employee Expense Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - EXM Employee Expenses subject area.	EXM	Financials - EXM Employee Expenses
OA4F_FIN_EXM_EMPLOYEE_EXPENSE_ANALYSIS_DUTY	Employee Expense Analysis Duty	Controls catalog access to the Financials - EXM Employee Expenses subject area.	EXM	Financials - EXM Employee Expenses
OA4F_FIN_FA_ASSETS_ANALYSIS_CONTENT_DUTY	Fixed Asset Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - Assets Analysis subject area.	FA	Financials - Assets Analysis
OA4F_FIN_FA_ASSETS_ANALYSIS_DUTY	Fixed Asset Analysis Duty	Controls catalog access to the Financials Assets Analysis subject area.	FA	Financials - Assets Analysis
OA4F_FIN_FA_ASSETS_TRANSACTIONS_CONTENT_DUTY	Fixed Asset Transactions Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - Assets Transactions subject area.	FA	Financials - Assets Transactions
OA4F_FIN_FA_ASSETS_TRANSACTIONS_DUTY	Fixed Asset Transactions Analysis Duty	Controls catalog access to the Financials Assets Transactions subject area.	FA	Financials - Assets Transactions
OA4F_FIN_GL_ACCOUNT_ANALYSIS_CONTENT_DUTY	General Ledger Account Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - GL Account Analysis subject area.	GL	Financials - GL Account Analysis
OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY	General Ledger Account Analysis Duty	Controls presentation catalog access to Financials GL Account Analysis subject area.	GL	Financials - GL Account Analysis and Configurable Account Analysis
OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_CONTENT_DUTY	General Ledger Balance Sheet Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - GL Balance Sheet subject area.	GL	Financials - GL Balance Sheet
OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY	General Ledger Balance Sheet Analysis Duty	Controls presentation catalog access to Financials GL Balance Sheet subject area..	GL	Financials - GL Balance Sheet
OA4F_FIN_GL_BUDGETS_ANALYSIS_CONTENT_DUTY	General Ledger Budget Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - GL Budgets subject area.	GL	Financials - GL Budgets
OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY	General Ledger Budget Analysis Duty	Controls presentation catalog access to Financials GL Budget subject area.	GL	Financials - GL Budgets
OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_CONTENT_DUTY	General Ledger Detail Transactions Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - GL Detail Transactions subject area.	GL	Financials - GL Detail Transactions
OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY	General Ledger Detail Transactions Analysis Duty	Controls presentation catalog access to Financials GL Detail Transactions subject area.	GL	Financials - GL Detail Transactions
OA4F_FIN_GL_PROFITABILITY_ANALYSIS_CONTENT_DUTY	Profitability Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Financials - GL Profitability subject area.	GL	Financials - GL Profitability
OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY	Profitability Analysis Duty	Controls presentation catalog access to Financials GL Profitability subject area..	GL	Financials - GL Profitability
OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts Analysis Duty	Controls presentation catalog access to Enterprise Contracts subject area.	Enterprise Contracts	Enterprise Contracts - Contracts (Preview)
OA4F_PPM_GRANTS_AWARD_FUNDING_DUTY	Grants Management Award Funding Analysis Duty	Object security role to control presentation catalog access to Grants Award Funding subject area.	GMS	PPM – Grants Award Funding (Preview)
OA4F_PPM_GRANTS_BUDGETS_DUTY	Grants Management Budget Analysis Duty	Object security role to control presentation catalog access to Projects Budgets subject area with Awards attributes.	PJO	PPM - Project Budgets
OA4F_PPM_GRANTS_COSTING_DUTY	Grants Management Costing Analysis Duty	Object security role to control presentation catalog access to Projects Costs and Commitments subject area with Awards attributes.	PJC	PPM - Project Costs, PPM - Project Commitments
OA4F_PPM_GRANTS_INVOICE_DUTY	Grants Management Invoice Analysis Duty	Object security role to control presentation catalog access to Projects Invoice subject area with Awards attributes.	PJB	PPM - Project Invoices
OA4F_PPM_GRANTS_REVENUE_DUTY	Grants Management Revenue Analysis Duty	Object security role to control presentation catalog access to Projects Revenue subject area with Awards attributes.	PJB	PPM - Project Revenue
OA4F_PPM_LABOR_DISTRIBUTIONS_COST_DUTY	Project Labor Distributions Cost Analysis Duty	Object security role to control presentation catalog access to Projects Labor Distribution Costs subject area.	PJC	PPM – Project Labor Distribution Costs (Preview)
OA4F_PPM_LABOR_SCHEDULES_DUTY	Project Labor Schedules Analysis Duty	Object security role to control presentation catalog access to Projects Labor Schedules subject area.	PJC	PPM - Project Labor Schedules (Preview)
OA4F_PPM_PROJECTS_ASSETS_DUTY	Project Costing Assets Analysis Duty	Controls presentation catalog access to Projects Assets subject area.	PJC	PPM - Project Assets (Preview)
OA4F_PPM_PROJECTS_BUDGETS_CONTENT_DUTY	Project Control Budget Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the PPM - Project Budgets subject area.	PJO	PPM - Project Budgets
OA4F_PPM_PROJECTS_BUDGETS_DUTY	Project Control Budget Analysis Duty	Controls catalog access to the Project Budgets subject area.	PJO	PPM - Project Budgets
OA4F_PPM_PROJECTS_COMMITMENTS_CONTENT_DUTY	Project Costing Commitments Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the PPM - Project Commitments subject area.	PJC	PPM - Project Commitments
OA4F_PPM_PROJECTS_COMMITMENTS_DUTY	Project Costing Commitments Analysis Duty	Controls catalog access to the Project Commitments subject area.	PJC	PPM - Project Commitments
OA4F_PPM_PROJECTS_COSTS_CONTENT_DUTY	Project Costing Costs Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the PPM - Project Costs subject area.	PJC	PPM - Project Costs
OA4F_PPM_PROJECTS_COSTS_DUTY	Project Costing Costs Analysis Duty	Controls catalog access to the Project Costs subject area..	PJC	PPM - Project Costs
OA4F_PPM_PROJECTS_FORECASTS_CONTENT_DUTY	Project Control Forecast Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the PPM - Project Forecasts subject area.	PJO	PPM - Project Forecasts
OA4F_PPM_PROJECTS_FORECASTS_DUTY	Project Control Forecast Analysis Duty	Controls catalog access to the Project Forecasts subject area.	PJO	PPM - Project Forecasts
OA4F_PPM_PROJECTS_FUNDING_CONTENT_DUTY	Project Billing Funding Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the PPM - Project Funding subject area.	PJB	PPM - Project Funding
OA4F_PPM_PROJECTS_FUNDING_DUTY	Project Billing Funding Analysis Duty	Controls catalog access to the Project Funding subject area.	PJB	PPM - Project Funding
OA4F_PPM_PROJECTS_INVOICE_CONTENT_DUTY	Project Billing Invoice Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the PPM - Project Invoices subject area.	PJB	PPM - Project Invoices
OA4F_PPM_PROJECTS_INVOICE_DUTY	Project Billing Invoice Analysis Duty	Controls presentation catalog access to Project Invoices subject area.	PJB	PPM - Project Invoices
OA4F_PPM_PROJECTS_REVENUE_CONTENT_DUTY	Project Billing Revenue Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the PPM - Project Revenue subject area.	PJB	PPM - Project Revenue
OA4F_PPM_PROJECTS_REVENUE_DUTY	Project Billing Revenue Analysis Duty	Controls catalog access to the Project Revenue subject area.	PJB	PPM - Project Revenue
OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY	Procurement Purchase Agreement Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Agreements subject area.	Procurement	Procurement - Agreements
OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY	Procurement Purchase Agreement Analysis Duty	Controls catalog access to the Procurement Purchase Agreement subject area.	Procurement	Procurement - Agreements
OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY	Procurement Purchase Order Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Purchase Orders subject area.	Procurement	Procurement - Purchase Orders
OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY	Procurement Purchase Order Analysis Duty	Controls catalog access to the Procurement Purchase Order subject area..	Procurement	Procurement - Purchase Orders
OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY	Procurement Purchase Receipts Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Receipts subject area.	Procurement	Procurement - Receipts
OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY	Procurement Purchase Receipts Analysis Duty	Controls catalog access to the Procurement Purchase Receipts subject area.	Procurement	Procurement - Receipts
OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement Requisitions Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Requisitions subject area.	Procurement	Procurement - Requisitions
OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY	Procurement Requisitions Analysis Duty	Controls catalog access to the Procurement Requisitions subject area.	Procurement	Procurement - Requisitions
OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Procurement Spend Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Spend subject area.	Procurement	Procurement - Spend
OA4F_PROC_SPEND_ANALYSIS_DUTY	Procurement Spend Analysis Duty	Controls catalog access to the Procurement Spend subject area.	Procurement	Procurement - Spend

Common Duty Roles

You can select the subject area for each of the Oracle Fusion Data Intelligence products and review the data lineage details. This enables you to understand the column and table lineage from the presentation layer to the physical layer.

Duty Role Code	Duty Role Name	Details	Functional Area	Gets access to Subject Area Display Name OR Associated Role
OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY	Data Warehouse Refresh Analysis Duty	Object security role to control presentation catalog access to Common - Warehouse Refresh Statistics subject area.	Common	Common - Warehouse Refresh Statistics
OA4F_COMMON_USAGE_TRACKING_DUTY	Usage Tracking Analysis Duty	Object security role to control presentation catalog access to Common - Usage Tracking subject area.	Common	Common - Usage Tracking
OA4F_SECURITY_REPORTING_DUTY	Security Reporting Duty	Object security role to control presentation catalog access to Security Assignment and Security Audit History subject areas.	Common	Common - Security Assignment Common - Security Audit History

Duty Role Code

Duty Role Name

Details

Functional Area

Gets access to Subject Area Display Name OR Associated Role

OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY

Data Warehouse Refresh Analysis Duty

Object security role to control presentation catalog access to Common - Warehouse Refresh Statistics subject area.

Common

Common - Warehouse Refresh Statistics

OA4F_COMMON_USAGE_TRACKING_DUTY

Usage Tracking Analysis Duty

Object security role to control presentation catalog access to Common - Usage Tracking subject area.

Common

Common - Usage Tracking

OA4F_SECURITY_REPORTING_DUTY

Security Reporting Duty

Object security role to control presentation catalog access to Security Assignment and Security Audit History subject areas.

Common

Common - Security Assignment

Common - Security Audit History

Subject Area Metric Details

Overview

Assets

These tables describe Assets metrics.

Financials — Assets Analysis

These metrics will be used in the Analytics Currency (AC) and Ledger Currency (LC) fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Asset Life - Months	Total life converted in months from asset financials summary.
Asset Life - Years	Total life converted in years from asset financials summary.
Avg Asset Original Life (Yrs)	Calculated in years based on asset life - months / current units.
Avg Asset Remaining Life (Yrs)	Calculated in years based on remaining life prorate date - years / current units.
Bonus Depreciation	Bonus depreciation from asset inquiry.
Current Cost	Current cost from assets inquiry.
Current Units	Current units available from asset assignment details.
Depreciation Adjustment Amount	Depreciation Adjustment amount from assets financial inquiry depreciation details.
Depreciation Expense	Depreciation expense from assets inquiry.
Depreciation Reserve	Depreciation reserve from assets inquiry.
Depreciation Reserve Ratio	Depreciation reserve ratio from assets inquiry.
Impairment Reserve	Impairment reserve from assets inquiry.
Lifespan Reached	Calculated in years as 1 - (remaining life prorate date - years / asset life - years).
Lifespan Remaining	Calculated in years as remaining life prorate date - years / asset life - years.
Net Book Value	Net book value from assets inquiry.
Original Cost	Original cost from assets inquiry.
Recoverable Cost	Recoverable cost from assets inquiry.
Remaining Life in Service Date - Months	Remaining life calculated in months from in service date available in asset financials summary.
Remaining Life in Service Date - Years	Remaining life calculated in years from in service date available in asset financials summary.
Remaining Life Prorate Date - Months	Remaining life calculated in months from prorate date available in asset financials summary.
Remaining Life Prorate Date - Years	Remaining life calculated in years from prorate date available in asset financials summary.
Revaluation Reserve	Revaluation reserve from assets inquiry.
Salvage Value	Salvage value from assets inquiry.
YTD Bonus Depreciation	YTD Bonus depreciation from asset inquiry.
YTD Depreciation	YTD depreciation from assets inquiry.
YTD Impairment	YTD Impairment from assets inquiry.

Financials — Assets Transactions

These metrics will be used in the Analytics Currency (AC) and Ledger Currency (LC) fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Adjustment Depreciation Expense	The sum of the transaction amount where account class code = DEPRECIATION EXPENSE and transaction type code = adjustment.
Asset Distribution Amount	Assets distribution amount metric for transactions excluding depreciation related distribution details.
Depreciation Distribution Amount	Depreciation distribution amount metric specifically captures depreciation related distribution details.
Bonus Depreciation Adjustment	The sum of the transaction amount where account class code = BONUS DEPRECIATION EXPENSE and transaction type code = adjustment.
Bonus Depreciation Reserve	The sum of the transaction amount where account class code = BONUS DEPRECIATION RESERVE.
CIP Cost	The sum of the transaction amount where adjustment type = CIP COST.
Cost	The sum of the transaction amount where adjustment type = COST.
Cost Clearing	The sum of the transaction amount where adjustment type = COST CLEARING.
Cost of Removal	The sum of the transaction amount where adjustment type = REMOVALCOST.
Depreciation Expense	The sum of the transaction amount where account class code = DEPRECIATION EXPENSE.
Depreciation Reserve	The sum of the transaction amount where account class code = DEPRECIATION RESERVE.
Impairment Expense	The sum of the transaction amount where adjustment type = IMPAIR EXPENSE.
Impairment Reserve	The sum of the transaction amount where adjustment type = IMPAIR RESERVE.
Net Book Value Retired	The sum of the transaction amount where adjustment type = NBV RETIRED.
Proceeds of Sale	The sum of the transaction amount where adjustment type = PROCEEDS.
Revaluation Reserve	The sum of the transaction amount where adjustment type = REVAL RESERVE.
Revaluation Reserve Retired	The sum of the transaction amount where adjustment type = REVAL RSV RET.
Units Assigned	Shows number of units assigned at the distribution level.

General Ledger

Overview

These tables describe GL metrics.

Financials—GL Account Analysis

These metrics will be used in the Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in subject areas. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Credit Amount (Accounted)	Shows the subledger credit amount for transactions with subledger details and for other journals it shows the journal credit amount..
Debit Amount (Accounted)	Shows the subledger debit amount for transactions with subledger details and for other journals it shows the journal debit amount..
Journal Credit Amount (Accounted)	Shows the sum of credit journal entries amount for specified accounts.
Journal Debit Amount (Accounted)	Shows the sum of debit journal entries amount for specified accounts.
Journal Net Amount (Accounted)	Shows the activity amount of the specified accounts. Where activity amount = sum of Journal debit amount (accounted) - sum of Journal credit amount (accounted).
Net Amount (Accounted)	Shows the activity amount of the specified accounts. Where activity amount = sum of debit amount (accounted) - sum of credit amount (accounted).

Financials—GL Balance Sheet

These metrics are used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in subject areas. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis is Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Use this spreadsheet to view a list of prebuilt Financial Categories used in GL Metrics and business metrics.

Metric	Metric Definition
Activity (STAT)	Shows the activity amount of the specified accounts in STAT currency. Where activity (STAT) = sum of debit (STAT) - sum of credit (STAT).
Asset Turnover Ratios. AP turnover	This metric is computed as follows : daily purchases for the period * 365 / AP amount. Where: daily purchases for the period = purchases / number for days for the selected period.
Asset Turnover Ratios. AR turnover	This metric is computed as follows : daily revenue for the period * 365 / AR amount. Where: daily revenue for the period = revenue / number for days for the selected period.
Asset Turnover Ratios. Avg Inventory Days	This metric is computed as follows : inventories / daily cost of revenue. Where: daily cost of revenue = cost of revenue / number for days from beginning day to till date of the fiscal year.
Asset Turnover Ratios. Cash Cycle	This metric is computed as follows : days sales outstanding - YTD revenue (+) avg inventory days (-) days payables outstanding - YTD purchase. Where: days sales outstanding - YTD revenue = AR amount / daily revenue. Days payables outstanding - YTD purchase = AP amount / daily purchases.
Asset Turnover Ratios. Days Payable Outstanding	This metric is computed as follows: accounts payable / daily cost of revenue. Where: daily cost of revenue = cost of revenue YTD/ cumulative number of days.
Asset Turnover Ratios. Days Sales outstanding	This metric is computed as follows : accounts receivable / daily revenue. Where: daily revenue = revenue YTD /number of cumulative elapsed days. .
Asset Turnover Ratios. Fixed Assets Turnover	This metric is computed as follows : daily revenue * 365 / net PPE. Where: daily revenue = revenue / number for days from beginning day to till date of the fiscal year. .
Asset Turnover Ratios. Inventory Turnover	This metric is computed as follows : daily cost of revenue * 365 / inventories. Where: daily cost of revenue = cost of revenue / number for days from beginning day to till date of the fiscal year.
Asset Turnover Ratios. LT Assets Turnover	This metric is computed as follows : daily revenue * 365 / long term assets. Where: daily revenue = revenue / number for days from beginning day to till date of the fiscal year.
Asset Turnover Ratios. Operating Cycle	This metric is computed as follows : days sales outstanding + avg inventory days.
Asset Turnover Ratios. Total Assets Turnover	This metric is computed as follows : daily revenue * 365 / total assets.
Asset Turnover Ratios. Working Capital Turnover	This metric is computed as follows : daily revenue * 365 / (current assets - current liabilities).
Balance Sheet Ratios. CAPEX	Activities for a period range for financial category for property, plant, and equipment (PPE).
Balance Sheet Ratios. Capex Ratio	This metric is computed as follows : operating cash Flow / CAPEX. Where: operating cash Flow = net income + depreciation expenses - inventories - accounts receivable + accounts payable + accrued liabilities + other current liabilities - prepaid expenses - other current assets.
Balance Sheet Ratios. Current Ratio	This metric is computed as follows : current assets / current liabilities.
Balance Sheet Ratios. Days Cash in Hand	This metric is computed as follows : cash / (daily total operating expenses - daily depreciation expenses). Where: daily total operating expenses = total operating expenses / number for days from beginning day to till date of the fiscal year. daily depreciation expenses = depreciation expenses / number for days from beginning day to till date of the fiscal year.
Balance Sheet Ratios. Debt To Equity	This metric is computed as follows : total liabilities / total shareholders funds Where: total liabilities = current liabilities + long term liabilities.
Balance Sheet Ratios. EBIT YTD	This metric is computed as follows: revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - depreciation expenses YTD.
Balance Sheet Ratios. Interest Expense YTD	Activities for year-to-date for the INT EXP financial category.
Balance Sheet Ratios. NWC to Assets	This metric is computed as follows : (current assets - current liabilities) / total assets.
Balance Sheet Ratios. Quick Ratio	This metric is computed as follows : (cash + AR amount + prepaid expenses + deferred cost of goods sold+ other current assets) / current liabilities.
Balance Sheet Ratios. Times interest Earned	This metric is computed as follows : EBIT YTD / interest expense.
Balance Sheet Statement. Accounts Payable	Shows the accounts payable balance for a particular time period for the AP financial category.
Balance Sheet Statement. Accounts Receivable	Shows the accounts receivable balance for a particular time period for the AR financial category.
Balance Sheet Statement. Accrued Liabilities	Shows the accrued liabilities for a particular time period for the ACC LIAB financial category.
Balance Sheet Statement. Accumulated Depreciation	Shows the accumulated depreciation for a particular time period for the ACC DEPCN financial category.
Balance Sheet Statement. Cash	Shows the cash balance for a particular time period for the CASH financial category.
Balance Sheet Statement. Common Stock	Shows the common stock for a particular time period for the CMMN STOCK financial category.
Balance Sheet Statement. Current Assets	This metric is computed as follows : cash + inventories + prepaid expenses + other current assets + accounts receivable + deferred cost of goods sold.
Balance Sheet Statement. Current Liabilities	This metric is computed as follows : accrued liabilities + short term borrowing + other current liabilities + accounts payable + deferred revenue +tax liabilities.
Balance Sheet Statement. Deferred Cost of Goods Sold	Shows the deferred cost of goods sold balance for a particular time period for the DEFERRED COGS financial category.
Balance Sheet Statement. Deferred Revenue	Shows the deferred revenue for a particular time period for the DEFERRED REVENUE financial category.
Balance Sheet Statement. Finished Goods inventory	Shows the finished goods inventory balance for a particular time period for the FG INV financial category.
Balance Sheet Statement. Goodwill	Shows the goodwill for a particular time period for the GOODWILL financial category.
Balance Sheet Statement. Inventories	The metric is computed as follows: raw material inventory + work in process inventory + finished goods inventory.
Balance Sheet Statement. Long Term Assets	This metric is computed as follows : net PPE + goodwill + other asset.
Balance Sheet Statement. Long term Debt	Shows the long term debt for a particular time period for the LT DEBT financial category.
Balance Sheet Statement. Long Term Liabilities	This metric is computed as follows : long term debt + other liabilities.
Balance Sheet Statement. Net PPE	This metric is computed as follows : PPE - accumulated depreciation.
Balance Sheet Statement. Net Working Capital	This metric is computed as follows : current assets - current liabilities.
Balance Sheet Statement. Other Assets	Shows the other assets for a particular time period for the OTHER ASSET financial category.
Balance Sheet Statement. Other Current Assets	Shows the other current assets balance for a particular time period for the OTHER CA financial category.
Balance Sheet Statement. Other Current Liabilities	Shows the other current liabilities during a particular time period for the OTHER CL financial category.
Balance Sheet Statement. Other Equity	Shows the other equity balance for a particular time period for the OTHER EQUITY financial category.
Balance Sheet Statement. Other Liabilities	Shows the other liabilities for a particular time period for the OTHER LIAB financial category.
Balance Sheet Statement. PPE	Shows the property, plant, and equipment (PPE) for a particular time period for the PPE financial category.
Balance Sheet Statement. Preferred Stock	Shows the preferred stock for a particular time period for the PREF STOCK financial category.
Balance Sheet Statement. Prepaid Expenses	Shows the prepaid expenses balance for a particular time period for the PPAID EXP financial category.
Balance Sheet Statement. Raw Material Inventory	Shows the raw material inventory balance for a particular time period for the RM INV financial category.
Balance Sheet Statement. Retained Earnings	Shows the retained earnings balance for a particular time period for the RET EARNING financial category.
Balance Sheet Statement. Short Term Borrowing	Shows the short term borrowing for a particular time period for the ST BORR financial category.
Balance Sheet Statement. Tax Liabilities	Shows the tax liabilities for a particular time period for the TAX LIAB financial category.
Balance Sheet Statement. Total Assets	This metric is computed as follows : long term assets + current assets.
Balance Sheet Statement. Total Liabilities	This metric is computed as follows : current liabilities + long term liabilities.
Balance Sheet Statement. Total Liabilities Shareholders Funds	This metric is computed as follows : total liabilities + total shareholders funds.
Balance Sheet Statement. Total Shareholders Funds	This metric is computed as follows: preferred stock + common stock + retained earnings + other equity.
Balance Sheet Statement. Work in Process inventory	Shows the work in process inventory balance for a particular time period for the WIP INV financial category.
Closing (STAT)	Shows the closing balance of the specified accounts in STAT currency.
Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.
Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
GL Balance. Absolute Activity Amount	Shows the absolute activity amount of the specified accounts. activity amount = sum of debit amount - sum of credit amount.
GL Balance. Absolute Balance Amount	Shows the absolute balance amount of the specified accounts.
GL Balance. Activity Amount	Shows the activity amount of the specified accounts. Where activity amount = sum of debit amount - sum of credit amount.
GL Balance. Balance Amount	Shows the balance of the specified accounts.
GL Balance. Closing Amount	Shows the closing balance of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount.
GL Balance. Credit Amount	Shows the sum of credit entries amount for specified accounts.
GL Balance. Debit Amount	Shows the sum of debit entries amount for the specified accounts.
GL Balance. Opening Amount	Shows the opening balance of the specified accounts. This metric is computed as follows : balance amount - activity amount.
Opening (STAT)	Shows the opening balance of the specified accounts in STAT currency.

Financials—GL Budgets

These metrics will be used in the Analytics Currency (AC) fact folder and Ledger Currency (LC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Creation Date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Budget Absolute Activity Amount	Shows the absolute activity amount of the specified accounts. activity amount=sum of debit amount-sum of credit amount.
Budget Activity (STAT)	Shows the activity amount of the specified accounts in STAT currency. Where budget activity (STAT) = sum of debit (STAT) - sum of credit (STAT).
Budget Activity Amount	Shows the activity amount of the specified accounts. activity amount = sum of debit amount - sum of credit amount.
Budget Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.
Budget Credit Amount	Shows sum of credit entries amount for specified accounts.
Budget Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
Budget Debit Amount	Shows the sum of debit entries amount for the specified accounts.

Financials—GL Detail Transactions

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Currency Conversion Date and if not available Accounting date will be used to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only only posted journal details are supported.

Metric	Metric Definition
Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.
Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
GL Detail Transactions. Credit Amount	Shows the sum of credit entries amount for specified accounts.
GL Detail Transactions. Debit Amount	Shows the sum of debit entries amount for specified accounts.
GL Detail Transactions. Net Amount	Shows the net amount of the specified accounts. Where net amount = sum of debit amount - sum of credit amount.
Total (STAT)	Shows the activity amount of the specified accounts in STAT currency. Where total (STAT) = sum of debit (STAT) - sum of credit (STAT).

Financials—GL Profitability

Use this spreadsheet to view a list of prebuilt Financial Categories used in GL Metrics and business metrics.

Metric	Metric Definition
Activity (STAT)	Shows the activity amount of the specified accounts in STAT currency. Where activity (STAT) = sum of debit (STAT) - sum of credit (STAT).
Closing (STAT)	Shows the closing balance of the specified accounts in STAT currency.
Cost Details. Cost Ratios. Cost of revenue to Revenue %	This metric is computed as follows : (cost of revenue / revenue) * 100.
Cost Details. Cost Ratios. Interest Expenses to Revenue %	This metric is computed as follows : (interest expense / revenue) * 100.
Cost Details. Cost Ratios. Other Operating Expenses to Revenue %	This metric is computed as follows : (other operating expenses / revenue) * 100.
Cost Details. Cost Ratios. R&D Expenses to Revenue %	This metric is computed as follows : (R&D expenses / revenue) * 100.
Cost Details. Cost Ratios. Sales & Marketing Expenses to Revenue %	This metric is computed as follows : (sales & marketing expense / revenue) * 100.
Cost Details. Cost Ratios. Total Operating Expenses to Revenue %	This metric is computed as follows : (total operating expenses / revenue) * 100.
Cost Details. Other Operating Expenses. Contracting Expenses	Activities for a period range for the CONT EXP financial category.
Cost Details. Other Operating Expenses. Depreciation Expenses	Activities for a period range for the DEPCN financial category.
Cost Details. Other Operating Expenses. Employee Benefits Related Expenses	Employee Benefits Related expenses metric is the activities for a period range for the financial category EMP BENFT.
Cost Details. Other Operating Expenses. Employee Overtime Expenses	Activities for a period range for the EMP OVERTIME financial category.
Cost Details. Other Operating Expenses. Employee Support Expenses	Activities for a period range for the EMP SUPP financial category.
Cost Details. Other Operating Expenses. General Admin and Other Payroll	Activities for a period range for the GEN PAYROLL financial category.
Cost Details. Other Operating Expenses. Miscellaneous Operating Expenses	Activities for a period range for the MISC OPER EXP financial category.
Cost Details. Other Operating Expenses. Product Variance Expenses	Activities for a period range for the VARIANCE EXP financial category.
Cost Details. R&D Expenses. Other R&D Expenses	Activities for a period range for the OTHER R&D EXP financial category.
Cost Details. R&D Expenses. R&D Expenses	Activities for a period range for sum of financial categories with these values OTHER R&D EXP, and R&D PAYROLL.
Cost Details. R&D Expenses. R&D Payroll Expenses	Activities for a period range for the R&D PAYROLL financial category.
Cost Details. Sales and Marketing Expenses. Freight Expenses	Activities for a period range for the FREIGHT financial category.
Cost Details. Sales and Marketing Expenses. Marketing Payroll Expenses	Activities for a period range for the MKTG PAYROLL financial category.
Cost Details. Sales and Marketing Expenses. Other Marketing Expenses	Activities for a period range for the OTHER MKTG EXP financial category.
Cost Details. Sales and Marketing Expenses. Other Sales Expenses	Activities for a period range for the OTHER SLS EXP financial category.
Cost Details. Sales and Marketing Expenses. Sales & Marketing Expenses	Activities for a period range for sum of financial categories with these values: MKTG PAYROLL, SLS PAYROLL, OTHER MKTG EXP, FREIGHT, OTHER SLS EXP, and TRAVEL & ENT EXP.
Cost Details. Sales and Marketing Expenses. Sales Payroll Expenses	Activities for a period range for the SLS PAYROLL financial category.
Cost Details. Sales and Marketing Expenses. Travel & Entertainment Expenses	Activities for a period range for the TRAVEL & ENT EXP financial category.
Credit (STAT)	Shows the sum of credit entries amount for specified accounts in STAT currency.
Debit (STAT)	Shows the sum of debit entries amount for the specified accounts in STAT currency.
GL Balance. Absolute Activity Amount	Shows the absolute activities amount of the specified accounts. Where activity amount = sum of debit amount - sum of credit amount.
GL Balance. Absolute Balance Amount	Shows the absolute balance amount of the specified accounts.
GL Balance. Activity Amount	Shows the activity amount of the specified accounts. Where activity amount = sum of debit amount - sum of credit amount.
GL Balance. Balance Amount	Shows the balance of the specified accounts.
GL Balance. Closing Amount	Shows the closing balance of the specified accounts. The closing amount will show zero if the balance amount is null, this is the only difference between the balance amount and closing amount.
GL Balance. Credit Amount	Shows the sum of credit entries amount for specified accounts.
GL Balance. Debit Amount	Shows the sum of debit entries amount for specified accounts.
GL Balance. Opening Amount	Shows the opening balance of the specified accounts. This metric is computed as follows : balance amount - activity amount.
Opening (STAT)	Shows the opening balance of the specified accounts in STAT currency.
Profit and Loss. Cost of Revenue	Activities for a period range for the COGS, PURCH, and RM CONS financial category.
Profit and Loss. Depreciation Expenses	Activities for a period range for the DEPCN financial category.
Profit and Loss. EBIT	This metric is computed as follows : revenue - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses - depreciation expenses.
Profit and Loss. EBIT Margin %	This metric is computed as follows : (EBIT / revenue) * 100.
Profit and Loss. EBITDA	This metric is computed as follows : revenue - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses.
Profit and Loss. EBITDA Margin %	This metric is computed as follows : (EBITDA / revenue) * 100.
Profit and Loss. EBT	This metric is computed as follows : revenue - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses - interest expense - depreciation expenses.
Profit and Loss. EBT Margin %	This metric is computed as follows : (EBT / revenue) * 100.
Profit and Loss. Gross Margin %	This metric is computed as follows : (Gross profit / revenue) * 100.
Profit and Loss. Gross Profit	This metric is computed as follows : revenue - cost of revenue.
Profit and Loss. Income Tax Expense	Income tax expense metric is the activities for a period range for the INC TAX financial category.
Profit and Loss. Interest Expense	Activities for a period range for the INT EXP financial category.
Profit and Loss. Net Income	This metric is computed as follows : revenue + other income - cost of revenue - sales & marketing expenses - other operating expenses - R&D expenses - interest expense - income tax expense - depreciation expenses.
Profit and Loss. Net Income Margin %	This metric is computed as follows : (net income / revenue) * 100.
Profit and Loss. Operating Margin %	This metric is computed as follows : (operating profit / revenue) * 100.
Profit and Loss. Operating Profit	This metric is computed as follows : revenue - cost of revenue - total operating expenses.
Profit and Loss. Other Income	Activities for a period range for the OTHER INC financial category.
Profit and Loss. Other Operating Expenses	Activities for a period range for sum of financial categories with these values: EMP BENFT, GEN PAYROLL, EMP SUPP, CONT EXP, EMP OVERTIME, VARIANCE EXP, MISC OPER EXP and OTHER OPER EXP.
Profit and Loss. Payroll Cost	Activities for a period range for sum of financial categories with these values: MKTG PAYROLL, SLS PAYROLL, R&D PAYROLL, and GEN PAYROLL.
Profit and Loss. R&D Expenses	Activities for a period range for sum of financial categories with these values: OTHER R&D EXP and R&D PAYROLL.
Profit and Loss. Revenue	Activities for a period range for the REVENUE financial category.
Profit and Loss. Sales & Marketing Expenses	Activities for a period range for sum of financial categories with these values: MKTG PAYROLL, SLS PAYROLL, OTHER MKTG EXP, FREIGHT, OTHER SLS EXP, and TRAVEL & ENT EXP.
Profit and Loss. Total Operating Expenses	This metric is computed as follows : R&D expenses + sales & marketing expenses + other operating expenses.
Profit and Loss YTD. Cost of Revenue YTD	YTD activities for a period range for the COGS, PURCH, and RM CONS financial category..
Profit and Loss YTD. Depreciation Expenses YTD	Depreciation expenses metric is the YTD activities for a period range for the DEPCN financial category.
Profit and Loss YTD. EBIT Margin YTD %	This metric is computed as follows : (EBIT YTD / revenue YTD )* 100.
Profit and Loss YTD. EBIT YTD	This metric is computed as follows: revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - depreciation expenses YTD.
Profit and Loss YTD. EBITDA Margin YTD %	This metric is computed as follows : (EBITDA YTD / revenue YTD) * 100.
Profit and Loss YTD. EBITDA YTD	This metric is computed as follows : revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD.
Profit and Loss YTD. EBT Margin YTD %	This metric is computed as follows : (EBT YTD / revenue YTD) * 100.
Profit and Loss YTD. EBT YTD	This metric is computed as follows : revenue YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - interest expense YTD - depreciation expenses YTD.
Profit and Loss YTD. Gross Margin YTD %	This metric is computed as follows : (Gross profit YTD / revenue YTD) * 100.
Profit and Loss YTD. Gross Profit YTD	This metric is computed as follows : revenue YTD - cost of revenue YTD.
Profit and Loss YTD. Income Tax Expense YTD	Income tax expense metric is the YTD activities for a period range for the INC TAX financial category.
Profit and Loss YTD. Interest Expense YTD	Interest expense metric is the YTD activities for a period range for the INT EXP financial category.
Profit and Loss YTD. Net Income Margin YTD %	This metric is computed as follows : (net income YTD / revenue YTD) * 100.
Profit and Loss YTD. Net Income YTD	This metric is computed as follows : revenue YTD + other income YTD - cost of revenue YTD - sales & marketing expenses YTD - other operating expenses YTD - R&D expenses YTD - interest expense YTD - income tax expense YTD.
Profit and Loss YTD. Operating Margin YTD %	This metric is computed as follows : (operating profit YTD / revenue YTD) * 100.
Profit and Loss YTD. Operating Profit YTD	This metric is computed as follows : revenue YTD - cost of revenue YTD - total operating expenses YTD.
Profit and Loss YTD. Other Income YTD	Other income metric is the YTD activities for a period range for the OTHER INC financial category.
Profit and Loss YTD. Other Operating Expenses YTD	Other operating expenses metric is the YTD activities for a period range for sum of financial categories with these values: EMP BENFT, GEN PAYROLL, EMP SUPP, CONT EXP, EMP OVERTIME, VARIANCE EXP, MISC OPER EXP and OTHER OPER EXP.
Profit and Loss YTD. R&D Expenses YTD	This metric is computed as follows : R&D payroll expenses YTD + other R&D expenses YTD.
Profit and Loss YTD. Revenue YTD	YTD activities for a period range for the REVENUE financial category.
Profit and Loss YTD. Sales & Marketing Expenses YTD	This metric is computed as follows : marketing payroll expense YTD + other marketing expenses YTD + sales payroll expenses YTD + Freight expenses YTD + other sales expenses YTD + travel & Entertainment expenses YTD.
Profit and Loss YTD. Total Operating Expenses YTD	This metric is computed as follows : sales & marketing expense YTD + R&D expense YTD + other operating expense YTD.
Return on Investment. Current Assets	This metric is computed as follows : cash + inventories + prepaid expenses + other current assets + accounts receivable + deferred cost of goods sold.
Return on Investment. Current Liabilities	This metric is computed as follows : accrued liabilities + short term borrowing + other current liabilities + accounts payable + deferred revenue +tax liabilities.
Return on Investment. Retained Earnings	Shows the retained earnings balance for a particular time period for the RET EARNING financial category.
Return on Investment. ROA	This metric is computed as follows : (daily net income * 365 / total assets) * 100.
Return on Investment. ROA (Pre-Interest)	This metric is computed as follows : (((daily net income + daily interest expense) * 365) / total assets) * 100.
Return on Investment. ROCE (EBIT Basis)	This metric is computed as follows : (daily net income + daily interest expense + daily income tax expense) * 365 / (common stock + long term debt + retained earnings + preferred stock + other equity + other liabilities) * 100.
Return on Investment. ROCE (Pre-Interest)	This metric is computed as follows : (daily net income + daily interest expense) * 365 / (common stock + long term debt + retained earnings + preferred stock + other equity + other liabilities) * 100.
Return on Investment. ROE	This metric is computed as follows : daily net income * 365 / (common stock + retained earnings + other equity) * 100.
Return on Investment. ROE (Pre-Interest)	This metric is computed as follows : (((daily net income + interest expense ) * 365) / (common stock + retained earning + other equity)) * 100. Where: common stock = ending balance for the CMMN STOCK financial category. retained earning = ending balance for the RET EARNING financial category. other equity = ending balance for the OTHER EQUITY financial category.
Return on Investment. Total Assets	This metric is computed as follows : long term assets + current assets.
Return on Investment. Total Liabilities	This metric is computed as follows : current liabilities + long term liabilities.
Return on Investment. Total Shareholders Funds	This metric is computed as follows : preferred stock + common stock + retained earnings + other equity.

Expenses

Overview

These tables describe Expenses metrics.

Financials — EXM Employee Expenses

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder, Document Currency (DC) fact folder and Reimbursement Currency fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Anomaly Rank	Anomaly Rank is assigned based on anomaly risk in descending order for anomalous records. Non Anomalous and Unprocessed records are assigned next available anomaly rank.
Anomaly Risk	This metric shows sum of anomaly risk for expense report distributions.
Audit Adjustment Amount	This metric is supported only in reimbursement currency and is calculated as follows: original reimbursement amount - expense amount.
Auto Audit Percentage	This metric shows the percentage of expense reports with audit type equal to automatic approval.
Average Anomaly Risk	This metric shows sum of anomaly risk across selected records in the analysis.
Average Days Late	This metric is calculated as follows: days late/ expense reports count where days late is the number of days between expense report Submission date and transaction date.
Average Expense Amount	This metric is calculated as follows: total expense amount/expense reports count.
Cash Expense Amount	This metric shows the expense amount for lines with expense source as cash.
Cash Expense Reimbursement Cycle Time (Days)	This metric is calculated as follows: total cash expense days/ expense distribution count where total cash expense days is the number of days between cash expense report paid date and Submission date.
Credit Card Expense Amount	This metric shows the expense amount for lines with expense source as credit card.
Expense Approval Cycle Time (Days)	This metric is calculated as follows: total approval days/ expense distribution count where total approval days is the number of days between expense report final approval date and Submission date.
Expense Distribution Count	This metric shows count of distinct expense report distributions.
Expense Filing Cycle Time (Days)	This metric is calculated as follows: total Filing days/ expense distribution count where total Filing days is the number of days between expense report Submission date and creation date.
Expense Lines Count	This metric shows count of distinct expense report lines.
Expense Reports Count	This metric shows count of distinct expense reports.
Manual Audit Percentage	This metric shows the percentage of expense reports with audit type not equal to automatic approval.
Total Expense Amount	This metric shows the expense amount.
Receipt Amount	This metric displays the Receipt Amount in Document currency.
Reimbursement Amount	This metric displays the Reimbursement Amount in Document and Reimbursement currency.
Per Diem Amount	This metric displays the Per Diem Amount in Document currency.

Payables

Overview

These tables describe Payables metrics.

Financials—AP Aging

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Aging Amount - Invoice Date Basis	Shows the aging amount for the open invoices based on invoice open date grouped by selected aging period.
Aging Amount - Schedule Date Basis	Shows the aging amount for the open invoices based on schedule date grouped by selected aging period.
Aging Count - Invoice Date Basis	Shows the aging count for the open invoices based on invoice open date grouped by selected aging period. The grain for this is invoice payment schedule.
Aging Count - Schedule Date Basis	Shows the aging count for the open invoices based on schedule date grouped by selected aging period. The grain for this is invoice payment schedule.
Amount Due Next 30 Days	This metric is computed as follows: overdue amount + upcoming dues for 30 days for open invoices.
AP Balances. Activity Amount	Shows the activities amount of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time.
AP Balances. Closing Amount	Shows the closing balance (end of period balance) of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time. This metric is available only at a monthly granularity.
AP Balances. Opening Amount	Shows the opening balance (beginning of period balance) of the specified accounts that can be aggregated by business unit, supplier, supplier site, and time. This metric is available only at a monthly granularity.
AP Turnover. AP Turnover	This metric is computed as follows : ((invoice amount - credit memo amount - debit memo amount )* 365) / (closing amount * number of days in a selected period). This metric will provide correct value only when used with common or pillar specific dimensions.
AP Turnover. Days Payables Outstanding	This metric is computed as follows : (closing amount * number of days in a selected period) / (invoice amount - credit memo amount - debit memo amount). This metric will provide correct value only when used with common or pillar specific dimensions.
Avg Invoice Days Current	This metric is computed as follows: total number of days before due date / current invoices count. This is based on schedule date.
Avg Invoice Days Outstanding	This metric is computed as follows: total number of days invoice outstanding / total outstanding invoices count. This is based on invoice date.
Avg Invoice Days overdue	This metric is computed as follows: total number of days invoice overdue / overdue invoices count. This is based on schedule date.
Current Amount	Shows the invoices amount which are yet to cross the schedule due date.
Current Amount to Total Outstanding %	This metric is computed as follows: (current amount / total outstanding amount) * 100.
Current Count to Total Outstanding %	This metric is computed as follows: (current invoices count / total outstanding invoices count) * 100.
Current Invoices Count	Shows the invoices count which are yet to cross the schedule due date. The grain for this is invoice payment schedule.
Open Invoices Amount	Shows the total invoice amount for the invoices that are fully open and partially open.
overdue Amount	Shows the invoices amount which has crossed the schedule due date. The grain for this is invoice payment schedule.
overdue Amount to Total Outstanding %	This metric is computed as follows: (overdue amount / total outstanding amount) * 100.
overdue Count to Total Outstanding %	This metric is computed as follows: (overdue invoices count / total outstanding invoices count) * 100.
overdue Invoices Count	Shows the invoices count which has crossed the schedule due date. The grain for this is invoice payment schedule.
Total Outstanding Amount	Shows the outstanding invoice amount which includes current and overdue invoices.
Total Outstanding Invoices Count	Shows the count of outstanding invoices computed as follows: (current invoices count + overdue invoices count).
Future Activity Amount	Shows the total activity amount that is accounted in future periods. This amount is available for analysis only in the current snapshot.

Financials—AP Expenses

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Expense Distribution Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only accounted invoices are supported.

Metric	Metric Definition
Applied Prepayment Amount	Shows the Prepayment Amount applied to invoices. This metric should be used with the Prepayment Invoice Number and Prepayment Line Number attributes to show the Prepayment or Prepayment line level amounts.
Available Prepayment Amount	Shows the available Prepayment Amount, calculated as Prepayment Amount - Applied Prepayment Amount. This metric should be used with the Prepayment Invoice Number and Prepayment Line Number attributes to show the Prepayment or Prepayment line level amounts.
Canceled Amount	Shows the canceled amount based on the canceled flag set at the distribution level.
Deferred Expense Amount	Shows the Deferred expense amount of distribution lines with Account Class as 'Deferred Item Expense'.
Exclusive Tax Amount	Shows the Tax amount of lines that are explicitly defined as Tax lines.
Expense Distribution Amount	Shows the invoice expense distribution amount for AP invoices and considers all invoice types. Excludes cancelled distributions.
Expense Distribution Count	Shows the invoice expense distribution count for AP invoices and considers all invoice types. Excludes cancelled distributions.
Freight Amount	Shows the Freight amount of the AP Invoice using the line type code 'FREIGHT' excluding the tax amount.
Inclusive Tax Amount	Shows the Tax amount that is included in the line amount.
Item Amount	Shows the Item amount of the AP Invoice calculated using the line type code 'ITEM' excluding the tax amount.
Miscellaneous Amount	Shows the Miscellaneous amount of the AP Invoice using the line type code 'MISCELLANEOUS' excluding the tax amount.
Prepayment Amount	Shows the Prepayment Amount for invoices of type Prepayment. This metric should be used with the Prepayment Invoice Number and Prepayment Line Number attributes to show the Prepayment or Prepayment line level amounts.
Retainage Amount	Shows the amount retained on the invoice.
Self-Assessed Tax Amount	Shows the Tax amount of lines that have Self-assessed tax indicator enabled.
Withholding Tax Amount	Shows the Withholding Tax amount calculated using the 'AWT' line type code.
Expense Invoice Amount	Shows the Invoice amount calculated from the distribution lines.
Line Amount	Shows the Line amount of the invoices calculated from the distribution lines.

Financials—AP Holds

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Metric	Metric Definition
Average Days on Hold	This metric is computed as follows: (sum (release date - hold date) / total number of holds applied on invoice headers and lines considering active and release holds). The active holds are without release details and use the system date if the release date is not available.
Header Holds Count	Shows the header hold count which has header level hold and considers all invoice types. This metric considers only active holds which are without release details.
Invoice Header on Hold Release Amount	Shows the invoice amount and considers all invoice types that have header level hold. This metric considers active holds that are released.
Invoice Headers on Hold Amount	Shows the invoice amount and considers all invoice types that have header level hold. This metric considers only active holds that are without release details.
Invoice Headers on Hold Count	Shows the invoice header count which has header level hold and considers all invoice types. This metric considers only active holds which are without release details.
Invoice Lines on Hold Amount	Shows the invoice line amount which has line level hold and considers all invoice types. This metric considers only active holds which are without release details.
Invoice Lines on Hold Count	Shows the invoice line count which has line level hold and considers all invoice types. This metric considers only active holds which are without release details.
Invoice Lines on Hold Release Amount	Shows the invoice line amount which had line level hold and considers all invoice types. This metric considers active holds that are released.
Invoices on Hold Amount	Shows the invoice amount and considers all invoice types that have either header level hold, line level hold, or a combination. This metric considers only active holds that are without release details.
Invoices on Hold Count	Shows the invoice count and considers all invoice types that have either header level hold, line level hold, or a combination. This metric considers only active holds that are without release details.
Invoices on Hold Release Amount	Shows the invoice amount and considers all invoice types that have either header level hold, line level hold, or a combination. This metric considers only active holds that are released.
Line Holds Count	Shows the line hold count which has line level hold and considers all invoice types. This metric considers only active holds which are without release details.
Total Holds Count	Shows the total number of holds applied on invoice headers and lines. This metric considers only active holds which are without release details.
Historic Holds Count	This metric can be used to analyse historic holds trend for past periods with a limit of 24 Months from the current date.

Financials—AP Invoices

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Metric	Metric Definition
Avg Credit Memos Amount	This metric is computed as follows: credit memos amount / credit memos count.
Avg Debit Memos Amount	This metric is computed as follows: debit memos amount / debit memos count.
Avg Invoices Amount	This metric is computed as follows: invoices amount / invoices count.
Credit Memos Amount	Shows the invoice amount for the credit memo invoice type.
Credit Memos Count	Shows the invoices count for credit memo invoice type.
Credit Memos to Invoices Amount %	This metric is computed as follows: (credit memos amount / invoices amount) * 100.
Debit Memos Amount	Shows the invoice amount for the debit memo invoice type.
Debit Memos Count	Shows the invoices count for debit memo invoice type.
Discount Offered %	This metric is computed as follows: (discount offered amount / total transaction amount) * 100.
Discount Offered Amount	Shows the discount offered amount for all transactions.
Invoices Amount	Shows the invoice amount excluding the credit memo and debit memo invoice type.
Invoices Count	Shows the invoices count excluding the credit memo and debit memo invoice type.
Total Transaction Amount	Shows the sum of invoice amount, debit memos amount and credit memos amount.
Total Transaction Count	Shows the sum of invoice count, debit memos count and credit memos count.
Invoice Creation to Issue Time	Shows the time elapsed between Invoice Date and Invoice Creation Date.

Financials—AP Liabilities

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Invoice Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only accounted invoices are supported.

Metric	Metric Definition
Liability Balance Amount	This metric shows balance of AP liability account as of the selected time.
Liability Distribution Amount	Shows the liability distribution amount.

Financials—AP Payments

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas.

Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Payment Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only accounted payments are supported.

Metric	Metric Definition
% Electronic Payment Amount	This metric is computed as follows: (electronic payment amount / payments amount) * 100.
% Interest Penalties Paid	This metric is computed as follows: (interest penalties paid / payment amount) * 100.
Avg Payments Amount	This metric is computed as follows: (payments amount / payments count) * 100. And grain is payments or check number.
Avg Supplier Payment Days	This metric is computed as follows: Sum of installment level Payment Days / Number of Installments that are paid.
Discount Lost %	This metric is computed as follows: (discount lost amount / total transaction amount) * 100. This metric is supported only in document currency, and will provide correct value only when used with common or pillar specific dimensions.
Discount Lost Amount	Shows the discount amount lost for the invoice payments. This metric is supported only in document currency.
Discount Remaining Amount	This metric is computed as follows: discount offered amount - discount taken amount - discount lost amount. This metric is supported only in document currency, and will provide correct value only when used with common or pillar specific dimensions.
Discount Taken %	This metric is computed as follows: (discount taken amount / total transaction amount) * 100. This metric will provide correct value only when used with common or pillar specific dimensions.
Discount Taken Amount	Shows the discount amount taken for the invoice payments.
Discount Taken Exchange Loss(Gain) Amount	Shows the discount taken exchange loss or gain amount for the invoices and grain is payments or check number.
Electronic Payment Amount	Shows the paid invoice amount using electronic payment method.
Interest Penalties Paid	Shows the payment amount for invoices with the interest invoice type.
On Time Payment Performance %	This metric is computed as follows: (on time payments count / total payments count) * 100.
On Time Payments Amount	Shows the amount of payment transactions where the payment date is lesser than or equal to the scheduled payment date and payment schedule is fully paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
On Time Payments Count	Shows the count of payment transactions where payment date is lesser than or equal to scheduled payment date and payment schedule is fully paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
overdue Payments Amount	Shows the amount of payment transactions where the payment date exceeds the scheduled payment date and the payment schedule status is fully paid or partly paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
overdue Payments Count	Shows the count of payment transactions where the payment date exceeds the scheduled payment date and the payment schedule status is fully paid or partly paid. Excludes cancelled payments and considers all invoice types. The grain for this is metric is payment schedules.
Payment Distribution Amount	Shows the payment distribution amount for AP payments.
Payment Exchange Loss(Gain) Amount	Shows the payment exchange loss or gain amount for the invoices and grain is payments or check number.
Payments Amount	Shows the total payments amount for the invoices and grain is payments or check number.
Payments Document Count	Shows the payments document count and grain is payments or check number.
Total Paid Installments Count	This metric is computed as follows: overdue payments count + on time payments count.
Total Payment Days	Shows the total payment days for fully paid invoices and considers all invoice types. payment days is computed as follows: payment date - invoice date.
Weighted Avg Supplier Payment Days	This metric is computed as follows: Sum of installment level Payment Days*Payment Amount / Total Payment Amount.

Procurement

Overview

These tables describe Procurement metrics.

Procurement - Accrual Balances at Period End (Preview)

These metrics are used in the Analytics Currency (AC) and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Accrued Quantity	This metric shows Accured Quantity in Primary Unit of Measure.
Invoiced Quantity	This metric shows Invoiced Quantity in Primary Unit of Measure.
Uninvoiced Quantity	This metric shows Net Accrued Amount in Primary Unit of Measure.
Accrued Amount	This metric shows Amount Accrued due to receiving.
Invoiced Amount	This metric shows Amount Invoiced in payables.
Uninvoiced Receipt Accruals	This metric shows Net Accrual Amount to be Invoiced.

Procurement - Accrual Balances at Receipt (Preview)

These metrics are used in the Analytics Currency (AC) and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Event Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Accrued Quantity	This metric shows Accured Quantity in Primary Unit of Measure.
Invoiced Quantity	This metric shows Invoiced Quantity in Primary Unit of Measure.
Accrued Amount	This metric shows Amount Accrued due to receiving.
Invoiced Amount	This metric shows Amount Invoiced in payables.
Open Accrual Balance	This metric shows Net Accrual Amount to be Invoiced.

Procurement—Agreements

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Purchase Order Agreement Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Agreement Line Quantity	This metric is calculated as sum of agreement line quantity in primary and transaction UOM.
Header Agreed Amount	This metric is calculated as sum of header agreed amount.
Header Released Amount	This metric is calculated as sum of header released amount.
Header Released %	This metric is calculated as total agreement released amount divided by agreement amount.
Line Agreed Amount	This metric is calculated as sum of line agreed amount.
Line Released Amount	This metric is calculated as sum of line released amount.
Line Released Amount %	This metric is calculated as sum of line released amount divided by line agreed amount.
Remaining Header Amount	This metric is calculated as header agreed amount minus header released amount where agreement amount is not null and agreed amount is greater than released amount.
Remaining Header Amount %	This metric is calculated as remaining header amount divided by total header agreed amount.
Remaining Line Amount	This metric is calculated as sum of agreed line amount minus sum of line released amount where agreement line agreed amount is not null and agreed amount is greater than released amount.
Remaining Line Amount %	This metric is calculated as sum of remaining line amount divided by sum of agreed amount.
Expired Header Released %	This metric is calculated as header released amount divided by header agreed amount where agreement amount is not null and considering headers are expired.
Expired Line Released %	This metric is calculated as line released amount divided by line agreed amount where agreement amount is not null and considering lines which are expired.
Average Unit Price	This metric shows Average of unit price at lines.
Header Agreement Count by Release %	This metric shows Count of agreement header release percent in different bucket percentages.
Header Agreement Count Expired in Days	This metric shows Count of agreement header which will expire in different bucket days.
Agreement Header Count	This metric shows Count of distinct agreement headers.
Agreement Lines Count	This metric shows Count of distinct blanket agreement lines.
Agreement Approval Cycle Time	This metric is calculated as average difference between agreement approval date for version zero and creation date.
Negotiation to Agreement Approval Cycle Time	This metric is calculated as average difference between agreement approval date for version zero and negotiation line creation date.
Approvers Count	This metric is calculated as average approvers for version zero of an agreement.
Item Count	This metric shows Count of distinct items.
Supplier Count	This metric shows Count of distinct suppliers.
Supplier Site Count	Count of distinct supplier sites.
Buyer Count	Count of distinct buyers.
Header Expiring Days	This metric is calculated as average difference between end date and system date where agreement header end date is not null.
Line Expiring Days	This metric is calculated as average difference between expiration date and system date where either of agreement lines expiration date is not null or header end date is not null.
Average Number of Revisions	This metric is calculated as average of agreement versions.
Amendments Count	This metric is calculated as average amendments done for an agreement.
Internal Amendments Count	This metric is calculated as average number of internal amendments for an agreement.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for an agreement.
Agreement Line Primary Quantity	This metric is calculated as sum of agreement line quantity in primary UOM.
Average Unit Price (Primary UOM)	Average of unit price at lines in primary UOM.

Procurement—Enterprise Contracts (Preview)

These metrics are used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Contract Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Contract Amount	This metric is calculated as the sum of contract amount.
Contract Agreed Amount	This metric is calculated as the sum of contract agreed amount.
Contract Line Amount	This metric is calculated as the sum of contract line amount.
Contract Line Agreed Amount	This metric is calculated as the sum of contract line agreed amount.
Fulfillment Amount	This metric is calculated as the sum of fulfillment amount.
Fulfillment Agreed Amount	This metric is calculated as the sum of fulfillment agreed amount.
Contract Count	This metric is calculated as the count of distinct contract headers.
Contract Line Quantity	This metric is calculated as the sum of contract line quantity and shows quantity in primary and transaction UOM.
Contract Line Committed Quantity	This metric is calculated as the sum of contract line committed quantity and shows quantity in primary and transaction UOM.
Fulfillment Quantity	This metric is calculated as the sum of fulfillment quantity and shows quantity in primary and transaction UOM.
Fulfillment Agreed Quantity	This metric is calculated as the sum of fulfillment agreed quantity and shows quantity in primary and transaction UOM.
Days to Expiration	This metric is calculated as average difference between system date and header contract end date.
Contract Cycle Time (Days)	This metric is calculated as average difference between contract signed date and contract creation date for latest version with active status.
Non-Standard Clauses Contract Count	This metric is calculated as the count of contracts where clauses are modified.
% Contracts with Non-Standard Clauses	This metric is calculated as the count of contracts where clauses are modified divided by the count of contract headers.

Procurement—Purchase Orders

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Purchase Order Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Ordered Quantity	This metric is calculated as sum of quantity net of cancelled quantity at distribution level in primary and transaction UOM.
Original Ordered Quantity	This metric is calculated as sum of quantity including cancelled quantity at distribution level in primary and transaction UOM.
Cancelled Quantity	This metric is calculated as sum of cancelled quantity at distribution level in primary and transaction UOM.
Consignment Quantity	This metric is calculated as sum of consigned quantity at distribution level in primary and transaction UOM.
Billed Quantity	This metric is calculated as sum of billed quantity at distribution level in primary and transaction UOM.
Delivered Quantity	This metric is calculated as sum of delivered quantity at distribution level in primary and transaction UOM.
Received Quantity	This metric is calculated as sum of received quantity at schedule level in primary and transaction UOM.
Shipped Quantity	This metric is calculated as sum of shipped quantity at schedule level in primary and transaction UOM.
Accepted Quantity	This metric is calculated as sum of accepted quantity at schedule level in primary and transaction UOM.
Rejected Quantity	This metric is calculated as sum of rejected quantity at schedule level in primary and transaction UOM.
Over Receipt Quantity	This metric shows quantity that is received more that purchase order quantity in primary and transaction UOM.
Purchase Order Count	This metric shows Count of distinct purchase order headers.
Purchase Order Lines Count	This metric shows Count of distinct purchase order lines.
Requisition Lines Count	This metric shows Count of distinct requisition lines associated in purchase order distributions.
Average Number of Revisions	This metric is calculated as average of revision numbers of a purchase order.
Amendments Count	This metric is calculated as average amendments done for a purchase order.
Internal Amendments Count	This metric is calculated as average number of internal amendments for a purchase order.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for a purchase order.
Pre Processing Lead Time	This metric is calculated as average difference between purchase order approval date and purchase order creation date for version zero.
Approvers Count	This metric is calculated as average number of approvers in a purchase order.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval date.
PO Open Cycle Time	This metric is calculated as average difference between purchase order implement date for version zero and purchase order creation date.
PO Close Cycle Time	This metric is calculated as average difference between purchase order close date and purchase order creation date.
Negotiation to PO Cycle Time	This metric is calculated as average difference between purchase order approval date for version zero and negotiation line creation date for purchase orders created from negotiations.
Requisition Based PO %	This metric is calculated as count of distribution with requisition references divided by count of total distributions.
Buyers Count	This metric shows Count of distinct buyers.
Payment Terms Count	This metric shows Count of distinct payment terms.
Ordered Amount	This metric is calculated as sum of ordered amount at distribution level inclusive of inclusive taxes.
Total Exclusive Tax Amount	This metric is calculated as sum of total exclusive tax amount at distribution level.
Total Amount	This metric is calculated as sum of total amount at distribution level.
Non Recoverable Tax Amount	This metric is calculated as sum of non recoverable tax amount at distribution level.
Recoverable Tax Amount	This metric is calculated as sum of recoverable tax amount at distribution level.
Non Recoverable Inclusive Tax Amount	This metric is calculated as sum of non recoverable inclusive tax amount at distribution level.
Recoverable Inclusive Tax Amount	This metric is calculated as sum of recoverable inclusive tax amount at distribution level.
Delivered Amount	This metric is calculated as sum of delivered amount at distribution level.
Billed Amount	This metric is calculated as sum of billed amount at distribution level.
Cancelled Amount	This metric is calculated as sum of cancelled amount at distribution level.
Accepted Amount	This metric is calculated as sum of accepted amount at schedule level.
Accepted Rate	This metric is calculated as sum of accepted amount divided by sum of received amount at schedule level.
Received Amount	This metric is calculated as sum of received amount at schedule level.
Shipped Amount	This metric is calculated as sum of shipped amount at schedule level.
Avg Unit Price	This metric is calculated as sum of ordered amount excluding inclusive taxes divided by sum of ordered quantity.
Max Unit Price	This metric is calculated as maximum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Min Unit Price	This metric is calculated as minimum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Average Amount Per PO	This metric is calculated as sum of ordered amount divided by count of distinct purchase orders.
Supplier Count	This metric shows Count of distinct Supplier.
Open PO Count	This metric shows Count of purchase order header status equal to Open and Closed for Receiving. This metric is deprecated in 23.R2. Please use the Open Purchase Order Count metric.
Closed PO Count	This metric shows Count of purchase order header status equal to Closed for Invoicing, Closed, and Finally Closed. This metric is deprecated in 23.R2. Please use the Closed Purchase Order Count metric.
Rejected Quantity %	This metric shows Rejected Quantity percentage to overall Receipt Quantity for a given period.
Over Receipt Quantity %	This metric shows Over Receipt Quantity percentage to overall Receipt Quantity for a given period.
Cancelled Quantity %	This metric shows Cancelled Quantity percentage to overall Ordered Quantity for a given period.
Discounts Amount	This metric shows discount amount for the purchase order lines which has discount type as amount or percentage.
Negotiated Amount	This metric shows amount of the purchase order lines which has negotiated indicator as Y.
Open PO Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Open and Closed for Receiving. This metric is deprecated in 23.R2. Please use the Open Purchase Order Amount metric.
Closed PO Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Closed for Invoicing, Closed, and Finally Closed. This metric is deprecated in 23.R2. Please use the Closed Purchase Order Amount metric.
Over Receipt Amount	This metric shows amount that is received more than purchase order quantity at schedule level.
Avg Unit Price (Primary UOM)	This metric is calculated as sum of ordered amount excluding inclusive taxes divided by sum of ordered quantity in primary UOM.
Max Unit Price (Primary UOM)	This metric is calculated as maximum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level in primary UOM.
Min Unit Price (Primary UOM)	This metric is calculated as minimum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level in primary UOM.
Open Purchase Order Count	Count of purchase order header status equal to Open, Closed for Receiving, and Closed for Invoicing.
Closed Purchase Order Count	Count of purchase order header status equal to Closed, and Finally Closed.
Open Purchase Order Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Open, Closed for Receiving, and Closed for Invoicing.
Closed Purchase Order Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Closed, and Finally Closed.

Procurement—Receipt Accounting (Preview)

These metrics are used in the Analytics Currency (AC), Document Currency (DC), and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Receipt Accounting Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Transaction Quantity	This metric displays the Receipt Accounting Transaction level Quantity.
Quantity in Primary UOM	This metric displays the Receipt Accounting Transaction level Quantity in Primary Unit of Measure.
Quantity in Secondary UOM	This metric displays the Receipt Accounting Transaction level Quantity in Secondary Unit of Measure.
Debit Amount	This metric displays the Debit Amount for each Receipt Accounting Distribution.
Credit Amount	This metric displays the Credit Amount for each Receipt Accounting Distribution.
Count of Accrued Receipts	This metric displays the count of accrued receipts.

Procurement—Receipts

The fact folders in this subject area show the metrics details described in the table.

Metrics

Metric	Metric Definition
Received Quantity	This metric is calculated as sum of received quantity in primary and transaction UOM.
Accepted Quantity	This metric is calculated as sum of accepted quantity in primary and transaction UOM.
Delivered Quantity	This metric is calculated as sum of delivered quantity in primary and transaction UOM.
Rejected Quantity	This metric is calculated as sum of rejected quantity in primary and transaction UOM.
Returned Quantity	This metric is calculated as sum of returned quantity in primary and transaction UOM.
Consumed Quantity	This metric is calculated as sum of consumed quantity in primary and transaction UOM.
Shipped Quantity	This metric is calculated as sum of shipped quantity in primary and transaction UOM.
Receipt Headers Count	This metric shows Count of distinct receipt headers.
Receipt Lines Count	This metric shows Count of receipt lines.
Purchase Order Count	This metric shows Count of distinct purchase orders.
Purchase Order Schedule Count	This metric shows Count of distinct purchase order schedule.
Received Lines On Time %	This metric is calculated as count of lines received on time divided by count of receipt lines.
Received Lines Late %	This metric is calculated as count of lines received late divided by count of receipt lines.
Received Lines Early %	This metric is calculated as count of lines received early divided by count of receipt lines.
Receipt Lines with Correction Count	This metric is calculated as count of receipt lines with atleast one correction transaction.
Receipt Lines with Correction %	This metric is calculated as receipt corrected count divided by receipt line count.
Receipt Lines Rejected Count	This metric is calculated as count of receipt lines with rejected quantity greater than zero.
Receipt Lines Rejected %	This metric is calculated as receipt rejected count divided by receipt lines count.
Receipt Lines Accepted Count	This metric is calculated as count of receipt lines with accepted quantity greater than zero.
Receipt Lines Accepted %	This metric is calculated as receipt accepted count divided by receipt lines count.
Receipt Lines Returned Count	This metric is calculated as count of receipt lines with returned quantity greater than zero.
Receipt Lines Returned %	This metric is calculated as receipt returned count divided by receipt lines count.
Post Processing Time	This metric is calculated as average difference between deliver date and receipt date.
Processing Time	This metric is calculated as average difference between receipt date and purchase order approval date for version zero.
Transportation Days	This metric is calculated as average difference between receipt header creation date and shipment date for advance shipment notice-based receipts.
ASN Receipts %	This metric is calculated as count of advanced shipment notice-based receipts divided by count of receipt headers.
Received Amount	This metric is calculated as sum of received quantity multiplied by unit price from purchase order in primary UOM.
Accepted Amount	This metric is calculated as sum of accepted quantity multiplied by unit price from purchase order in primary UOM.
Delivered Amount	This metric is calculated as sum of delivered quantity multiplied by unit price from purchase order in primary UOM.
Rejected Amount	This metric is calculated as sum fo rejected quantity multiplied by unit price from purchase order in primary UOM.
Returned Amount	This metric is calculated as sum of returned quantity multiplied by unit price from purchase order in primary UOM.
Avg Unit Price (Primary UOM)	Average of unit price at purchase order lines in primary UOM.

Procurement—Requisitions

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Requisition Creation Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Requisition Quantity	This metric is calculated as sum of quantity at distribution level and excludes reinstate, split, and replaced line status. This shows quantity in primary and transaction UOM.
Requisition Count	Count of distinct requisitions.
Requisition Line Count	Count of requisition lines excluding reinstate, split, and replaced line status.
Rejected Requisition Count	Count of distinct requisition with rejected status.
Rejected Requisition Lines Count	Count of requisition lines with rejected status and excludes reinstate, split, and replaced line status.
Pending Approval Requisition Lines Count	Count of requisition lines with pending approval status and excludes reinstate, split, and replaced line status.
Unprocessed Requisition Lines Count	Count of requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Approved Requisition Lines Count	Count of requisition lines with approved status and excludes reinstate, split, and replaced line status.
Processed Requisition Lines Count	Count of requisition lines which got converted to purchase order and purchase order header having processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Requisition Lines Count	Count of requisition lines for which purchase order got processed and has purchase order line fulfilled flag value as N. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Overdue Requisition %	This metric shows Unfulfilled Overdue Requisition Amount percentage of the overall Requisition Amount for a given period.
Fulfilled Requisition Lines Count	Count of requisition lines for which purchase order got processed and has purchase order line fulfilled flag value as Y. Purchase order line fulfilled flag will have value as Y only when all the schedule lines for that purchase order line is closed for receiving or invoicing. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Requisition Approval Cycle Time Days	This metric is calculated as average difference between requisition approval date and requisition submitted date for version zero.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval date. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Fulfilled Cycle Time Days	This metric is calculated as average difference between purchase order line fulfill date and requisition line last submitted date. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Requisition Approval to PO Fulfillment Time	This metric is calculated as average difference between purchase order line fulfill date and requisition line last approval date. And fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split and replaced line status.
Unprocessed Average Aging Days	This metric is calculated as average difference between system date and requisition line last approval date for requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status. .
Requisition Amount	This metric is calculated as sum of amount at distribution level and excludes reinstate, split, and replaced line status.
Unprocessed Overdue Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unprocessed status and crossed the requested delivery date and the unprocessed status requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Approved Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with approved status. This metrics excludes reinstate, split, and replaced line status.
Processed Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with processed status. The processed status requisition lines are those that got converted to purchase order and purchase order header having processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unfulfilled status. The unfulfilled status requisition lines are those purchase orders that got processed and have purchase order line fulfilled flag value as N. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Overdue Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unfulfilled status and crossed the requested delivery date. The unfulfilled status requisition lines are those purchase orders that got processed and has purchase order line fulfilled flag value as N. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Fulfilled Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with fulfilled status. The fulfilled status requisition lines are those that have purchase order line fulfilled flag value as Y. Purchase order line fulfilled flag will have value as Y only when all the schedule lines for that purchase order line is closed for receiving or invoicing. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Requisition Primary Quantity	This metric is calculated as sum of quantity at distribution level and excludes reinstate, split and replaced line status. This shows quantity in primary UOM.
Requisition Amount – Without cancelled	This metric is calculated as sum of amount at distribution level and excludes cancelled, reinstate, split, and replaced line status.
Requisition Amount - Parent Reinstate Line	This metric is calculated as sum of amount at distribution level and includes parent reinstate and excludes cancelled, split, and replaced line status.
Requisition Quantity - With Reinstate Line	This metric is calculated as sum of quantity at distribution level and includes parent reinstate and cancelled, but excludes split and replaced line status.
Requisition Line Count - With Reinstate Line	Count of requisition lines excluding split and replaced line status.
Requisition Quantity - Without Cancelled	This metric is calculated as sum of quantity at distribution level and excludes Cancelled , reinstate, split and replaced line status.

Procurement—Spend

These metrics are used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder, and Document Currency (DC) fact folder in the Subject Areas.

Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Expense Distribution accounting date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies. Currently only accounted invoices are supported.

Metric	Metric Definition
Quantity Invoiced	This metric is calculated as the sum of Quantity Invoiced from Invoice distributions in primary and transaction UOM.
Invoice Amount	This metric is calculated as Sum of Amounts from the Invoice Accounting distribution lines for an invoice distribution.
Avg Invoice Unit Price	This metric is calculated as Sum of Invoice Amounts divided by Sum of Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend.
Max Invoice Unit Price	This metric is calculated as Maximum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend.
Min Invoice Unit Price	This metric is calculated as Minimum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend.
Spend	This metric is calculated as Sum of Invoice Amounts where invoice is approved and invoice distribution is validated. This metric excludes Invoice Distributions for withholding tax invoices and lines, prepayment invoices, and prepayment application lines.
Addressable Spend	This metric is calculated as Sum of 'Spend' where Invoice Distribution Types are Accrual, Item, Exchange Rate Variance, Invoice Price Variance, Retainage and Retro Active Price Accrual.
PO Matched Spend	This metric is calculated as the sum of Invoice Amounts, where Invoice distributions has a Purchase Order Reference.
Agreement Spend	This metric is calculated as the sum of Spend, where Invoice Distributions has a Purchase Order reference, and the corresponding Purchase Order Line has a Blanket Purchase Agreement or Contract Purchase Agreement reference.
Non Agreement Spend	This metric is calculated as the sum of Spend where Invoice Distributions has a Purchase Order reference, and Purchase Order Line does not have a Blanket Purchase Agreement or Contract Purchase agreement reference.
Agreement Leakage Spend	This metric is calculated as the sum of Spend where Invoice Distributions has a Purchase Order reference, and the Purchase Order Line does not have an agreement associated with it, although an open Blanket agreement is available for the item in Purchase order. This metric works only for Inventory Item-based purchase orders.
Other Non Agreement Spend	This metric is calculated as Non Agreement Spend minus Agreement Leakage Spend.
Negotiated Spend	This metric is calculated as PO Matched Spend where the Negotiated Flag is checked for the corresponding Purchase Orders Lines.
Non Negotiated Spend	This metric is calculated as PO Matched Spend where the Negotiated Flag is not checked for the corresponding Purchase Orders Lines.
Average Spend Per invoice	This metric is calculated as the sum of Spend divided by the Count of Spend Invoices.
Electronic Invoices Count	This metric is calculated as the Count of Distinct Invoice Headers where Invoice Header source is not equal to Manual Invoice Entry.
Invoice Lines Count	This metric is calculated as the Count of Distinct invoice Lines.
Invoices Count	This metric is calculated as the Count of Distinct invoice Headers.
Purchase Order Lines Count	This metric is calculated as the Count of Distinct Purchase Order Lines referenced in Invoice Distributions.
Purchase Orders Count	This metric is calculated as the Count of Distinct Purchase Order Headers referenced in Invoice Distributions.
Manual Invoices Count	This metric is calculated as the Count of Distinct Invoice Headers where Invoice Header source is equal to Manual Invoice Entry.
Suppliers Count	This metric is calculated as the Count of Distinct Suppliers on Invoice Headers.
PO Matched Invoices Count	This metric is calculated as the Count of Distinct invoices headers which are fully or partially matched to the purchase order.
Invoices Before PO Creation Count	This metric is calculated as the Count of invoice Headers where Invoice date is greater than the purchase order Creation date.
Paid Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is already paid.
Open Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is not paid yet.
Perfect Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is partially or fully matched to Purchase Order with no price variance.
Invoices with IPV Count	This metric is calculated as Count of Distinct Invoice headers where invoices have more than one distribution line status in Invoice Price Variance or Tax Invoice Price Variance.
Buyer Count	This metric is calculated as Distinct Buyers on Invoice Headers.
Supplier Site Count	This metric is calculated as Count of Distinct Supplier Sites on Invoice Headers.
Payables Invoicing Business Unit Count	This metric is calculated as distinct count of Payables Invoicing Business Units on Invoice Headers.
Purchasing Category Count	This metric is calculated as Count of Distinct Purchasing Category on Invoice Lines.
Payment Terms Count	This metric is calculated as Count of Distinct Payment Terms on Invoice Headers.
Item Based Purchases %	This metric is calculated as the percentage of Distinct Count of item-based Purchase Order Lines over Distinct Count of Purchase Order Lines.
PO Matched Spend %	This metric is calculated as percentage of PO Matched Spend over Spend.
Non PO Matched Spend %	This metric is calculated as percentage of Non PO Matched Spend over Spend.
Agreement Spend %	This metric is calculated as percentage of Agreement Spend over Spend.
Non Agreement Spend %	This metric is calculated as percentage of Non Agreement Spend over Spend.
Agreement Leakage Spend %	This metric is calculated as percentage of Agreement Leakage Spend over Spend.
Negotiated Spend %	This metric is calculated as percentage of Negotiated Spend over Spend.
Supplier Spend %	This metric is calculated as percentage of Spend over Spend across all suppliers. This metric is used to analyze individual supplier Spend against Spend across all suppliers.
Category Spend %	This metric is calculated as percentage of Spend over Spend across all categories. This metric is used to analyze individual category Spend against Spend across all categories.
Invoice Price Variance	This metric is calculated as sum of amounts from Invoice distribution for Distribution Line status Invoice Price Variance.
Primary Quantity Invoiced	This metric is calculated as Sum of Quantity Invoiced from Invoice distributions in primary UOM.
Avg Invoice Unit Price (Primary UOM)	This metric is calculated as Sum of Invoice Amounts divided by Sum of Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend in primary UOM.
Max Invoice Unit Price (Primary UOM)	This metric is calculated as Maximum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend in primary UOM.
Min Invoice Unit Price (Primary UOM)	This metric is calculated as Minimum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend in primary UOM.
Other Non-Agreement Spend %	This metric is calculated as the percentage of other non agreement spend amount over spend amount.
Addressable Spend %	This metric is calculated as percentage of Addressable Spend over Spend.
Category Non Agreement Spend %	This metric is calculated as percentage of Non Agreement Spend over Non Agreement Spend across all categories. This metric is used to analyze individual category Non Agreement Spend against Non Agreement Spend across all categories.
Agreement Leakage to PO Spend %	This metric is calculated as the percentage of agreement leakage amount over PO matched spend amount.
Non Agreement to PO Spend %	This metric is calculated as the percentage of non agreement amount over PO matched spend amount.

Projects

These tables describe Projects metrics.

PPM - Grants Award Funding (Preview)

These metrics are used in the Award Currency fact folder in Subject Area. Award Currency and Project Currency are the same.

Metric	Metric Definition
Direct Funding Amount	Shows the funding amount for direct costs granted by Sponsor.
Indirect Funding Amount	Shows the funding amount for indirect costs granted by Sponsor.
Total Funding Amount	Total funding amount is sum of direct and indirect funding amount.
Unallocated Funding Amount	Unallocated funding amount is the amount not allocated to any project within the award.
Organization Credit Amount	Organization Credit amount is the portion of funding amount that Organization receives based on the credit percentage assigned to the organization. Total Funding Amount is used for Award level assignment and Project Funding Amount for Project Level Assignment.
Personnel Credit Amount	Personnel Credit amount is the portion of funding amount a person receives based on the credit percentage assigned to the person. Total Funding Amount is used for Award level assignment and Project Funding Amount for Project Level Assignment.
Project Funding Amount	Project Funding amount is the amount allocated to the project within the award.
Project Budget Amount	Current Approved Budget Burdened Cost in Project Currency from Project Budget Fact. This metric will be available only if Project Costing, Commitments and Project Controls functional areas are activated.
Project Commitment Amount	Commitment Amount in Project Currency from Project Commitment fact. This metric will be available only if Project Costing, Commitments and Project Controls functional areas are activated.
Project Actual Amount	Burdened Cost in Project Currency from Project Costs fact. This metric will be available only if Project Costing, Commitments and Project Controls functional areas are activated.
Project Unbudgeted Amount	Project Unbudgeted Amount is calculated as Project Funding Amount - Project Budget Amount. This metric will be available only if Project Costing, Commitments and Project Controls functional areas are activated.
Consumed Amount	Consumed amount will be calculated only for the current budget period. For Restricted Authority, consumed amount is the sum of project actual amount and project commitment amount for the current budget period. For Expanded Authority, consumed amount is the sum of project actual amount and project commitment amount since inception till the current budget period. This metric will be available only if Project Costing, Commitments, and Project Controls functional areas are activated.
Remaining Amount	Remaining Amount is calculated as (Consumed Amount / Elapsed Days) * Remaining Days. This will be displayed only for the current budget period both for the enhanced authority and restricted authority awards. This metric will be available only if Project Costing, Commitments, and Project Controls functional areas are activated.
Elapsed Days	Elapsed Days is calculated as Current Date - Start Date, where Start date is the award start date in awards that are enabled for expanded authority awards. For restricted authority awards, the start date is the current budget period start date. This metric is calculated only for the current budget period.
Remaining Days	Remaining Days is calculated as Current Budget Period End date - Current Date. This metric is calculated only for the current budget period for both enhanced and restricted authority awards.
Burn Rate	Burn Rate is calculated as (Consumed Amount + Remaining Amount) / Budget Amount in Percentage. This metric is calculated only for the current budget period. For Enhanced authority the budget amount is the ITD budget amount till the current budget period. For Restricted authority the budget amount is the current period budget amount. This metric will be available only if Project Costing, Commitments, and Project Controls functional areas are activated.

PPM - Project Assets (Preview)

These metrics will be used in the Ledger Currency (LC) fact folder in Subject Area.

Metric	Metric Definition
Raw Cost	Shows the Actual Raw Cost incurred.
Burden Cost	Shows the Actual Burden Cost calculated as difference between Burdened Cost and Raw Cost.
Burdened Cost	Shows the Actual Burdened Cost incurred.
Capitalizable Cost	Shows the Raw cost or Burdened Cost from Cost distribution lines flagged as Capitalizable based on whether Raw or Burdened Cost is Capitalizable for the project type.
Non-Capitalizable Cost	Shows the Actual Burdened Cost from Cost Distribution lines flagged as not Capitalizable for Capitalizable projects.
Total Asset Cost	Shows the Total Asset Cost.
Estimated Asset Cost	Shows the Estimated Asset Cost.
Capitalized Cost	Shows the Capitalized Cost that is the cost transferred to Fixed Assets module.
Grouped CIP Cost	Shows the Grouped CIP Cost that is the cost grouped to create Asset lines but not transferred to Fixed Assets.
Assigned CIP Cost	Shows the Assigned CIP Cost that is the cost grouped to create Assets lines and assigned to Asset but not transferred to Fixed Assets.
Unassigned CIP Cost	Shows the Unassigned CIP Cost that is the cost grouped to create Assets lines but not assigned to Asset and not transferred to Fixed Assets.
Rejected CIP Cost	Shows the Rejected CIP Cost that is the cost grouped to create Assets lines but rejected during transfer to Fixed Assets.
Grouped Cost	Shows the Grouped Cost that is the cost grouped to create Asset lines.
Original Amount	Shows the Original Amount from Asset Lines.
Current Amount	Shows the Current Amount from Asset Lines.
Actual Asset Units	Shows the Actual Asset Units assigned to the Asset.
Estimated Asset Units	Shows the Estimated Asset Units.
Quantity	Number of units related to an expenditure item.

PPM - Project Budgets

These metrics are used in the Analytics Currency (AC), Document Currency (DC), Project Currency (PC), and Project Ledger Currency (PLC) fact folders in subject areas. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis uses project ledger currency conversion rate date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Budget Quantity	Budget quantity of any baselined budget version.
Budget Labor Effort	Labor effort for any baselined budget version.
Budget Equipment Effort	Equipment effort for any baselined budget version.
BAC Quantity	Budget at completion quantity of any baselined budget.
BAC Labor Effort	Budget at completion labor effort for any baselined budget version.
BAC Equipment Effort	Budget at completion equipment effort of any baselined budget version.
Budget Quantity - ITD	Inception-to-date budget quantity of any baselined budget version calculated using the receiver fiscal calendar.
Budget Quantity - YTD	Year-to-date budget quantity of any baselined budget version calculated using the receiver fiscal calendar.
Budget Quantity - QTD	Quarter-to-date budget quantity of any baselined budget version calculated using the receiver fiscal calendar.
Budget Quantity - PTD	Period-to-date budget quantity of any baselined budget version.
Current Budget Quantity	Budget quantity of approved baselined budget version flagged as current.
Current Budget Labor Effort	Labor effort for approved baselined budget version flagged as current.
Current Budget Equipment Effort	Equipment effort for approved baselined budget version flagged as current.
Current BAC Quantity	Budget at completion quantity of approved baselined budget version flagged as current.
Current BAC Labor Effort	Budget at completion labor effort for approved baselined budget version flagged as current.
Current BAC Equipment Effort	Budget at completion equipment effort of approved baselined budget version flagged as current.
Current Budget Quantity - ITD	Inception-to-date budget quantity of approved baselined budget version flagged as current calculated using the receiver fiscal calendar.
Current Budget Quantity - YTD	Year-to-date budget quantity of approved baselined budget version flagged as current calculated using the receiver fiscal calendar.
Current Budget Quantity - QTD	Quarter-to-date budget quantity of approved baselined budget version flagged as current calculated using the receiver fiscal calendar.
Current Budget Quantity - PTD	Period-to-date budget quantity of approved baselined budget version flagged as current calculated using the receiver fiscal calendar.
Original Budget Quantity	Budget quantity of approved baselined budget version flagged as original.
Original Budget Labor Effort	Labor effort for approved baselined budget version flagged as original.
Original Budget Equipment Effort	Equipment effort for approved baselined budget version flagged as original.
Original BAC Quantity	Budget at completion quantity of approved baselined budget version flagged as original.
Original BAC Labor Effort	Budget at completion labor effort for approved baselined budget version flagged as original.
Original BAC Equipment Effort	Budget at completion equipment effort of approved baselined budget version flagged as original.
Original Budget Quantity - ITD	Inception-to-date budget quantity of approved baselined budget version flagged as original calculated using the receiver fiscal calendar.
Original Budget Quantity - YTD	Year-to-date budget quantity of approved baselined budget version flagged as original calculated using the receiver fiscal calendar.
Original Budget Quantity - QTD	Quarter-to-date budget quantity of approved baselined budget version flagged as original calculated using the receiver fiscal calendar.
Original Budget Quantity - PTD	Period-to-date budget quantity of approved baselined budget version flagged as original calculated using the receiver fiscal calendar.
Budget Raw Cost	Raw cost of any baselined budget version.
Budget Burdened Cost	Burdened cost of any baselined budget version.
Budget Revenue	Budget revenue of any baselined budget version.
Budget Margin	Budget margin of any baselined budget version.
Budget Margin Percentage	Margin percentage of any baselined budget version.
BAC Raw Cost	Budget at completion raw cost of any baselined budget version.
BAC Burdened Cost	Budget at completion burdened cost of any baselined budget version.
BAC Revenue	Budget at completion revenue of any baselined budget version.
BAC Margin	Budget at completion margin of any baselined budget version.
BAC Margin Percentage	Budget at completion margin percentage of any baselined budget version.
Current Budget Raw Cost	Raw cost of baselined budget version flagged as current.
Current Budget Burdened Cost	Burdened cost of baselined budget version flagged as current.
Current Budget Revenue	Budget revenue of baselined budget version flagged as current.
Current Budget Margin	Budget margin of baselined budget version flagged as current.
Current Budget Margin Percentage	Margin percentage of baselined budget version flagged as current.
Current BAC Raw Cost	Budget at completion raw cost of baselined budget version flagged as current.
Current BAC Burdened Cost	Budget at completion burdened cost of baselined budget version flagged as current.
Current BAC Revenue	Budget at completion revenue of baselined budget version flagged as current.
Current BAC Margin	Budget at completion margin of baselined budget version flagged as current.
Current BAC Margin Percentage	Budget at completion margin percentage of baselined budget version flagged as current.
Original Budget Raw Cost	Raw cost of baselined budget version flagged as original.
Original Budget Burdened Cost	Burdened cost of baselined budget version flagged as original.
Original Budget Revenue	Budget revenue of baselined budget version flagged as original.
Original Budget Margin	Budget margin of baselined budget version flagged as original.
Original Budget Margin Percentage	Margin percentage of baselined budget version flagged as original.
Original BAC Raw Cost	Budget at completion raw cost of baselined budget version flagged as original.
Original BAC Burdened Cost	Budget at completion burdened cost of baselined budget version flagged as original.
Original BAC Revenue	Budget at completion revenue of baselined budget version flagged as original.
Original BAC Margin	Budget at completion margin of baselined budget version flagged as original.
Original BAC Margin Percentage	Budget at completion margin percentage of baselined budget version flagged as original.
Current Versus Original BAC Raw Cost Variance	Variance between current and original approved budget at completion raw cost amount.
Current Versus Original BAC Burdened Cost Variance	Variance between current and original approved budget at completion burdened cost amount.
Current Versus Original BAC Revenue Variance	Variance between current and original approved budget at completion revenue amount.
Current Versus Original BAC Margin Variance	Variance between current and original approved budget at completion margin.
Current Versus Original BAC Margin Percentage Variance	Variance between current and original approved budget at completion margin percentage.
Budget Raw Cost - ITD	Inception-to-date raw cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Burdened Cost - ITD	Inception-to-date burdened cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Revenue - ITD	Inception-to-date budget revenue of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin - ITD	Inception-to-date budget margin of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin Percentage - ITD	Inception-to-date margin percentage of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Raw Cost - ITD	Inception-to-date raw cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Burdened Cost - ITD	Inception-to-date burdened cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Revenue - ITD	Inception-to-date budget revenue of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin - ITD	Inception-to-date budget margin of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin Percentage - ITD	Inception-to-date margin percentage of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Raw Cost - ITD	Inception-to-date raw cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Burdened Cost - ITD	Inception-to-date burdened cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Revenue - ITD	Inception-to-date budget revenue of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin - ITD	Inception-to-date budget margin of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin Percentage - ITD	Inception-to-date margin percentage of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Raw Cost - YTD	Year-to-date raw cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Burdened Cost - YTD	Year-to-date burdened cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Revenue - YTD	Year-to-date budget revenue of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin - YTD	Year-to-date budget margin of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin Percentage - YTD	Year-to-date margin percentage of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Raw Cost - YTD	Year-to-date raw cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Burdened Cost - YTD	Year-to-date burdened cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Revenue - YTD	Year-to-date budget revenue of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin - YTD	Year-to-date budget margin of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin Percentage - YTD	Year-to-date margin percentage of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Revenue - YTD	Year-to-date raw cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Raw Cost - YTD	Year-to-date burdened cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Burdened Cost - YTD	Year-to-date budget revenue of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin - YTD	Year-to-date budget margin of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin Percentage - YTD	Year-to-date margin percentage of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Raw Cost - QTD	Quarter-to-date raw cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Burdened Cost - QTD	Quarter-to-date burdened cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Revenue - QTD	Quarter-to-date budget revenue of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin - QTD	Quarter-to-date budget margin of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin Percentage - QTD	Quarter-to-date margin percentage of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Raw Cost - QTD	Quarter-to-date raw cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Burdened Cost - QTD	Quarter-to-date burdened cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Revenue - QTD	Quarter-to-date budget revenue of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin - QTD	Quarter-to-date budget margin of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin Percentage - QTD	Quarter-to-date margin percentage of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Revenue - QTD	Quarter-to-date raw cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Raw Cost - QTD	Quarter-to-date burdened cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Burdened Cost - QTD	Quarter-to-date budget revenue of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin - QTD	Quarter-to-date budget margin of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin Percentage - QTD	Quarter-to-date margin percentage of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Raw Cost - PTD	Period-to-date raw cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Burdened Cost - PTD	Period-to-date burdened cost of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Revenue - PTD	Period-to-date budget revenue of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin - PTD	Period-to-date budget margin of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Budget Margin Percentage - PTD	Period-to-date margin percentage of any baselined budget version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Raw Cost - PTD	Period-to-date raw cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Burdened Cost - PTD	Period-to-date burdened cost of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Revenue - PTD	Period-to-date budget revenue of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin - PTD	Period-to-date budget margin of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Budget Margin Percentage - PTD	Period-to-date margin percentage of baselined budget version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Revenue - PTD	Period-to-date raw cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Raw Cost - PTD	Period-to-date burdened cost of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Burdened Cost - PTD	Period-to-date budget revenue of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin - PTD	Period-to-date budget margin of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Budget Margin Percentage - PTD	Period-to-date margin percentage of baselined budget version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.

PPM - Project Commitments

These metrics will be used in the Analytics Currency (AC), Document Currency (DC), Project Currency (PC), Project Ledger Currency (PLC) and Ledger Currency (LC) fact folder in Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Ledger Currency Conversion Rate Date if this date is populated and if not available uses expenditure item date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Canceled Amount	Shows the Canceled amount from the commitment transaction. This metric is available only in document currency.
Canceled Quantity	Total number of units canceled in the commitment transaction.
Committed Burden Cost	Shows the burden cost of the commitment transaction.
Committed Burdened Cost	Shows the burdened cost of the commitment transaction.
Committed Raw Cost	Shows the raw cost of the commitment transaction.
Delivered Amount	Shows the Delivered amount from the commitment transaction. This metric is available only in document currency.
Delivered Quantity	Total number of units delivered in the commitment transaction.
External Committed Burdened Cost	Shows the burdened cost of external commitment transactions.
External Committed Raw Cost	Shows the raw cost of external commitment transactions.
Invoiced Amount	Shows the invoiced amount from the commitment transaction. This metric is available only in document currency.
Invoiced Quantity	Total number of units invoiced in the commitment transaction.
Ordered Amount	Shows the ordered amount from the commitment transaction. This metric is available only in document currency.
Ordered Quantity	Total number of units ordered in the commitment transaction.
Original Ordered Amount	Shows the original ordered amount from the commitment transaction. This metric is available only in document currency.
Original Ordered Quantity	Total number of units originally ordered in the commitment transaction.
Outstanding Delivery Amount	Shows the outstanding Delivery amount from the commitment transaction. This metric is available only in document currency.
Outstanding Delivery Quantity	Total number of units to be delivered in the commitment transaction.
Outstanding Invoice Amount	Shows the outstanding invoice amount from the commitment transaction. This metric is available only in document currency.
Outstanding Invoice Quantity	Total number of units yet to be invoiced in the commitment transaction.
Overbilled Amount	Shows the overbilled amount from the commitment transaction. This metric is available only in document currency.
Overbilled Quantity	Total number of units overbilled in the commitment transaction.
Purchase Order Committed Burdened Cost	Shows the purchase order burdened cost.
Purchase Order Committed Raw Cost	Shows the purchase order raw cost.
Quantity	Total number of units committed.
Requisition Committed Burdened Cost	Shows the purchase requisition burdened cost.
Requisition Committed Raw Cost	Shows the purchase requisition raw cost.
Supplier Invoice Committed Burdened Cost	Shows the supplier invoice burdened cost.
Supplier Invoice Committed Raw Cost	Shows the supplier invoice raw cost.
Transfer Order Committed Burdened Cost	Shows the transfer order burdened cost.
Transfer Order Committed Raw Cost	Shows the transfer order raw cost.

PPM - Project Costs

Metric	Metric Definition
Accounted Burden Cost	Shows the burden cost amount that is accounted. This metric is available in ledger currency, document currency, and analytic currency only.
Accounted Burdened Cost	Shows the burdened cost amount that is accounted. This metric is available in ledger currency, document currency, and analytic currency only.
Accounted Raw Cost	Shows the raw cost amount that is accounted. This metric is available in ledger currency, document currency, and analytic currency only.
Billable and Capitalizable Burden Cost	Shows the billable and capitalizable burden cost calculated as difference between billable and capitalizable burdened cost.
Billable and Capitalizable Burden Cost - ITD	Cumulative sum of billable and capitalizable burden cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Burden Cost - PTD	Period-to-date billable and capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Burden Cost - QTD	Quarter-to-date billable and capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Burden Cost - YTD	Year-to-date billable and capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Cost	Shows the raw cost or burdened cost from cost distribution lines flagged as capitalizable and billable based on whether raw or burdened cost is capitalizable for the project type.
Billable and Capitalizable Cost - ITD	Cumulative sum of billable and capitalizable burdened cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Cost - PTD	Period-to-date billable and capitalizable burdened cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Cost - QTD	Quarter-to-date billable and capitalizable burdened cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Cost - YTD	Year-to-date billable and capitalizable burdened cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Raw Cost	Shows the actual raw cost from cost distribution lines flagged as both billable and capitalizable.
Billable and Capitalizable Raw Cost - ITD	Cumulative sum of billable and capitalizable raw cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Raw Cost - PTD	Period-to-date billable and capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Raw Cost - QTD	Quarter-to-date billable and capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable and Capitalizable Raw Cost - YTD	Year-to-date billable and capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Burden Cost	Shows the billable burden cost calculated as difference between billable cost and billable raw cost.
Billable Burden Cost - ITD	Cumulative sum of billable burden cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Burden Cost - PTD	Period-to-date billable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Burden Cost - QTD	Quarter-to-date billable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Burden Cost - YTD	Year-to-date billable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency. only.
Billable Cost	Shows the actual burdened cost from cost distribution lines flagged as billable.
Billable Cost - ITD	Cumulative sum of billable burdened cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Cost - PTD	Period-to-date billable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Cost - QTD	Quarter-to-date billable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Cost - YTD	Year-to-date billable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Raw Cost	Shows the actual raw cost from cost distribution lines flagged as billable.
Billable Raw Cost - ITD	Cumulative sum of billable raw cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Raw Cost - PTD	Period-to-date billable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Raw Cost - QTD	Quarter-to-date billable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Billable Raw Cost - YTD	Year-to-date billable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burden Cost	Shows the actual burden cost calculated as difference between burdened cost and raw cost.
Burden Cost - ITD	Cumulative sum of burden cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burden Cost - PTD	Period-to-date burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burden Cost - QTD	Quarter-to-date burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burden Cost - YTD	Year-to-date burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burdened Cost	Shows the actual burdened cost incurred.
Burdened Cost - ITD	Cumulative sum of burdened cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burdened Cost - PTD	Period-to-date burdened cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burdened Cost - QTD	Quarter-to-date burdened cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Burdened Cost - YTD	Year-to-date burdened cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Burden Cost	Shows the capitalizable burden cost calculated as difference between capitalizable cost and capitalizable raw cost.
Capitalizable Burden Cost - ITD	Cumulative sum of capitalizable burden cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Burden Cost - PTD	Period-to-date capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Burden Cost - QTD	Quarter-to-date capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Burden Cost - YTD	Year-to-date capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Cost	Shows the raw cost or burdened cost from cost distribution lines flagged as capitalizable based on whether raw or burdened cost is capitalizable for the project type.
Capitalizable Cost - ITD	Cumulative sum of capitalizable burdened cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Cost - PTD	Period-to-date capitalizable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Cost - QTD	Quarter-to-date capitalizable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Cost - YTD	Year-to-date capitalizable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Raw Cost	Shows the actual raw cost from cost distribution lines flagged as capitalizable for capitalizable projects.
Capitalizable Raw Cost - ITD	Cumulative sum of capitalizable raw cost from start of the project to the reporting time period selected.
Capitalizable Raw Cost - PTD	Period-to-date capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Raw Cost - QTD	Quarter-to-date capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Capitalizable Raw Cost - YTD	Year-to-date capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Credit Amount	Shows the credit amount from accounting for the cost distribution line. This metric is available in ledger currency, document currency, and analytic currency only.
Debit Amount	Shows the debit amount from accounting for the cost distribution line. This metric is available in ledger currency, document currency, and analytic currency only.
Equipment Cost	Shows the equipment cost calculated as burdened cost that is associated with resource class EQUIPMENT.
Equipment Cost - ITD	Cumulative sum of equipment cost is calculated as burdened cost that is associated with resource class EQUIPMENT from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Equipment Cost - PTD	Period-to-date equipment cost is calculated as burdened cost that is associated with resource class EQUIPMENT calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Equipment Cost - QTD	Quarter-to-date equipment cost is calculated as burdened cost that is associated with resource class EQUIPMENT calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Equipment Cost - YTD	Year-to-date equipment cost is calculated as burdened cost that is associated with resource class EQUIPMENT calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Equipment Effort	Number of units of equipment used.
Equipment Effort - ITD	Cumulative sum of units of equipment used from start of the project to the reporting time period selected calculated using the receiver fiscal calendar.
Equipment Effort - PTD	Period-to-date number of units of equipment used calculated using the receiver fiscal calendar.
Equipment Effort - QTD	Quarter-to-date number of units of equipment used calculated using the receiver fiscal calendar.
Equipment Effort - YTD	Year-to-date number of units of equipment used calculated using the receiver fiscal calendar.
Labor Cost	Shows the labor cost calculated as burdened cost that is associated with resource class PEOPLE.
Labor Cost - ITD	Cumulative sum of labor cost is calculated as burdened cost that is associated with resource class PEOPLE from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Labor Cost - PTD	Period-to-date labor cost is calculated as burdened cost that is associated with resource class PEOPLE calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Labor Cost - QTD	Quarter-to-date labor cost is calculated as burdened cost that is associated with resource class PEOPLE calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Labor Cost - YTD	Year-to-date labor cost is calculated as burdened cost that is associated with resource class PEOPLE calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Labor Effort	Number of labor units related to an expenditure item.
Labor Effort - ITD	Cumulative sum of labor units from start of the project to the reporting time period selected calculated using the receiver fiscal calendar.
Labor Effort - PTD	Period-to-date number of labor units related to an expenditure item calculated using the receiver fiscal calendar.
Labor Effort - QTD	Quarter-to-date number of labor units related to an expenditure item calculated using the receiver fiscal calendar.
Labor Effort - YTD	Year-to-date number of labor units related to an expenditure item calculated using the receiver fiscal calendar.
Net Amount	Shows the difference between debit amount and credit amount. This metric is available in ledger currency, document currency, and analytic currency only.
Non-Billable Burden Cost	Shows the non-billable burden cost calculated as difference between non-billable cost and non-billable raw cost.
Non-Billable Burden Cost - ITD	Cumulative sum of non-billable burden cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Burden Cost - PTD	Period-to-date non-billable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Burden Cost - QTD	Quarter-to-date non-billable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Burden Cost - YTD	Year-to-date non-billable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Cost	Shows the actual burdened cost from cost distribution lines flagged as not billable.
Non-Billable Cost - ITD	Cumulative sum of non-billable burdened cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Cost - PTD	Period-to-date non-billable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Cost - QTD	Quarter-to-date non-billable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Cost - YTD	Year-to-date non-billable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Raw Cost	Shows the actual raw cost from cost distribution lines flagged as not billable.
Non-Billable Raw Cost - ITD	Cumulative sum of non-billable raw cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Raw Cost - PTD	Period-to-date non-billable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Raw Cost - QTD	Quarter-to-date non-billable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Billable Raw Cost - YTD	Year-to-date non-billable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Burden Cost	Shows the non-capitalizable burden cost calculated as difference between non-capitalizable cost and non-capitalizable raw cost.
Non-Capitalizable Burden Cost - ITD	Cumulative sum of non-capitalizable burden cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Burden Cost - PTD	Period-to-date non-capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Burden Cost - QTD	Quarter-to-date non-capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Burden Cost - YTD	Year-to-date non-capitalizable burden cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Cost	Shows the actual burdened cost from cost distribution lines flagged as not capitalizable for capitalizable projects.
Non-Capitalizable Cost - ITD	Cumulative sum of non-capitalizable burdened cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Cost - PTD	Period-to-date non-capitalizable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Cost - QTD	Quarter-to-date non-capitalizable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Cost - YTD	Year-to-date non-capitalizable cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Raw Cost	Shows the actual raw cost from cost distribution lines flagged as not capitalizable for capitalizable projects.
Non-Capitalizable Raw Cost - ITD	Cumulative sum of non-capitalizable raw cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Raw Cost - PTD	Period-to-date non-capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Raw Cost - QTD	Quarter-to-date non-capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Non-Capitalizable Raw Cost - YTD	Year-to-date non-capitalizable raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Projects Count	Distinct count of projects with cost distribution lines.
Quantity	Number of units related to an expenditure item.
Raw Cost	Shows the actual raw cost incurred.
Raw Cost - ITD	Cumulative sum of raw cost from start of the project to the reporting time period selected calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Raw Cost - PTD	Period-to-date raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Raw Cost - QTD	Quarter-to-date raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Raw Cost - YTD	Year-to-date raw cost calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Tasks Count	Distinct count of tasks with cost distribution lines.
Transfer Price Amount	Shows the amount charged by provider organization to the receiver organization including transfer price markup.
Unaccounted CDL Count	Count of cost distribution lines that are not accounted.

PPM - Project Forecasts

Metric	Metric Definition
Actual Raw Cost	Actual raw cost of any baselined forecast version.
Actual Burdened Cost	Actual burdened cost of any baselined forecast version.
Actual Revenue	Actual revenue of any baselined forecast version.
Actual Margin	Actual margin of any baselined forecast version.
Actual Margin Percentage	Actual margin percentage of any baselined forecast version.
ETC Raw Cost	Estimate to complete raw cost of any baselined forecast version.
ETC Burdened Cost	Estimate to complete burdened cost of any baselined forecast version.
ETC Revenue	Estimate to complete revenue of any baselined forecast version.
ETC Margin	Estimate to complete margin of any baselined forecast version.
ETC Margin Percentage	Estimate to complete margin percentage of any baselined forecast version.
EAC Raw Cost	Estimate at completion raw cost of any baselined forecast version.
EAC Burdened Cost	Estimate at completion burdened cost of any baselined forecast version.
EAC Revenue	Estimate at completion revenue of any baselined forecast version.
EAC Margin	Estimate at completion margin of any baselined forecast version.
EAC Margin Percentage	Estimate at completion margin percentage of any baselined forecast version.
Current Actual Raw Cost	Actual raw cost of primary baselined forecast version flagged as current.
Current Actual Burdened Cost	Actual burdened cost of primary baselined forecast version flagged as current.
Current Actual Revenue	Actual revenue of primary baselined forecast version flagged as current.
Current Actual Margin	Actual margin of primary baselined forecast version flagged as current.
Current Actual Margin Percentage	Actual margin percentage of primary baselined forecast version flagged as current.
Current ETC Raw Cost	Estimate to complete raw cost of primary baselined forecast version flagged as current.
Current ETC Burdened Cost	Estimate to complete burdened cost of primary baselined forecast version flagged as current.
Current ETC Revenue	Estimate to complete revenue of primary baselined forecast version flagged as current.
Current ETC Margin	Estimate to complete margin of primary baselined forecast version flagged as current.
Current ETC Margin Percentage	Estimate to complete margin percentage of primary baselined forecast version flagged as current.
Current EAC Raw Cost	Estimate at completion raw cost of primary baselined forecast version flagged as current.
Current EAC Burdened Cost	Estimate at completion burdened cost of primary baselined forecast version flagged as current.
Current EAC Revenue	Estimate at completion revenue of primary baselined forecast version flagged as current.
Current EAC Margin	Estimate at completion margin of primary baselined forecast version flagged as current.
Current EAC Margin Percentage	Estimate at completion margin percentage of primary baselined forecast version flagged as current.
Original Actual Raw Cost	Actual raw cost of primary baselined forecast version flagged as original.
Original Actual Burdened Cost	Actual burdened cost of primary baselined forecast version flagged as original.
Original Actual Revenue	Actual revenue of primary baselined forecast version flagged as original.
Original Actual Margin	Actual margin of primary baselined forecast version flagged as original.
Original Actual Margin Percentage	Actual margin percentage of primary baselined forecast version flagged as original.
Original ETC Raw Cost	Estimate to complete raw cost of primary baselined forecast version flagged as original.
Original ETC Burdened Cost	Estimate to complete burdened cost of primary baselined forecast version flagged as original.
Original ETC Revenue	Estimate to complete revenue of primary baselined forecast version flagged as original.
Original ETC Margin	Estimate to complete margin of primary baselined forecast version flagged as original.
Original ETC Margin Percentage	Estimate to complete margin percentage of primary baselined forecast version flagged as original.
Original EAC Raw Cost	Estimate at completion raw cost of primary baselined forecast version flagged as original.
Original EAC Burdened Cost	Estimate at completion burdened cost of primary baselined forecast version flagged as original.
Original EAC Revenue	Estimate at completion revenue of primary baselined forecast version flagged as original.
Original EAC Margin	Estimate at completion margin of primary baselined forecast version flagged as original.
Original EAC Margin Percentage	Estimate at completion margin percentage of primary baselined forecast version flagged as original.
Prior Actual Raw Cost	Actual raw cost of primary baselined forecast version flagged as prior.
Prior Actual Burdened Cost	Actual burdened cost of primary baselined forecast version flagged as prior.
Prior Actual Revenue	Actual revenue of primary baselined forecast version flagged as prior.
Prior Actual Margin	Actual margin of primary baselined forecast version flagged as prior.
Prior Actual Margin Percentage	Actual margin percentage of primary baselined forecast version flagged as prior.
Prior ETC Raw Cost	Estimate to complete raw cost of primary baselined forecast version flagged as prior.
Prior ETC Burdened Cost	Estimate to complete burdened cost of primary baselined forecast version flagged as prior.
Prior ETC Revenue	Estimate to complete revenue of primary baselined forecast version flagged as prior.
Prior ETC Margin	Estimate to complete margin of primary baselined forecast version flagged as prior.
Prior ETC Margin Percentage	Estimate to complete margin percentage of primary baselined forecast version flagged as prior.
Prior EAC Raw Cost	Estimate at completion raw cost of primary baselined forecast version flagged as prior.
Prior EAC Burdened Cost	Estimate at completion burdened cost of primary baselined forecast version flagged as prior.
Prior EAC Revenue	Estimate at completion revenue of primary baselined forecast version flagged as prior.
Prior EAC Margin	Estimate at completion margin of primary baselined forecast version flagged as prior.
Prior EAC Margin Percentage	Estimate at completion margin percentage of primary baselined forecast version flagged as prior.
Current Versus Prior EAC Raw Cost Variance	Variance between current and prior estimate at completion primary forecast raw cost amount.
Current Versus Prior EAC Burdened Cost Variance	Variance between current and prior estimate at completion primary forecast burdened cost amount.
Current Versus Prior EAC Revenue Variance	Variance between current and prior estimate at completion primary forecast revenue amount.
Current Versus Prior EAC Margin Variance	Variance between current and prior estimate at completion primary forecast margin.
Current Versus Prior EAC Margin Percentage Variance	Variance between current and prior estimate at completion primary forecast margin percentage.
Current Versus Original EAC Raw Cost Variance	Variance between current and original estimate at completion primary forecast raw cost amount.
Current Versus Original EAC Burdened Cost Variance	Variance between current and original estimate at completion primary forecast burdened cost amount.
Current Versus Original EAC Revenue Variance	Variance between current and original estimate at completion primary forecast revenue amount.
Current Versus Original EAC Margin Variance	Variance between current and original estimate at completion primary forecast margin.
Current Versus Original EAC Margin Percentage Variance	Variance between current and original estimate at completion primary forecast margin percentage.
Forecast Raw Cost - ITD	Inception-to-date raw cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Burdened Cost - ITD	Inception-to-date burdened cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Revenue - ITD	Inception-to-date forecast revenue of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin - ITD	Inception-to-date forecast margin of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin Percentage - ITD	Inception-to-date margin percentage of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Raw Cost - ITD	Inception-to-date raw cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Burdened Cost - ITD	Inception-to-date burdened cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Revenue - ITD	Inception-to-date forecast revenue of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin - ITD	Inception-to-date forecast margin of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin Percentage - ITD	Inception-to-date margin percentage of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Raw Cost - ITD	Inception-to-date raw cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Burdened Cost - ITD	Inception-to-date burdened cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Revenue - ITD	Inception-to-date forecast revenue of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin - ITD	Inception-to-date forecast margin of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin Percentage - ITD	Inception-to-date margin percentage of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Raw Cost - ITD	Inception-to-date raw cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Burdened Cost - ITD	Inception-to-date burdened cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Revenue - ITD	Inception-to-date forecast revenue of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin - ITD	Inception-to-date forecast margin of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin Percentage - ITD	Inception-to-date margin percentage of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Raw Cost - YTD	Year-to-date raw cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Burdened Cost - YTD	Year-to-date burdened cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Revenue - YTD	Year-to-date forecast revenue of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin - YTD	Year-to-date forecast margin of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin Percentage - YTD	Year-to-date margin percentage of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Raw Cost - YTD	Year-to-date raw cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Burdened Cost - YTD	Year-to-date burdened cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Revenue - YTD	Year-to-date forecast revenue of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin - YTD	Year-to-date forecast margin of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin Percentage - YTD	Year-to-date margin percentage of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Raw Cost - YTD	Year-to-date raw cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Burdened Cost - YTD	Year-to-date burdened cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Revenue - YTD	Year-to-date forecast revenue of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin - YTD	Year-to-date forecast margin of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin Percentage - YTD	Year-to-date margin percentage of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Raw Cost - YTD	Year-to-date raw cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Burdened Cost - YTD	Year-to-date burdened cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Revenue - YTD	Year-to-date forecast revenue of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin - YTD	Year-to-date forecast margin of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin Percentage - YTD	Year-to-date margin percentage of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Raw Cost - QTD	Quarter-to-date raw cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Burdened Cost - QTD	Quarter-to-date burdened cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Revenue - QTD	Quarter-to-date forecast revenue of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin - QTD	Quarter-to-date forecast margin of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin Percentage - QTD	Quarter-to-date margin percentage of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Raw Cost - QTD	Quarter-to-date raw cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Burdened Cost - QTD	Quarter-to-date burdened cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Revenue - QTD	Quarter-to-date forecast revenue of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin - QTD	Quarter-to-date forecast margin of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin Percentage - QTD	Quarter-to-date margin percentage of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Raw Cost - QTD	Quarter-to-date raw cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Burdened Cost - QTD	Quarter-to-date burdened cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Revenue - QTD	Quarter-to-date forecast revenue of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin - QTD	Quarter-to-date forecast margin of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin Percentage - QTD	Quarter-to-date margin percentage of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Raw Cost - QTD	Quarter-to-date raw cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Burdened Cost - QTD	Quarter-to-date burdened cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Revenue - QTD	Quarter-to-date forecast revenue of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin - QTD	Quarter-to-date forecast margin of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin Percentage - QTD	Quarter-to-date margin percentage of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Raw Cost - PTD	Period-to-date raw cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Burdened Cost - PTD	Period-to-date burdened cost of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Revenue - PTD	Period-to-date forecast revenue of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin - PTD	Period-to-date forecast margin of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Margin Percentage - PTD	Period-to-date margin percentage of any baselined forecast version calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Raw Cost - PTD	Period-to-date raw cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Burdened Cost - PTD	Period-to-date burdened cost of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Revenue - PTD	Period-to-date forecast revenue of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin - PTD	Period-to-date forecast margin of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Current Forecast Margin Percentage - PTD	Period-to-date margin percentage of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Raw Cost - PTD	Period-to-date raw cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Burdened Cost - PTD	Period-to-date burdened cost of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Revenue - PTD	Period-to-date forecast revenue of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin - PTD	Period-to-date forecast margin of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Original Forecast Margin Percentage - PTD	Period-to-date margin percentage of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Raw Cost - PTD	Period-to-date raw cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Burdened Cost - PTD	Period-to-date burdened cost of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Revenue - PTD	Period-to-date forecast revenue of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin - PTD	Period-to-date forecast margin of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Prior Forecast Margin Percentage - PTD	Period-to-date margin percentage of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar. This metric is available in project ledger currency, project currency, and analytic currency only.
Forecast Quantity	Forecast quantity of any baselined forecast version.
Forecast Labor Effort	Labor effort for any baselined forecast version.
Forecast Equipment Effort	Equipment effort for any baselined forecast version.
EAC Quantity	Estimate at completion quantity of any baselined forecast.
EAC Labor Effort	Estimate at completion labor effort for any baselined forecast version.
EAC Equipment Effort	Estimate at completion equipment effort of any baselined forecast version.
Forecast Quantity - ITD	Inception-to-date forecast quantity of any baselined forecast version calculated using the receiver fiscal calendar.
Forecast Quantity - YTD	Year-to-date forecast quantity of any baselined forecast version calculated using the receiver fiscal calendar.
Forecast Quantity - QTD	Quarter-to-date forecast quantity of any baselined forecast version calculated using the receiver fiscal calendar.
Forecast Quantity - PTD	Period-to-date forecast quantity of any baselined forecast version calculated using the receiver fiscal calendar.
Current Forecast Quantity	Forecast quantity of primary baselined forecast version flagged as current.
Current Forecast Labor Effort	Labor effort for primary baselined forecast version flagged as current.
Current Forecast Equipment Effort	Equipment effort for primary baselined forecast version flagged as current.
EAC Current Quantity	Estimate at completion quantity of baselined forecast.
EAC Current Labor Effort	Estimate at completion labor effort for primary baselined forecast version flagged as current.
EAC Current Equipment Effort	Estimate at completion equipment effort of primary baselined forecast version flagged as current.
Current Forecast Quantity - ITD	Inception-to-date forecast quantity of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar.
Current Forecast Quantity - YTD	Year-to-date forecast quantity of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar.
Current Forecast Quantity - QTD	Quarter-to-date forecast quantity of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar.
Current Forecast Quantity - PTD	Period-to-date forecast quantity of primary baselined forecast version flagged as current calculated using the receiver fiscal calendar.
Original Forecast Quantity	Forecast quantity of primary baselined forecast version flagged as original.
Original Forecast Labor Effort	Labor effort for primary baselined forecast version flagged as original.
Original Forecast Equipment Effort	Equipment effort for primary baselined forecast version flagged as original.
EAC Original Quantity	Estimate at completion quantity of baselined forecast.
EAC Original Labor Effort	Estimate at completion labor effort for primary baselined forecast version flagged as original.
EAC Original Equipment Effort	Estimate at completion equipment effort of primary baselined forecast version flagged as original.
Original Forecast Quantity - ITD	Inception-to-date forecast quantity of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar.
Original Forecast Quantity - YTD	Year-to-date forecast quantity of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar.
Original Forecast Quantity - QTD	Quarter-to-date forecast quantity of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar.
Original Forecast Quantity - PTD	Period-to-date forecast quantity of primary baselined forecast version flagged as original calculated using the receiver fiscal calendar.
Prior Forecast Quantity	Forecast quantity of primary baselined forecast version flagged as prior.
Prior Forecast Labor Effort	Labor effort for primary baselined forecast version flagged as prior.
Prior Forecast Equipment Effort	Equipment effort for primary baselined forecast version flagged as prior.
EAC Prior Quantity	Estimate at completion quantity of baselined forecast.
EAC Prior Labor Effort	Estimate at completion labor effort for primary baselined forecast version flagged as prior.
EAC Prior Equipment Effort	Estimate at completion equipment effort of primary baselined forecast version flagged as prior.
Prior Forecast Quantity - ITD	Inception-to-date forecast quantity of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar.
Prior Forecast Quantity - YTD	Year-to-date forecast quantity of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar.
Prior Forecast Quantity - QTD	Quarter-to-date forecast quantity of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar.
Prior Forecast Quantity - PTD	Period-to-date forecast quantity of primary baselined forecast version flagged as prior calculated using the receiver fiscal calendar.

PPM - Project Funding

These metrics are used in the Analytics Currency (AC) and Contract Currency (CC) fact folders. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis uses contract line start date to convert from contract currency to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Contract Amount	Shows the contract amount.
External Contract Amount	Shows the contract amount for external contracts.
Intercompany Contract Amount	Shows the contract amount for intercompany contracts.
Interproject Contract Amount	Shows the contract amount for interproject contracts.
Funding Amount	Funding amount allocated to the project.
Unallocated Amount	Unallocated amount calculated as contract amount - funding amount.
Revenue Amount	Revenue recognized for the contract.
Backlog Amount	Backlog amount is calculated as funding amount - revenue amount.
Quantity	Shows the contract line quantity.

PPM – Project Labor Distribution Costs (Preview)

These metrics are used in the Document Currency (DC) fact folder in the Subject Area.

Metric	Metric Definition
Labor Cost Amount	This metric shows the Payroll labor Cost amount.
Distribution Amount	This metric shows the distribution cost amount allocated based on the labor schedule rule.
Line Percentage	This metric shows the allocation percentage used for generating the labor distribution based on the labor scheduled rule.

PPM - Project Labor Schedules (Preview)

These metrics are in the Facts - Labor Schedules folder in the Subject Area.

Metric	Metric Definition
Line Percentage	This metric shows the Line Percentage in the Labor Schedule Distribution Rule.
Number of Versions	This metric shows the number of Labor Schedule versions defined.
Number of Distribution Rules	This metric shows the number of Distribution Rules in the Labor Schedule.

PPM - Project Invoices

These metrics are used in the Analytics Currency (AC), Document Currency (DC), Contract Currency (CC), Project Currency (PC), Ledger Currency (LC), Project Ledger Currency (PLC), and Invoice Currency (IC) fact folder in subject area. Ledger Currency and Project Currency amounts will be available only for Invoices with Accepted Status. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis uses Invoice Currency Conversion Rate Date if this date is populated, and if not available, uses invoice date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Invoice Amount	Contract Invoice Amount.
External Invoice Amount	Invoice amount from External contracts.
Intercompany Invoice Amount	Invoice amount from Intercompany contracts.
Interproject Invoice Amount	Invoice amount from Interproject contracts.
Write-Off Amount	Write-off Amount shows the Invoice amount for Invoices with type Write-off invoice.
Credit Memo Amount	Credit Memo Amount shows the Invoice amount for Invoices with type Credit Memo.
Canceled Amount	Canceled Amount shows the Invoice amount for Invoices with type Canceled invoice.
Concession Amount	Concession Amount shows the Invoice amount for Invoices with type Concession invoice.
Invoice Amount - ITD	Inception to Date Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Invoice Amount - ITD	Inception to Date External Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Invoice Amount - ITD	Inception to Date Intercompany Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Invoice Amount - ITD	Inception to Date Interproject Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Invoice Amount - YTD	Year to Date Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Invoice Amount - YTD	Year to Date External Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Invoice Amount - YTD	Year to Date Intercompany Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Invoice Amount - YTD	Year to Date Interproject Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Invoice Amount - QTD	Quarter to Date Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Invoice Amount - QTD	Quarter to Date External Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Invoice Amount - QTD	Quarter to Date Intercompany Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Invoice Amount - QTD	Quarter to Date Interproject Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Invoice Amount - PTD	Period to Date Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Invoice Amount - PTD	Period to Date External Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Invoice Amount - PTD	Period to Date Intercompany Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Invoice Amount - PTD	Period to Date Interproject Invoice Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Billed Quantity	Shows the Billed Quantity.

PPM - Project Revenue

These metrics are used in the Analytics Currency (AC), Document Currency (DC), Contract Currency (CC), Project Currency (PC), Ledger Currency (LC), Project Ledger Currency (PLC), and Revenue Currency (RC) fact folders in subject areas. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis uses ledger currency conversion rate date if this date is populated, and if not available uses transaction date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Revenue Amount	Contract revenue amount.
External Revenue Amount	Revenue recognized from external contracts.
Intercompany Revenue Amount	Revenue recognized from intercompany contracts.
Interproject Revenue Amount	Revenue recognized from interproject contracts.
Revenue Amount - ITD	Inception to Date Contract Revenue Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Revenue Amount - ITD	Inception to Date Revenue amount from External Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Revenue Amount - ITD	Inception to Date Revenue amount from Intercompany Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Revenue Amount - ITD	Inception to Date Revenue amount from Interproject Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Revenue Amount - YTD	Year to Date Contract Revenue Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Revenue Amount - YTD	Year to Date Revenue amount from External Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Revenue Amount - YTD	Year to Date Revenue amount from Intercompany Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Revenue Amount - YTD	Year to Date Revenue amount from Interproject Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Revenue Amount - QTD	Quarter to Date Contract Revenue Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Revenue Amount - QTD	Quarter to Date Revenue amount from External Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Revenue Amount - QTD	Quarter to Date Revenue amount from Intercompany Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Revenue Amount - QTD	Quarter to Date Revenue amount from Interproject Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Revenue Amount - PTD	Period to Date Contract Revenue Amount calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
External Revenue Amount - PTD	Period to Date Revenue amount from External Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, Project Ledger Currency, and Analytic Currency only.
Intercompany Revenue Amount - PTD	Period to Date Revenue amount from Intercompany Contracts calculated using the Receiver Fiscal Calendar. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Interproject Revenue Amount - PTD	Period to Date Revenue amount from Interproject Contracts. This metric is available in Ledger Currency, Project Currency, and Analytic Currency only.
Debit Amount	Shows the debit amount of the revenue accounting distribution. This metric is available in ledger currency, document currency, and analytic currency only.
Credit Amount	Shows the credit amount of the revenue accounting distribution. This metric is available in ledger currency, document currency, and analytic currency only.
Net Amount	Shows the net amount of the revenue accounting distribution. This metric is available in ledger currency, document currency, and analytic currency only.
Revenue Recognized Quantity	Revenue recognized quantity..
Unaccounted Count	Count of revenue distributions that are not accounted.

Receivables

Overview

These tables describe Receivables metrics.

Financials—AR Adjustments

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Adjustment date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted adjustments are supported.

Metric	Metric Definition
Adjustments Amount	Shows the adjustments amount that is adjusted to the invoices, debit memos, chargebacks, onaccount credits, deposits, and guarantees.
Adjustments Count	Shows the adjustments count that is adjusted to the invoices, debit memos, chargebacks, onaccount credits, deposits, and guarantees.
Adjustments Distribution Amount	Shows the adjustments distribution amount.

Financials—AR Aging

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted transactions are supported.

Metric	Metric Definition
Activity Amount	Shows the activities amount of the specified accounts and can be aggregated by business unit, customer, customer account, and time.
Aging Amount - Invoice Date Basis	Shows the aging amount for the open invoices and unapplied receipts based on transaction date grouped by selected aging period.
Aging Amount - Schedule Date Basis	Shows the aging amount for the open invoices and unapplied receipts based on schedule date grouped by selected aging period.
Aging Count - Invoice Date Basis	Shows the aging count for the open invoices and unapplied receipts based on transaction date grouped by selected aging period.
Aging Count - Schedule Date Basis	Shows the aging count for the for the open invoices and unapplied receipts based on schedule date grouped by selected aging period.
Avg Invoice Days Current	This metric is computed as follows: total number of days before due date / current invoices count. This is based on schedule date.
Avg Invoice Days Outstanding	This metric is computed as follows: total number of days invoice outstanding / total outstanding invoices count. This is based on invoice date.
Avg Invoice Days overdue	This metric is computed as follows: total number of days invoice overdue / overdue invoices count. This is based on schedule date.
Closing Amount	Shows the ending balance of the specified accounts and can be aggregated by business unit, customer, customer account and, time.
Current Amount	Shows the invoices amount which are yet to cross the schedule due date.
Current Amount to Total Outstanding %	This metric is computed as follows: (current amount / total outstanding amount) * 100.
Current Count to Total Outstanding %	This metric is computed as follows: (current invoices count / total outstanding invoices count) * 100.
Current Invoices Count	Shows the invoices count which are yet to cross the schedule due date.
Opening Amount	Shows the opening balance of the specified accounts and can be aggregated by business unit, customer, customer account, and time.
Overdue Amount	Shows the invoices and unapplied receipts amount which has crossed the schedule due date.
Overdue Amount to Total Outstanding %	This metric is computed as follows: (overdue amount / total outstanding amount) * 100.
Overdue Count to Total Outstanding %	This metric is computed as follows: (overdue invoices count / total outstanding invoices count) * 100.
Overdue Invoices Count	Shows the invoices and unapplied receipts count which has crossed the schedule due date.
Risk Amount	Shows the receipt amount for which cash is not cleared or risk is not eliminated.
Total Outstanding Amount	Shows the outstanding amount which includes current and overdue invoices and receipts.
Total Outstanding Invoices Count	Shows the count of outstanding invoices and unapplied receipts.
Future Activity Amount	Shows the total activity amount that is accounted in future periods. This amount is available for analysis only in the current snapshot. This metric is exposed only if Receivables Aging (Preview) functional area is activated.
Original Amount	Shows the Transaction Amount for Transactions and the Receipt Amount for Unapplied Receipts.

Financials—AR Credit Memo Applications

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Credit Memo Accounting date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted credit memo applications are supported.

Metric	Metric Definition
Application Distribution Amount	Shows the credit memo application distribution amount.
Credit Memo Applications Amount	Shows the credit memo applications amount. This considers credit memos with application status as applied and activity. This amount is not available in non-primary ledgers.
Credit Memo Applications Count	Shows the credit memo applications count. This considers credit memos with application status as applied and activity.

Financials—AR Receipts and Applications

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Receipt date for Receipts and Transaction date for Applications to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted receipts and applications are supported.

Metric	Metric Definition
Credit Card Chargeback Amount	Shows the credit card chargeback amount.
Credit Card Refund Amount	Shows the credit card refund amount.
Receipt Distribution Amount	Shows the receipt and application distribution amount.
Receipt Refund Amount	Shows the receipt refund amount.
Receipt to Receipt Application Amount	Shows the receipt to receipt application amount.
Receipt Write-Off Amount	Shows the receipt write-off amount.
Avg Receipts Amount	This metric is computed as follows: receipts amount / receipts count.
Discounts Taken Amount	Shows the total discount amount that was taken.
Discounts Taken of Applied Receipts %	This metric is computed as follows: (discounts taken amount / receipts applications amount) * 100.
Earned Discounts Amount	Shows the total earned discount amount that was taken.
Earned Discounts of Total Discount %	This metric is computed as follows: (earned discounts amount / discounts taken amount) * 100.
Exchange Gain or Loss Amount	Shows the exchange gain or loss amount incurred at the time of receipt.
On account Amount	Shows the receipt amount applied to on account activity when customer is found.
Other Receipt Application Amount	Shows receipt amount that is applied to prepayment, claim investigations activities.
Receipts Amount	Shows the receipts amount from the customers.
Receipts Applications Amount	Shows receipt amount from the customers that are applied against outstanding invoices.
Receipts Transaction Count	Shows the distinct count of receipt numbers.
Unapplied Receipts Amount	Shows receipt amount from the customers that are unapplied against outstanding invoices.
Unearned Discounts Amount	Shows the total unearned discount amount that was taken.
Unearned Discounts of Total Discount %	This metric is computed as follows: (unearned discounts amount / discounts taken amount) * 100.
Unidentified Amount	Shows the unidentified receipts transaction amount.

Financials—AR Revenue

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies.

Metric	Metric Definition
Distribution Amount	Shows the distribution amount.
Freight Amount	Shows the freight distribution amount.
Line Amount	Shows the transaction line amount. This amount is not available in non-primary ledgers.
Long Term Deferred Revenue	Shows the deferred or unearned revenue distribution amount that will be recognized after 365 days from current system date.
Revenue Amount	Shows the revenue distribution amount that is recognized.
Short Term Deferred Revenue	Shows the deferred or unearned revenue distribution amount that will be recognized within 365 days from current system date.
Tax Amount	Shows the tax distribution amount.
Transaction Amount	Shows the transaction header amount. This amount is not available in non-primary ledgers.
Unbilled Receivable Amount	Shows the unbilled receivable amount.
Unearned Revenue Amount	Shows the unearned revenue distribution amount that is yet to be recognized.

Financials—AR Transactions

These metrics will be used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder and Document Currency (DC) fact folder in Subject Areas. Analytics Currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be Transaction date to convert to Analytics currency. Metrics in these folders will show amounts in their respective currencies. Currently only posted transactions are supported.

Metric	Metric Definition
Avg Credit Memos Amount	This metric is computed as follows: credit memos amount / credit memos count.
Avg Debit Memos Amount	This metric is computed as follows: debit memos amount / debit memos count.
Avg Invoices Amount	This metric is computed as follows: invoices amount / invoices count.
Credit Memos Amount	Shows the invoice amount for the credit memo transaction type.
Credit Memos Count	Shows the invoices count for credit memo transaction type.
Debit Memos Amount	Shows the invoice amount for the debit memo transaction type.
Debit Memos Count	Shows the invoices count for debit memo transaction type.
Invoices Amount	Shows the invoice amount which includes chargeback, deposits, guarantee, invoices invoice types and excludes the credit memo and debit memo transaction type.
Invoices Count	Shows the invoices count which includes chargeback, deposits, guarantee, invoices invoice types and excludes the credit memo and debit memo transaction type.
Total Transactions Amount	Shows the sum of invoice amount, debit memos amount and credit memos amount.
Total Transactions Count	Shows the distinct count of invoice numbers.
Remaining Amount	Shows the remaining amount for the payment schedule.
Avg Overdue Days	Shows the overdue days calculated as Current Date - Transaction Due Date.

Descriptive Flexfield (DFF)

Assets

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - Assets Transactions	Supports the asset category, asset invoices and asset retirement descriptive flexfields.

General Ledger

These descriptive flexfields are supported by General Ledger subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - GL Detail Transactions	Supports the journal headers, journal lines, and journal batches descriptive flexfields.

Grants Management

These descriptive flexfields are supported by Grants Management subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
PPM – Grants Award Funding (Preview)	Supports awards, institution, award personnel, award funding source, award projects, project, project types, contract headers, contract lines, bill plan, class categories, class codes, and project class codes descriptive flexfields.

Payables

These descriptive flexfields are supported by Payables subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - AP Invoices	Supports the suppliers, supplier sites, invoice headers, invoice headers regional information, and invoice Installments descriptive flexfields.
Financials - AP Aging	Supports the suppliers, supplier sites, invoice headers, invoice headers regional information, and invoice Installments descriptive flexfields.
Financials - AP Payments	Supports the suppliers, supplier sites, invoice payments, invoice payments regional information, invoice headers, invoice headers regional information, and invoice installments descriptive flexfields.
Financials - AP Liabilities	Supports the suppliers, supplier sites, invoice headers regional information, and invoice headers descriptive flexfields.
Financials - AP Expenses	Supports the suppliers, supplier sites, invoice headers, invoice headers regional information, invoice lines, and invoice distributions descriptive flexfields.
Financials - AP Holds	Supports the suppliers, supplier sites, invoice headers, invoice headers regional information, invoice lines, and invoice holds descriptive flexfields.

Receivables

These descriptive flexfields are supported by Receivables subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
Financials - AR Transactions	Supports the Customer, Bill-to Customer, Ship-to Customer, Paying Customer, Sold-to Customer, Customer Account, Bill-to Customer account, Paying Customer Account, Customer Site, Bill-to Customer Site, Ship-to Customer Site, Paying Customer Site, Transactions Headers, Transactions Headers Regional Information, Transactions Schedules, and Transactions Distributions descriptive flexfields.
Financials - AR Receipts and Applications	Supports the Customer, Bill-to Customer, Ship-to Customer, Paying Customer, Sold-to Customer, Customer Account, Bill-to Customer account, Paying Customer Account, Customer Site, Bill-to Customer Site, Ship-to Customer Site, Paying Customer Site, Receipts, and Receipts Regional Information descriptive flexfields.
Financials - AR Credit Memo Applications	Supports the Customer, Bill-to Customer, Ship-to Customer, Paying Customer, Sold-to Customer, Customer Account, Bill-to Customer account, Paying Customer Account, Customer Site, Bill-to Customer Site, Ship-to Customer Site, and Paying Customer Site descriptive flexfields.
Financials - AR Adjustments	Supports the Customer, Bill-to Customer, Ship-to Customer, Paying Customer, Sold-to Customer, Customer Account, Bill-to Customer account, Paying Customer Account, Customer Site, Bill-to Customer Site, Ship-to Customer Site, and Paying Customer Site descriptive flexfields.
Financials - AR Aging	Supports the Customer, Bill-to Customer, Ship to Customer, Sold-to Customer, Customer Account, Bill-to Customer Account, Bill-to Customer Site, Ship-to Customer Site, Transactions Headers, Transactions Headers Regional Information, and Transactions Schedules descriptive flexfields.
Financials - AR Revenue	Supports the Customer, Bill-to Customer, Ship-to Customer, Paying Customer, Sold-to Customer, Customer Account, Bill-to Customer account, Paying Customer Account, Customer Site, Bill-to Customer Site, Ship-to Customer Site, Paying Customer Site, Transactions Headers, Transactions Headers Regional Information, Transactions Lines, and Transactions Distributions descriptive flexfields.

Purchasing

Below Descriptive Flexfields are supported by Procurement subject area.

Subject Area Name	Descriptive Flexfield (DFF) Supported
Procurement - Spend	Supports Suppliers, Supplier Sites, Invoice Headers, Invoice Lines, Invoice Distributions, and Items
Procurement - Purchase Orders	Supports Suppliers, Supplier Sites, Purchase Orders Headers, Purchase Orders Lines, and Items
Procurement - Receipts	Supports Suppliers, Supplier Sites, Receipt Headers, Receipt Lines, and Items
Procurement - Agreements	Supports Suppliers, Supplier Sites, Agreement Headers, Agreement Lines, and Items
Procurement - Requisitions	Supports Suppliers, Supplier Sites, Requisition Headers, Requisition Lines, Requisition Distributions, and Items
Enterprise Contracts - Contracts (Preview)	Supports Contracts and Contracts Lines.
Procurement - Receipt Accounting (Preview)	Supports Items and Suppliers
Procurement - Accrual Balances at Period End (Preview)	Supports Items and Suppliers.
Procurement - Accrual Balances at Receipt (Preview)	Supports Items and Suppliers.

Project Billing

These descriptive flexfields are supported by Project Bililng subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
PPM - Project Revenue	Supports the project, task structure, project types, class categories, class codes, project class codes, awards, award projects, award personnel, institution, contract headers, contract lines, and bill plan descriptive flexfields.
PPM - Project Funding	Supports the project, task structure, project types, class categories, class codes, project class codes, contract headers, contract lines, and bill plan descriptive flexfields.
PPM - Project Invoices	Supports the supports project, task structure, project types, class categories, class codes, project class codes, awards, award projects, award personnel, institution, contract headers, contract lines, bill plan, invoice headers, and invoice lines descriptive flexfields.

Project Control

Subject Area Name	Descriptive Flexfield (DFF) Supported
PPM - Project Budgets	Supports the project, task structure, project types, expenditure categories, expenditure types, nonlabor resources, class categories, class codes, project class codes, awards, award projects, award personnel, institution, award funding source, planning options, and plan lines descriptive flexfields.
PPM - Project Forecasts	Supports the project, task structure, project types, expenditure categories, expenditure types, nonlabor resources, class categories, class codes, project class codes, planning options, and plan lines descriptive flexfields.

Project Costing

These descriptive flexfields are supported by Project Costing subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
PPM - Project Costs	Supports the project, task structure, project types, expenditure categories, expenditure types, class categories, class codes, project class codes, nonlabor resource, work type, awards, institution, award funding source, award projects, award personnel, project expenditure item, and project costing details descriptive flexfields.
PPM - Project Commitments	Supports the project, task structure, project types, expenditure categories, expenditure types, class categories, class codes, project class codes, work type, awards, award projects, award personnel, institution, and award funding source descriptive flexfields.
PPM - Project Assets (Preview)	Supports project, task structure, asset task, asset line task, project types, class categories, class codes, project class codes, expenditure categories and expenditure types descriptive flexfields.
PPM - Project Labor Schedules (Preview)	Supports the project, task structure, project types, expenditure categories, expenditure types, class categories, class codes, project class codes, awards, award projects, award personnel, and award funding source descriptive flexfields.
PPM – Project Labor Distribution Costs (Preview)	Supports the project, task structure, project types, expenditure categories, expenditure types, class categories, class codes, project class codes, awards, award projects, award personnel, and award funding source descriptive flexfields.