My Oracle Support Banner

PLP_GLBALANCEAGGRBYACCTSEGCODS session fails with "ORA-01722: invalid number" (Doc ID 1405664.1)

Last updated on NOVEMBER 12, 2019

Applies to:

Business Intelligence Applications Observer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

PLP_GLBalanceAggrByAcctSegCodes was hit with performance issue, runs about 5 to 6 hrs to finish.

To resolve the performance issue, user had applied the performance recommendation fix/patch from Oracle Business Intelligence Applications Release Notes 7.9.6.3, Section 1.3.29 Performance Issue with PLP_GLBALANCEAGGRBYACCTSEGCODS

However, the Informatica session now fails with below error:

SQL Error [
ORA-01722: invalid number

ORA-01722: invalid number

Database driver error...
Function Name : Fetch
SQL Stmt : SELECT /*+ OPT_PARAM('_GBY_HASH_AGGREGATION_ENABLED', 'true') USE_HASH(W_GL_BALANCE_F, W_GL_ACCOUNT_D) */ W_GL_BALANCE_F.LEDGER_WID, W_GL_BALANCE_F.PROFIT_CENTER_WID, W_GL_BALANCE_F.COMPANY_ORG_WID, W_GL_BALANCE_F.BUSN_AREA_ORG_WID, W_GL_ACCOUNT_D.GROUP_ACCT_WID, W_GL_BALANCE_F.BALANCE_DT_WID, W_GL_BALANCE_F.BALANCE_TM_WID, ..

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


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