My Oracle Support Banner

OBIA 7.9.6.4 SDE_PSFT_PurchaseScheduleLinesFact And SDE_PSFT_PurchaseCostFact Fail on Full Load (Doc ID 1572802.1)

Last updated on FEBRUARY 23, 2021

Applies to:

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

Symptoms

SDE_PSFT_PurchaseScheduleLinesFact and SDE_PSFT_PurchaseCostFact tasks fail on full load with the following errors in the workflow logs:

Severity Timestamp Node Thread Message Code Message
ERROR <TIMESTAMP> <NODE_NAME> 1406007616 LM_36488 Session task instance [SDE_PSFT_PurchaseScheduleLinesFact_Full] : [TM_6193 An error occurred while expanding the connection parameter [Database connection name DataWarehouse for database connection variable $Target is not well defined.
].]

and

Severity Timestamp Node Thread Message Code Message
ERROR <TIMESTAMP> <NODE_NAME> 1426987328 LM_36488 Session task instance [SDE_PSFT_PurchaseCostFact_Full] : [TM_6193 An error occurred while expanding the connection parameter [Database connection name PSFT_9_1_FINSCM for database connection variable $DBConnection_OLTP is not well defined.
].]


Some other similar workflows complete successfully, e.g. SDE_PSFT_GLBalanceFact_Derive_Full, SDE_PSFT_GLJournals_Extract, in the same execution plan with the same source. You have defined the DataWarehouse and PSFT_9_1_FINSCM connections in the DAC and in the Informatica connection manager.

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!


In this Document
Symptoms
Changes
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.