AFCS Data Visualization reports are Not Working (Doc ID 2912903.1)

Last updated on DECEMBER 06, 2022

Applies to:

Symptoms

AFCS- Data visualization

While generating the reports under data visualization, below error is getting reported for all the entities

UI error:

Odbc driver returned an error (SQLExecDirectW)
ORA- 01017: Invalid user name/Password; login denied

Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your
service administrator review this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your
service administrator review this error. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
Please have your
service administrator review this error. (HY000)
State: HY000. Code: 17025. [nQSError: 17025] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied
at OCI call OCISessionBegin.
Please have your
service administrator review this error. (HY000)
State: HY000. Code: 17014.
Please have your
service administrator review this error. (HY000)
SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT
0 s_0,
XSA('weblogic'.'Accounting Entries')."Columns"."Account Currency Code" s_1,
XSA('weblogic'.'Accounting Entries')."Columns"."Account Ledger Tag Code" s_2,
XSA('weblogic'.'Accounting Entries')."Columns"."Account Module Type" s_3,
XSA('weblogic'.'Accounting Entries')."Columns"."Account Or Contract Number" s_4,
XSA('weblogic'.'Accounting Entries')."Columns"."Account Transaction Type" s_5,
XSA('weblogic'.'Accounting Entries')."Columns"."Accounting Entry Identifier" s_6,
XSA('weblogic'.'Accounting Entries')."Columns"."Accounting Period" s_7,
XSA('weblogic'.'Accounting Entries')."Columns"."Accounting Standard Code" s_8,
XSA('weblogic'.'Accounting Entries')."Columns"."Acquisition Channel Code" s_9,
XSA('weblogic'.'Accounting Entries')."Columns"."Amount Tag Code" s_10,
XSA('weblogic'.'Accounting Entries')."Columns"."As Of Date" s_11,
XSA('weblogic'.'Accounting Entries')."Columns"."Authorization Flag" s_12,
XSA('weblogic'.'Accounting Entries')."Columns"."Authorizer Identifier" s_13,
XSA('weblogic'.'Accounting Entries')."Columns"."Batch Code" s_14,
XSA('weblogic'.'Accounting Entries')."Columns"."Branch Code" s_15,
XSA('weblogic'.'Accounting Entries')."Columns"."Business Segment Code" s_16,
XSA('weblogic'.'Accounting Entries')."Columns"."Business Unit Code" s_17,
XSA('weblogic'.'Accounting Entries')."Columns"."Canceled Pairing Transaction Identifier" s_18,
XSA('weblogic'.'Accounting Entries')."Columns"."Canceling Flag" s_19,
XSA('weblogic'.'Accounting Entries')."Columns"."Conversion Type" s_20,
XSA('weblogic'.'Accounting Entries')."Columns"."Counterparty Reference Code" s_21,
XSA('weblogic'.'Accounting Entries')."Columns"."Created By" s_22,
XSA('weblogic'.'Accounting Entries')."Columns"."Data Source Code" s_23,
XSA('weblogic'.'Accounting Entries')."Columns"."Debit Credit Indicator" s_24,
XSA('weblogic'.'Accounting Entries')."Columns"."Error Code Description" s_25,
XSA('weblogic'.'Accounting Entries')."Columns"."Error Code" s_26,
XSA('weblogic'.'Accounting Entries')."Columns"."Financial Cycle Code" s_27,
XSA('weblogic'.'Accounting Entries')."Columns"."General Ledger Account Code" s_28,
XSA('weblogic'.'Accounting Entries')."Columns"."Header Identifier" s_29,
XSA('weblogic'.'Accounting Entries')."Columns"."Instrument Code" s_30,
XSA('weblogic'.'Accounting Entries')."Columns"."Inter Brach Flag" s_31,
XSA('weblogic'.'Accounting Entries')."Columns"."Intercompany Identifier" s_32,
XSA('weblogic'.'Accounting Entries')."Columns"."Ledger Flag" s_33,
XSA('weblogic'.'Accounting Entries')."Columns"."Ledger Identifier" s_34,
XSA('weblogic'.'Accounting Entries')."Columns"."Legal Entity Code" s_35,
XSA('weblogic'.'Accounting Entries')."Columns"."Local Currency Code" s_36,
XSA('weblogic'.'Accounting Entries')."Columns"."Location Code" s_37,
XSA('weblogic'.'Accounting Entries')."Columns"."Module Suspense Flag" s_38,
XSA('weblogic'.'Accounting Entries')."Columns"."Organization Unit Code" s_39,
XSA('weblogic'.'Accounting Entries')."Columns"."Original Entry Identifier" s_40,
XSA('weblogic'.'Accounting Entries')."Columns"."Party Identifier" s_41,
XSA('weblogic'.'Accounting Entries')."Columns"."Processin

Changes

 NA

Cause

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