Unable To Create View PYMT_BNK_ACT_VW While Applying 9.1 Bundle 40 (UPD933752) (Doc ID 2231196.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

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

Symptoms

While applying 9.1 Bundle 40 (upd933752), the script in Change Assistant to create Views gave the following error.

Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 381 Return: 942 - ORA-00942: table or view does not exist

Failed SQL stmt:CREATE VIEW PS_PYMT_BNK_ACT_VW (SETID, BANK_CD, BANK_ACCT_KEY, DFI_ID_NUM, IBAN_ID, IBAN_MANDATORY, COUNTRY,

NUM1_AVAIL, NUM2_AVAIL, HOUSE_TYPE_AVAIL, ADDR4_AVAIL, DESCR) AS SELECT A.SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.DFI_ID_NUM ,

B.IBAN_ID , B.IBAN_MANDATORY , C.COUNTRY , C.NUM1_AVAIL , C.NUM2_AVAIL , C.HOUSE_TYPE_AVAIL , C.ADDR4_AVAIL , C.DESCR FROM PS_BANK_AC (200,0)

SQL Error. Error Position: 381 Return: 942 - ORA-00942: table or view does not exist

CREATE VIEW PS_PYMT_BNK_ACT_VW (SETID, BANK_CD, BANK_ACCT_KEY, DFI_ID_NUM, IBAN_ID, IBAN_MANDATORY, COUNTRY, NUM1_AVAIL, NUM2_AVAIL,

HOUSE_TYPE_AVAIL, ADDR4_AVAIL, DESCR) AS SELECT A.SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.DFI_ID_NUM , B.IBAN_ID , B.IBAN_MANDATORY ,

C.COUNTRY , C.NUM1_AVAIL , C.NUM2_AVAIL , C.HOUSE_TYPE_AVAIL , C.ADDR4_AVAIL , C.DESCR FROM PS_BANK_ACCT_DEFN A , PS_PYMT_IBAN_VW B ,

PS_COUNTRY_TBL C , PS_PAYMENT_TBL D WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND A.SETID

= D.BANK_SETID AND A.BANK_CD = D.BANK_CD AND A.BANK_ACCT_KEY = D.BANK_ACCT_KEY AND D.COUNTRY = C.COUNTRY

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