My Oracle Support Banner

DEFQ: Unable to export modified records into excel (Doc ID 2560137.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.6.1.0 version, Data Entry Forms and Queries_OFSS

ACTUAL BEHAVIOR
---------------
Unable to export Modified records to excel for a form which uses USERID() function in form filter 

In the below query fired  on click of 'Export' in Data Entry screen, USERID() function is not getting replaced with the actual user, hence the issue

DEFIService.log from $FIC_HOME/logs/ :-

[23-06-19 16:12:31,957 IST PM] [DEBUG] [WEB] [DEFI] [NA] [ABSTRACTDATAENTRYREPOSITORY] Row Value in abstract data entry repository:-Startpagerow::1 RecordSize : null searchFlag::falsQuery::SELECT

DIM_ACCT_STATUS.N_ACCT_STATUS_SKEY a_0, DIM_ACCT_STATUS.V_D_ACCOUNT_STATUS a_1, to_char(DIM_ACCT_STATUS.D_RECORD_END_DATE, 'MM/DD/YYYY HH24:MI:SS') a_2, to_char(DIM_ACCT_STATUS.D_RECORD_START_DATE, 'MM/DD/YYYY HH24:MI:SS') a_3,

to_char(DIM_ACCT_STATUS.FIC_MIS_DATE, 'MM/DD/YYYY HH24:MI:SS') a_4, DIM_ACCT_STATUS.F_LATEST_RECORD_INDICATOR a_5, DIM_ACCT_STATUS.V_ACCT_STATUS_CODE_LVL1 a_6, DIM_ACCT_STATUS.V_ACCT_STATUS_DESC_LVL1 a_7,

DIM_ACCT_STATUS.V_ACCT_STATUS_REG_DISPLAY_CD a_8, DIM_ACCT_STATUS.V_D_ACCOUNT_STATUS_DESC a_9 FROM DIM_ACCT_STATUS WHERE (DIM_ACCT_STATUS.F_LATEST_RECORD_INDICATOR IN ('A','U','R','H') OR

DIM_ACCT_STATUS.F_LATEST_RECORD_INDICATOR IS NULL ) AND (DIM_ACCT_STATUS.V_ACCT_STATUS_DESC_LVL1 = 'EBAUSER') UNION ALL SELECT DIM_ACCT_STATUS_auth.N_ACCT_STATUS_SKEY a_0, DIM_ACCT_STATUS_auth.V_D_ACCOUNT_STATUS a_1, to_char(DIM_ACCT_STATUS_auth.D_RECORD_END_DATE, 'MM/DD/YYYY HH24:MI:SS') a_2, to_char(DIM_ACCT_STATUS_auth.D_RECORD_START_DATE, 'MM/DD/YYYY HH24:MI:SS') a_3, to_char(DIM_ACCT_STATUS_auth.FIC_MIS_DATE, 'MM/DD/YYYY HH24:MI:SS') a_4,DIM_ACCT_STATUS_auth.F_LATEST_RECORD_INDICATOR a_5, DIM_ACCT_STATUS_auth.V_ACCT_STATUS_CODE_LVL1 a_6, DIM_ACCT_STATUS_auth.V_ACCT_STATUS_DESC_LVL1 a_7, DIM_ACCT_STATUS_auth.V_ACCT_STATUS_REG_DISPLAY_CD a_8, DIM_ACCT_STATUS_auth.V_D_ACCOUNT_STATUS_DESC a_9 FROM DIM_ACCT_STATUS_auth WHERE DIM_ACCT_STATUS_auth.V_D_ACCOUNT_STATUS_DESC='EBAUSER' AND (DIM_ACCT_STATUS_auth.V_ACCT_STATUS_DESC_LVL1 = 'USERID()') ORDER BY a_0

 

EXPECTED BEHAVIOR
-----------------------
Similar to authorized and un-authorized records, even modified records should get exported to excel.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Form and save with Authorization
2. Add -> Authorize -> Edit a record
3. After editing a authorized record, the status of authorized record changes to 'Modified' (M) status.
4. Do export the data of form to excel. 

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot export modified records.

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
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.