Modifying the Commitments View (Oracle Projects Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Modifying the Commitments View

You modify the pa_commitment_txns_v to change how Oracle Projects track commitments.

To change which requisitions and purchase orders in Oracle Purchasing and supplier invoices in Oracle Payables are considered as commitments, modify the default select or where clause statements in the view or substitute other Oracle Purchasing and Oracle Payables views as needed.

To include commitments from an external system, create a new view called pa_commitments_outside_system_v to read your external commitments and include it in the pa_commitment_txns_v view.

Oracle Projects provides a template script that includes the view definition with an example of integrating commitments from an external system. The name of the script is PACMTVW.sql and is located in the Oracle Projects admin/sql directory.

Required Fields in External Commitments View

When you create the pa_commitments_outside_system_v view for external commitments, you must include the following columns in this view:

Column Type Description

PROJECT_ID NUMBER(15) The identifier of the project

TASK_ID NUMBER(15) The identifier of the task

TRANSACTION_SOURCE VARCHAR2(30) Source of the commitment. Set this to OUTSIDE_SYSTEM

LINE_TYPE VARCHAR2(1) Type of the commitment line. Use one of the following values:
R for requisitions
P for purchase orders
I for supplier invoices

EXPENDITURE_ITEM_DATE DATE The expenditure item date of the commitment

PA_PERIOD VARCHAR2(20) PA Period of the commitment. Use the current reporting period. See Determining Periods below

GL_PERIOD VARCHAR2(15) GL Period of the commitment. Use the GL period of the current reporting period. See Determining Periods below

ORGANIZATION_ID NUMBER The identifier of the expenditure organization

EXPENDITURE_TYPE VARCHAR2(30) The expenditure type. Use an expenditure type with an expenditure type class of Supplier Invoices.

EXPENDITURE_CATEGORY VARCHAR2(30) The expenditure category of the expenditure type

REVENUE_CATEGORY VARCHAR2(30) The revenue category of the expenditure type

SYSTEM_LINKAGE_FUNCTION VARCHAR2(30) The expenditure type class of the expenditure type. Set this to VENDOR_INVOICES

TOT_CMT_RAW_COST NUMBER The raw cost amount

TOT_CMT_BURDENED_COST NUMBER The burdened cost amount. See Burdening Commitments below

Column	Type	Description
PROJECT_ID	NUMBER(15)	The identifier of the project
TASK_ID	NUMBER(15)	The identifier of the task
TRANSACTION_SOURCE	VARCHAR2(30)	Source of the commitment. Set this to OUTSIDE_SYSTEM
LINE_TYPE	VARCHAR2(1)	Type of the commitment line. Use one of the following values: R for requisitions P for purchase orders I for supplier invoices
EXPENDITURE_ITEM_DATE	DATE	The expenditure item date of the commitment
PA_PERIOD	VARCHAR2(20)	PA Period of the commitment. Use the current reporting period. See Determining Periods below
GL_PERIOD	VARCHAR2(15)	GL Period of the commitment. Use the GL period of the current reporting period. See Determining Periods below
ORGANIZATION_ID	NUMBER	The identifier of the expenditure organization
EXPENDITURE_TYPE	VARCHAR2(30)	The expenditure type. Use an expenditure type with an expenditure type class of Supplier Invoices.
EXPENDITURE_CATEGORY	VARCHAR2(30)	The expenditure category of the expenditure type
REVENUE_CATEGORY	VARCHAR2(30)	The revenue category of the expenditure type
SYSTEM_LINKAGE_FUNCTION	VARCHAR2(30)	The expenditure type class of the expenditure type. Set this to VENDOR_INVOICES
TOT_CMT_RAW_COST	NUMBER	The raw cost amount
TOT_CMT_BURDENED_COST	NUMBER	The burdened cost amount. See Burdening Commitments below

Contents

Index

Navigation

Glossary

Library