PMF Issue Post OFSAA Upgrade to 8.1.1 (Doc ID 2909580.1)

Last updated on NOVEMBER 21, 2022

Applies to:

Goal

Platform : 8.1.1.3

Recent change : upgraded from 808 to 8.1.x and executing the workflow for the

first time in this environment.

Issue:

while executing PMF workflow with Run component for a particular FIC_MIS_DAT, it is always passing sysdate in RUN execution(DIM_RUN) entry but for PMF

2) Steps to Reproduce Problem

-----------------------------

Create a workflow with run component and execute it with parameters with

FIC_MIS_DATE to a prior date as of today.

once the workflow is executed verify the DIM_RUN entry table,

for eg: if FIC_MIS_DATE passed from UI as 7th-Sep

In OFSAA log: 

For run component into DIM_RUN:

[DEBUG] [$LOG_INSTANCE]  [NA] [NA] Query ->

INSERT INTO dim_run(N_RUN_SKEY, V_RUN_ID, FIC_MIS_DATE, D_RECORD_START_DATE,

D_RECORD_END_DATE, F_LATEST_RECORD_INDICATOR, V_RUN_EXECUTION_ID,

N_VERSION_NUMBER, V_UNIQUE_ID, V_EXECUTION_DESCRIPTION,

V_VERSION_DESCRIPTION, V_RUN_STATUS, V_RUN_MAIN_ID, V_RUN_MAIN_DESC,

V_RUN_DESC, N_RUN_TYPE_SKEY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?)

Query Parameters as provided -><RUN SKEY>, <RUN ID>, 2022-09-20, 2022-09-20,<other parameters>

ideally the FIC_MIS_DATE should be passed as Sep -7 but since the above execution was run on Sep 20, sysdate is passed as parameter.

Solution

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