EPM 9.1: - SCM Lineage Document Has Some Errors About Source Extraction Type (Doc ID 1634674.1)

Last updated on MARCH 16, 2016

Applies to:

PeopleSoft Enterprise EPM Financials Warehouse - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Goal

In the Excel document "EPM_91_ETL_SCM_Lineage_Spreadsheet" in the Setup tab:

Source Table: PS_CM_ACCTG_GRP_D - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is CRC logic.
Source Table: PS_CUSTOMER - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is CRC logic.
Source Table: PS_ITM_VNDR_UOM - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is CRC logic.
Source Table: PS_PERSONAL_DATA - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is CRC logic.
Source Table: PS_SF_ISS_TRANSFER - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is CRC logic.
Source Table: PS_SF_VARIANCES - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is CRC logic.
Source Table: PS_SPM_BU_SUPPLIER - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is CRC logic.

Source Table: PS_INSTALLATION_GM - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is pulling all the records.
Source Table: PS_INSTALLATION_PC - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is pulling all the records.
Source Table: PS_SET_CNTRL_REC - the SourceExtractionType column says DateTime Incremental but if you open the staging ETL it is pulling all the records.

Customer is using EPM 9.1 MP3 version of SCM Lineage spreadsheet.

Solution

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 hundreds of Community platforms