EEX 9.1+: SQL Object FS_CFI_FOVR_SHARE_EXVN Not Defined Error Encountered When Running EX_TRANS_PRCS With Post Liabilities Option. (Doc ID 2189900.1)

Last updated on FEBRUARY 06, 2023

Applies to:

Symptoms

SQL object FS_CFI_FOVR_SHARE_EXVN not defined error encountered when running EX_TRANS_PROCESS to post liabilities.

If the SETID being used is not SHARE and for ex, say 'XXXXX', then the error encountered will be "SQL object FS_CFI_FOVR_XXXXX_EXVN not defined"

ERROR
-----------------------

Assuming that "XXXXX" is the SETID being used, error message will be:

SQL object FS_CFI_FOVR_XXXXX_EXVN not defined (108,520)

Meta-SQL error at or near position 35 in statement (108,512)

Process 293 ABENDED at Step EX_LIBRARY.CF_INS.CF_INS_2 (SQL) -- RC = ? 50

293 EX_LIBRARY CF_INS CF_INS_2 SQL ?

Published message with ID 17801736-8a3a-11e6-aa70-beb27c74f62d to create entry in folder GENERAL.

Successfully posted generated files to the report repositor

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new SETID "XXXXX" and do the respective SETUP for the SETID. 
2. Create new expense report, approve, post liabilities and the above error message is displayed.

Changes

Cause

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