My Oracle Support Banner

Update Organization FDPSTP Failed Due To ORA-54017: UPDATE Operation Disallowed On Virtual Columns (Doc ID 2954099.1)

Last updated on JUNE 08, 2023

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP15 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to update an organization via the forms or API, the following error occurs:

ORACLE error 54017 in FDPSTP

Cause: FDPSTP failed due to ORA-54017: UPDATE operation disallowed on virtual columns
ORA-06512: at "APPS.HR_ORGANIZATION_API", line 2290
ORA-06512: at "APPS.HR_ORT_UPD", line 99
ORA-06512: at "APPS.HR_ORT_UPD", line 68


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

  1.  Responsibility: US HRMS Manager

  2.  (N) Work Structures > Organizations > Define

  3. Make any update to existing organization


  4. Call API HR_ORGANIZATION_API directly to update an organization's details. 


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.