My Oracle Support Banner

EMM: Change Assistant Create View PS_WM_RPT_SRCH_VW Fails with Error: ORA-00904: "SERIAL_ID": invalid identifier During Image 37 Initial Pass (Doc ID 2725316.1)

Last updated on OCTOBER 11, 2021

Applies to:

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

Symptoms

Issue #1:

Change Assistant Create View PS_WM_RPT_SRCH_VW Fails with the following error during the Initial Pass of applying Image 37:




The issue can be reproduced at will with the following steps:


1. Create the Change Package from FSCM PUM 37
2. Apply the Change Package in Change Assistant (CA)

Issue #2:

After resolving the above issue, the process failed while building the views at: CREATE VIEW PS_SCP_POLSTBUY_FL at the column 'NEXT&Action=A' where it is waiting for user input.

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


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