My Oracle Support Banner

ECM 8.1.2.5-Oracle_ASC_Event_Processing Batch Multiple Tasks Failing With ORA-01722: Invalid Number (Doc ID 3059884.1)

Last updated on NOVEMBER 23, 2024

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Goal

We are running the Oracle_ASC_Event_Processing batch which is delivered with patch 8.1.2.5.19. Tasks 40, 42, 43 have all failed with ORA-01722: invalid number. When we extract the query for Task 40 and it looks like there is a type mismatch maybe in this part of the query.

WHERE CASH_TRXN.FO_TRXN_SEQ_ID IN
  (
  SELECT /*+ precompute_subquery */ FCC_AM_EVENT_ENTITY_MAP.V_ENTITY_CD

 When I do a popup describe it looks like CASH_TRXN.FO_TRXN_SEQ_ID is NUMBER(22,0) and FCC_AM_EVENT_ENTITY_MAP.V_ENTITY_CD is VARCHAR2(100 CHAR)
 

Solution

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
Goal
Solution


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