Timesheet Error: FRM-40602 - Cannot Insert into or Update Data in a View (Doc ID 1923443.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.1.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to change the timesheet status to Pending Approval OR Approved OR when making a change to any field or entering data in any field in sa_timesheet_header, the following error is displayed:

FRM-40602 Cannot Insert into or Update Data in a View


The issue can be reproduced at will with the following steps:

Scenario1: Open an existing timesheet record.
Enter a line item and save.
Change the status to Pending Approval OR Approved.  Error message pops up.


Scenario2: Open an existing timesheet record.
Make a change to any field or enter data in any field in sa_timesheet_header.  Error message pops up.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms