R12 CIP And Reserve Summary Reports In XML Generated With Flexfield Error ORA-6512, ORA-20100 (Doc ID 1482497.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Assets - Version 12.1.1 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.

FASRSVES_XML

Symptoms

CIP and Reserve Summary Reports with XML are ending in error.

Error
-----------------------
ORA-20100:
  kff_segments_metadata(acct_cc_lprompt, SQLGL, GL#, FA_COST_CTR, Y,
  LEFT_PROMPT) raised exception.
  ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
  ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
  ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 2006
  ORA-20100: get_kff_str(101, GL#) raised exception.
  ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
  ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
  ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 958
  ORA-20101: <Key Flexfield Structure> does not exist. Primary Key:
  APPLICATION_ID:'101', ID_FLEX_CODE:'GL#', ID_FLEX_NUM:''
  ORA-01403: no data found
  ORA-06512: at line 2

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