My Oracle Support Banner

EGL 9.1: Multi-Currency FSPCCURR Fails at FSPCSQLB_I_CRWRKRT with Error ORA-00942: table or view does not exist (Doc ID 2436314.1)

Last updated on AUGUST 16, 2018

Applies to:

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

Symptoms

On : 9.1 version

When attempting to run Multi-currency, the following error occurs.

ERROR
-----------------------
DYNAMIC Stmt=FSPCSQLB_I_CRWRKRT
12:02:32.127 1431 0.000 0.000 #2 RC=0 COM Stmt=INSERT INTO PS_ (PROCESS_INSTANCE, FROM_CUR, TO_CUR, RATE_MULT, RATE_DIV) SELECT 0012345678, A.FROM_CUR, A.TO_CUR, A.RATE_MULT, A.RATE_DIV FROM PS_RT_DFLT_VW A WHERE A.TO_CUR='USD' AND A.TO_CUR NOT IN ('000') AND A.RT_TYPE='CRRNT' AND A.EFFDT=(SELECT MAX(B.EFFDT) FROM PS_RT_DFLT_VW B WHERE B.FROM_CUR=A.FROM_CUR AND B.TO_CUR=A.TO_CUR AND B.RT_TYPE=A.RT_TYPE AND B.EFFDT <=TO_DATE('2018-06-30', 'YYYY-MM-DD'))
12:02:32.133 1432 0.010 0.000 #2 RC=942 EXE
12:02:32.133 1433 0.000 0.000 #0 RC=942 ERR rtncd=942 msg=ORA-00942: table or view does not exist
12:02:32.134 1434 0.000 0.000 #5 RC=0 EPO error pos=12

STEPS
-----------------------
The issue was reproduced as follows:
1. Run General Ledger > Process Multi-Currency > Define and Process > Request Process for 2 Business Units


Changes

 

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.