Understanding Operation Metrics

PeopleSoft enables its users with a method to evaluate and manage operational efficiency within Receivables, Payables, and Billing. Using these performance indicators, users can determine the productivity of the operations as a whole as well as individual performance. Performance can be measured in quantity/amount of vouchers currently pending or processed over a given period of time.

Click to watch a short video about PeopleSoft Credit to Cash Operational Metrics.

Click to watch a short video about PeopleSoft Payables Operations Metrics.

The following table summarizes all the Materialized Views for Receivables that are all delivered with Complete Refresh method and whether users can change them from COMPLETE to FAST refresh, depending on the performance:

Materialized View Name

Can change to Fast Refresh method

AR_APYMNT_MVW

Yes

AR_PYMNT_MV_VW

Yes

AR_AUNPYT_MVW

Yes

AR_BUSET_MVW

No

AR_DISPUTE_MVW

No

AR_DSO_FLU_MVW

Yes

AR_ONACT_PY_MVW

Yes

AR_ONACT_PYT_MV

Yes

DBTIT_ITDTL_MVW

Yes

DBTIT_ITSMY_MVW

Yes

ITEM_BASE_MVW

Yes

OPI_CURR_EFF_MV

No

PASTD_DTL_MVW 

Yes

PASTD_IT_MVW

Yes

PAYCUST_BASE_MVW

Yes

The following table summarizes all the Materialized Views for Payables that are all delivered with Complete Refresh method and whether users can change them from COMPLETE to FAST refresh, depending on the performance:

Materialized View Name

Can change to Fast Refresh method

APOP_BSEPYMT_MV

Yes

APOP_INVOICE_MV

Yes

APOP_PVCHXRF_MV

Yes

APOP_PAYMENT_MV

Yes

APOD_DELVCHR_MV

Yes

APOP_INVCSUM_MV

Yes

APOP_VCHRSUM_MV

Yes

APOP_DELVCHR_MV

Yes

APOP_VENDOR_MV

No

APOP_APPRVCH_MV

No

APOP_PYMTVCH_MV

No

APOP_PYMNTDT_MV

No

 APOD_APPCSUM_MV 

No

APOD_INVCSUM_MV

No

APOD_PYMTSUM_MV

No

APOD_PYMTLAT_MV

No

APOD_HLDVCHR_MV

No

APOP_APPCSUM_MV

No

APOP_PYMTSUM_MV

No

APOP_PYMTLAT_MV 

No

APOP_PMNTTYS_MV 

No

APOP_CANPYMT_MV

No

APOP_HLDVCHR_MV

No

The following table summarizes all the Materialized Views for Billing that are all delivered with Complete Refresh method and whether users can change them from COMPLETE to FAST refresh, depending on the performance:

Materialized View Name

Can change to Fast Refresh method

BI_HDR_IVC_D_VW

No

You set up the reporting date configuration and update process by:

  1. Setting the date selection information on the Reporting Date Configuration page.

  2. Running the Reporting Date Update Process to enable the tile preferences. Access the Reporting Date Update Process page by using the navigation:

    Set Up Financials/Supply Chain, Operational Reporting, Operational Efficiency, Reporting Date Update Process.

Use the Reporting Date Configuration page (OPI_SYSCFG_PG) to enter your date selection information.

Navigation:

Set Up Financials/Supply Chain > Operational Reporting > Operational Efficiency > Reporting Date Configuration

This example illustrates the fields and controls on the Reporting Date Configuration page.

Reporting Date Configuration page