My Oracle Support Banner

EAM: PS_INSTALAM_BTF_VW Fails (Doc ID 2409844.1)

Last updated on JUNE 11, 2018

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

While upgrading from FSCM 9.2.08 to 9.2.26 (Tools version 8.55.11), the PS_INSTALAM_BTF_VW create view SQL abended.

Error
----------

19:30:03 SQL CREATE VIEW PS_INSTALAM_BTF_VW (TYPE_ADD, TYPE_ADJUSTMENT,
19:30:03 2 TYPE_TRANSFER, TYPE_DEPR, TYPE_PRIOR_DEPR, TYPE_RECATEGORIZE,
19:30:03 3 TYPE_RESERVE_ADJ, TYPE_RETIRE, TYPE_REINSTATE, TYPE_LEASE_PAYMENT,
19:30:03 4 TYPE_BOOK_CHANGE, TYPE_SUSPEND, TYPE_RESUME, TYPE_BUDGET_DEPR,
19:30:03 5 TYPE_LEASE_PAY_BUD, TYPE_INFLATION, TYPE_RRC, LAST_INTFC_ID,
19:30:03 6 JV_PROCESS_SW, GROUP_PROC_SW, INFL_ADJ_SW, ACCT_ENT_TMPL_ID,
19:30:03 7 CHILD_TK_PARENT_SW, ARCHIVE_ID, ACCUM_DEPR, NET_BK_VALUE, DEPR_CUR,
19:30:03 8 CURRENT_FY_PDP, CURRENT_FY_PDP_GRP, IMPAIR_FLG, IMP_ZERO_COST_ROWS,
19:30:03 9 LAST_CNTRCT_NO, BATCH_LIMIT, SPACE_MGMT_FLAG, IT, FILE_SIZE,
19:30:03 10 DISCO_REQ_TIMEOUT, EFFECTIVE_RATE_SW, NEG_DEPR_SW, REVALUE_FLG,
19:30:03 11 ARM_SRC_FLG, CURRENCY_CD, RT_TYPE, FIN_IMPACT_FLG, TXN_CURR_SW,
19:30:03 12 CAP_THRSHLD_SW, LAST_INSTANCE_TMP, ARO_SW, TYPE_ACCRETION,
19:30:03 13 PCCF_PASSTHRU_SW, EXP_DEC_POS, TYPE_PLEASE_PAY, AM_FED_FUND_ATTR) AS
19:30:03 14 SELECT * FROM PS_INSTALLATION_AM
19:30:03 15 CREATE VIEW PS_INSTALAM_BTF_VW (TYPE_ADD, TYPE_ADJUSTMENT,
  *
ERROR at line 1:
ORA-01730: invalid number of column names specified


Steps
--------------
This issue can be verified by performing the following steps:

1) Upgrade from image 08 to image 26 in the 9.2 release.

Business Impact
---------------------
The customer cannot complete the upgrade.

Changes

 

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!


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