Generate Accounts Process (FAGDA) Ends with Error when Retirement Workflow is Customized (Doc ID 120391.1)

Last updated on AUGUST 16, 2016

Applies to:

Oracle Assets - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FAGDA
Generate Accounts


Symptoms

Submit Generate Accounts (FAGDA) and it fails (you have previously run FAGDA successfully). 

Workflow for retirements is customized.  In the log file:

  DISTRIBUTION_ID: 6002
  DISTRIBUTION_ID: 6004

  Flexbuilder failed to generate a new code combination

  Cause:  The code combination for the generated segment values
  does not exist and cannot be created because it would contain
  invalid segment values.

  Action: Check the account segment value you are using to
  generate a new code combination.

  Error: function &CALLING_FN returned failure
  (CALLED_FN=FAFLEX_PKG_WF.START_PROCESS)
  Flexbuilder failed to generate a new code combination

  Cause:  The code combination for the generated segment values
  does not exist and cannot be created because it would contain
  invalid segment values.

  Action: Check the account segment value you are using to
  generate a new code combination.

  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.GEN_CCID)
  The book_type_code parameter is ABC CORP
  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.GEN_CCID)
  The account type parameter is NBV_GAIN
  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.GEN_CCID)
  The account segment parameter is 900002
  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.GEN_CCID)
  The account CCID parameter is 0
  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.GEN_CCID)
  The default ccid parameter is 33304
  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.GEN_CCID)
  The distribution_ccid parameter is 13858
  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.GEN_CCID)
  ORA-20002: 3103: Attribute 'BOOK_TYPE_CODE' does not exist for
  item 'FAFLEXWF/'.
  Error: function &CALLING_FN returned failure
  (CALLED_FN=FA_GENACCTS_PKG.gen_dist_accts)
  Module FAGDA ended with error
  Error: function &CALLING_FN returned failure
  (CALLED_FN=fa_gendist_pkg.gen_dist_accts).
  ---------------------------------------------
  End of messaged PL/SQL

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