EGL9.2: INVALID OBJECT NAME 'PS_OI_BUSET_MAP' IN CA At CREATE VIEW PS_AQS_ACCT_P_VW
(Doc ID 2796334.1)
Last updated on SEPTEMBER 22, 2023
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Apply a change package (PUM Image 5) with the fix for <Bug 30808184> and it fails at the following create view step:
CREATE VIEW PS_AQS_ACCT_P_VW (ROWSECCLASS, PRODSRCID, BUSINESS_UNIT,
ACCOUNT) AS SELECT A.ROWSECCLASS , A.PRODSRCID , B.BUSINESS_UNIT ,
A.ACCOUNT FROM PS_SEC_ACCT_PERM A , PS_OI_BUSET_MAP B WHERE A.SETID =
B.ACCOUNT_SETID
Invalid object name 'PS_OI_BUSET_MAP'
OI_BUSET_MAP record has been introduced in PUM Image 15.
Replication steps:
The issue can be reproduced by creating a change package containing Bug 30808184 and applying it.
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 |
Cause |
Solution |
References |