My Oracle Support Banner

PSA Govetise Application completes in error: ORA-01733: VIRTUAL COLUMN NOT ALLOWED HERE (Doc ID 2435143.1)

Last updated on AUGUST 14, 2018

Applies to:

Oracle Public Sector Financials - Version 12.1 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
PSAGOVETISE
PSA Govetise Application
ORA-01733
virtual column not allowed here
psagvtmb

Symptoms

PSAGOVETISE: PSA Govetise Application

In a fresh install of 12.2.5 the concurrent program "PSAGOVETISE: PSAGovetise Application" completes in error with the following messages:

ERROR :psa.plsql.psagvtmb.enable_gl_lookups.final_exception:-1733:ORA-01733:
virtual column not allowed here
LEAVE *** psa.plsql.psagvtmb.main ***

The process was submitted via the following steps:

1. Log on to application using "SYSADMIN" user.
2. Select System Administrator responsibility.
3. Run PSA Govetise Application Concurrent Program.

But error still occurs.

This Public Sector client is PSAGOVETISEing a fresh insall of 12.2.5 because they need reporting attributes functionality.

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.