My Oracle Support Banner

GPCORE: View PS_GPSC_SSB_BFL_VW Creation Got Failed When We Are Applying HCM PUM 38 (Doc ID 2847224.1)

Last updated on FEBRUARY 04, 2022

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


View PS_GPSC_SSB_BFL_VW Creation got failed when we are applying HCM PUM 38

ERROR
-----------------------
21:53:01 SQL> DROP VIEW PS_GPSC_SSB_BFL_VW
21:53:01 2 /

View dropped.

21:53:01 SQL> CREATE VIEW PS_GPSC_SSB_BFL_VW (EMPLID, ACCOUNT_ID, EFF_STATUS,
21:53:01 2 ACCOUNT_TYPE_PYE, BANK_CD, BRANCH_EC_CD, INTL_BANK_ACCT_NBR,
21:53:01 3 ACCOUNT_EC_ID, ROLL_NAME, ROLL_NUMBER, COUNTRY_CD, ACCOUNT_NAME,
21:53:01 4 CURRENCY_CD, HSC_BANKACCCRYPT, HSC_BANKACCCRYPT3) AS SELECT EMPLID
21:53:01 5 , ACCOUNT_ID , EFF_STATUS , ACCOUNT_TYPE_PYE , BANK_CD ,
21:53:01 6 BRANCH_EC_CD , INTL_BANK_ACCT_NBR , ACCOUNT_EC_ID , ROLL_NAME
21:53:01 7 , ROLL_NUMBER , COUNTRY_CD , ACCOUNT_NAME , CURRENCY_CD ,
21:53:01 8 HSC_BANKACCCRYPT, HSC_BANKACCCRYPT3 FROM PS_PYE_BANKACCT
21:53:01 9 /
 HSC_BANKACCCRYPT, HSC_BANKACCCRYPT3 FROM PS_PYE_BANKACCT
  *
ERROR at line 8:
ORA-00904: "HSC_BANKACCCRYPT3": invalid identifier






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!


In this Document
Symptoms
Changes
Cause
Solution
References


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