My Oracle Support Banner

GL Rule Execution is Getting Failed With Error "ORA-01747: INVALID USER.TABLE.COLUMN, TABLE.COLUMN, OR COLUMN SPECIFICATION" In GL v8.1 (Doc ID 2856741.1)

Last updated on MARCH 23, 2022

Applies to:

Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

Reconciliation Rule Execution is getting failed for a specific measure (N_OVERDUE_PRIN_AMT) existing in STG_LOAN_CONTRACTS

Error in FSI_GL_DYNAMIC_SQL_ERROR_LOG :

-1747 : ORA-01747: INVALID USER.TABLE.COLUMN, TABLE.COLUMN, OR COLUMN SPECIFICATION

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.