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 AUGUST 28, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

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
  Meta-SQL error at or near position 35 in statement
  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.

 

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