My Oracle Support Banner

EAM: Unable To SWAP Tables PSDMT_UNIT_HDR And PSDMT_UNIT_SEQ In FSCM 9.2 (Doc ID 2450691.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.57 to 8.57 [Release 8.4]
Information in this document applies to any platform.

Symptoms

 For FSCM 9.2 it is not possible to SWAP the base language for 2 tables:
PSDMT_UNIT_HDR and PSDMT_UNIT_SEQ.

The Swap does not work for ENG to DUT, but also from DUT to ENG.

REPLICATION STEPS
=================
1. Go to PS_HOME\bin\client\winx86 and run psdmt.exe.
2. Add any language and run the swap (30-40min) through Datamover.

SWAP_BASE_LANGUAGE <Target language>;

Error:
Swapping PSDMT_UNIT_HDR
File: E:\pt85511b-retail\peopletools\src\psdam\swapbase.cppSQL error. Stmt #:
2542 Error Position: 21 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT COUNT(*) FROM PSDMT_UNIT_H_LG WHERE LANGUAGE_CD =
'ENG'
File: E:\pt85511b-retail\peopletools\src\psdam\swapbase.cppSQL error. Stmt #:
2542 Error Position: 21 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT COUNT(*) FROM PSDMT_UNIT_HDR
File: E:\pt85511b-retail\peopletools\src\psdam\swapbase.cppSQL error. Stmt #:
2542 Error Position: 21 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT COUNT(*) FROM PSDMT_UNIT_H_LG WHERE LANGUAGE_CD =
'DUT'
Swap PSDMT_UNIT_HDR 0
Records remaining: 589
Swapping PSDMT_UNIT_SEQ
File: E:\pt85511b-retail\peopletools\src\psdam\swapbase.cppSQL error. Stmt #:
2542 Error Position: 21 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT COUNT(*) FROM PSDMT_UNIT_S_LG WHERE LANGUAGE_CD =
'ENG'
File: E:\pt85511b-retail\peopletools\src\psdam\swapbase.cppSQL error. Stmt #:
2542 Error Position: 21 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT COUNT(*) FROM PSDMT_UNIT_SEQ
File: E:\pt85511b-retail\peopletools\src\psdam\swapbase.cppSQL error. Stmt #:
2542 Error Position: 21 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT COUNT(*) FROM PSDMT_UNIT_S_LG WHERE LANGUAGE_CD =
'DUT'

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.