R12 FSG RGRXFR TRANSFER PROGRAM ORA-00932 INCONSISTENT DATA TYPES ORA-22992 (Doc ID 1533354.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to migrate existing FSG components from one instance to another -

  The FSG Transfer program (RGRXFR module) request fails with error
  "ERROR: Encountered error while transferring row set for report 'xxx'.
  Aborting transfer of this report.
 
  Patch 8909490 has already been applied
 
 
  Log shows :
 
 
  LOG: Program Arguments:
  > Component Type:  RG_REPORT
  > Target COA Id:   50368
  > Source DB Id:    2
  > Component Name:  Consol Balances Verif
  > Source COA Name: PRIMARY_LEDGER
  LOG: Entering routine 'copy_component' with parameters: 1) RG_REPORT, 2)
  Consol Balances Verif, 3) &PARAM3, 4) &PARAM4
  LOG: Entering routine 'copy_single_component' with parameters: 1) RG_REPORT,
  2) Consol Balances Verif, 3) &PARAM3, 4) &PARAM4
 
 
 
  SQL: Executing:
  INSERT INTO RG_REPORT_AXIS_SETS (  APPLICATION_ID, AXIS_SET_
  ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CR
  EATION_DATE, CREATED_BY, NAME, AXIS_SET_TYPE, SECURITY_FLAG,
   DISPLAY_IN_LIST_FLAG, PERIOD_SET_NAME, DESCRIPTION, COLUMN_
  SET_HEADER, ROW_SET_TITLE, SEGMENT_NAME, ID_FLEX_CODE, STRUC
  TURE_ID, CONTEXT   , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 ,
  ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUT
  E8 , ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATT
  RIBUTE13, ATTRIBUTE14, ATTRIBUTE15, TAXONOMY_ID) SELECT  APP
  LICATION_ID, :id     , SYSDATE    , :user_id, :login_id  , S
  YSDATE    , :user_id   , NAME     , AXIS_SET_TYPE, 'N', DISP
  LAY_IN_LIST_FLAG, PERIOD_SET_NAME, DESCRIPTION, null       ,
   ROW_SET_TITLE, SEGMENT_NAME, ID_FLEX_CODE, 50368    , CONTE
  XT    , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 ,
  ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUT
  E9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATT
  RIBUTE14, ATTRIBUTE15, NULL  FROM RG_REPORT_AXIS_SETS@AFOPMA
  P0_FSG.MIA.CUSTOMER.COM WHERE axis_set_id = 5000
  LOG: Entering routine 'copy_column_set_header' with parameters: 1) 5000, 2)
  13010, 3) &PARAM3, 4) &PARAM4
  LOG: EXCEPTION RAISED! Error number: -932. Error message:
  SQL: Executing:
 
 ORA-00932: inconsistent datatypes: expected CHAR got LONG
  
  LOG: Exiting routine 'copy_axis_set' with error.
  ERROR: Encountered error while transferring column set for report 'MX Consol
  Balances Verif'. Aborting transfer of this report.
  LOG: Exiting routine 'copy_report' with error.
  .
  Encountered error while transferring report 'Consol Balances Verif'.
  Cancelling transfer of this report.

Or Error:

LOG: EXCEPTION RAISED! Error number: -22992. Error message:
SQL: Executing:
> ORA-22992: cannot use LOB locators selected from remote tables

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms