Oracle Time : How to modify the timecard expenditure type LOV


Refer to the Implementation Guide, 11i Oracle Self Service Time. On page 2-2 the documentation is specific on modifying the PA_ONLINE_EXPENDITURE_TYPES_V using file pavw742.sql found in the $PA_TOP/patch/115/sql directory.

You can configure Self–Service Time poplists for projects, tasks, expenditure types, and overriding approvers to meet your requirements. To do this, modify the WHERE clause in the corresponding view listed in this section. The views control the project and task values that users can download from the View Projects and Tasks link on the Self–Service Time main menu. Views are associated with the timecard preparer (that is, the person logged into the system). Because these views are used for validation and display, be sure to set up the the view so that the timecard preparer can select the projects for which he is entering hours. You can customize the following views:  

 Project View PA_ONLINE_PROJECTS_V : pavw681.sql

*Default allows user to view all projects. Sample code specifies that projects selected must be within the user’s organization. Do not modify the base view PA_PROJECTS_EXPEND_V.

Task View PA_ONLINE_TASKS_V : pavw682.sql

*Default allows user to view all tasks. Sample code specifies that tasks selected must be within the user’s organization. Do not modify the base view PA_TASKS_EXPEND_V.

Expenditure Type View PA_ONLINE_EXPENDITURE_TYPES_V : pavw742.sql

*Default allows user to view all expenditure types. Sample code specifies that users in the Consulting organization (organization_id=1) can enter only transactions of type Straight Time. Do not modify the base view PA_ONLINE_EXPENDITURE_TYPES_V.

 

Overriding Approver View PA_EXP_OVRRDE_APPROVER_V : pavw685.sql

*Default allows user to view all supervisors in the preparer’s business group. Sample code specifies that users can only select overriding approvers who belong to the user’s organization.

-> * Scripts are located in the $PA_TOP/patch/115/sql directory.

2 thoughts on “Oracle Time : How to modify the timecard expenditure type LOV

  1. While user entering the timecard he is getting the error as “The hours you are entering is not belongs to leave project or overhead project”.

    I have verified all the setups in projects, but I didnt finad any issue, IS this belongs to Enpenditure tyes, Can you please tell me how to rectify this

    Like

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s