OBIA 11g: 'ORA-00904: "XXX_XX_XXX"."SYNCDTTM": invalid identifier' Error Message seen when using Peoplesoft 9.1 Adaptors for a PeopleSoft 9.2 ETL (Doc ID 1632774.1)

Last updated on OCTOBER 09, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

BI Apps 11.1.1.7.1 ETL using PeopleSoft 9.2 Fins data fails with these types of errors using the PeopleSoft 9.1 Adaptors:

ORA-00904: "XXX_XX_XXX"."SYNCDTTM": invalid identifier

It seems that the ‘SYNCDTTM’ & 'LAST_UPDATE_DT' Columns no longer exists in the following Tables in the using PeopleSoft 9.2 Schema:

EX_SHEET_HDR"."LAST_UPDATE_DT"
EX_SHEET_HDR"."SYNCDTTM
EX_SHEET_HDR"."LAST_UPDATE_DT"
EX_TYPES_TBL"."SYNCDTTM”
EX_EXP_MTHD_TBL"."SYNCDTTM"
PROJ_CATG_TBL"."SYNCDTTM"
EX_TYPES_TBL"."SYNCDTTM"
PROJ_ACT_TBL"."SYNCID"
PS_EX_EXP_MTHD_TBL"."SYNCDTTM"
PROJ_ACT_TBL"."SYNCDTTM"
EX_PURPOSE_TBL"."SYNCDTTM"
PROJ_ANTYPE_TBL"."SYNCDTTM"

Mappings affected:

SDE_PSFT_EMPLOYEEEXPENSEFACT
SDE_PSFT_EMPLOYEEEXPENSECREDITCARDFACT
SDE_PSFT_EMPLOYEEEXPENSEVIOLATIONFACT
EXPVIOLATION_FG
SDE_PSFT_TRANSACTIONTYPEDIMENSION_EMPLOYEEEXPENSE
SDE_PSFT_REASONDIMENSION_EMPLOYEEEXPENSE
SDE_PSFT_PAYMENTMETHODDIMENSION_EMPLOYEEEXPENSE
SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_PROJECT_RESOURCE_CATEGOR
SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_EXPENSE_TYPE
SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_PROJECTTASKTYPE
SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_EXPENSE_PAYMENTMETHOD
SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_PROJECTSERVICETYPE
SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_EXPENSE_REASON
SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_PROJECTANALYSISTYPES

Cause

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