My Oracle Support Banner

EPM :Need DMS Scripts To Backup Needed Dimension Rows And Setup Tables So We Can Rebuild Warehouse Tables (Doc ID 1923535.1)

Last updated on MARCH 09, 2020

Applies to:

PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 and later
Information in this document applies to any platform.


Qn1:customer believe Oracle has EPM scripts to backup ALL needed data from the warehouse, truncate tables, and reload only the important rows in order for the warehouse to be rebuilt on fresh transactional data in a new IBM DataStage project. Had some scripts like this at a previous employer that customer think Oracle provided.

Could you please advise and provide the DMS scripts to perform the data cleansing, if any?
Qn2:what other tables need to be truncated for the refresh besides the fact and dimension tables? Can think of the PS_E_* (error tables), PS_X_*, PS_S_*, and PS_ES_*. Does missed anything else that needs to be truncated?


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

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