EGL: FSCM 9.1. To 9.2 Image 11 - Step Building The Create And Alter Script Has Warnings (Doc ID 2125112.1)

Last updated on APRIL 10, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Customer received these errors when building the create and alter script

Symptoms

[Updated by GL analyst]

On : FSCM 9.1. to 9.2 Image 11 template, PT8.53.12 to 8.54.10

While executing Step - in Chapter 5 - Building the create and Alter script step, there were a few warnings.

ERROR
-----------------------
Warning: AUC_HDR.AUC_RFX_EDIT_FLG - Default record.field INSTALLATION_AU.AUC_RFX_EDIT_FLG does not exist, field type default used. (76,64)

Warning: BUS_UNIT_TBL_CA.SEPARATE_BIL_REV_F - Default record.field INSTALLATION_CA.SEPARATE_BIL_REV_F does not exist, field type default used. (76,64)

Warning: CA_BILL_PLAN.LOC_REFERENCE_ID - Default record.field CA_CONTR_HDR.LOC_REFERENCE_ID has more than one row, field type default used. (76,65)
Warning: CA_BILL_PLAN_H.LOC_REFERENCE_ID - Default record.field CA_CONTR_HDR.LOC_REFERENCE_ID has more than one row, field type default used. (76,65)
Warning: CA_CONTR_HDR.CONTRACT_ROLE - Default record.field BUS_UNIT_TBL_CA.CONTRACT_ROLE does not exist, field type default used. (76,64)
Warning: CA_RNW_CYCLE.REV_PRICE_BASIS - Default record.field CA_RNW_CYCLE.PRICE_BASIS has no rows, field type default used. (76,66)

Warning: JRNL_CF_BAL_TBL.SETTLEMENT_DT - Default record.field JRNL_CF_BAL_TBL.JOURNAL_DATE cannot be used, field type default used. (76,67)

Warning: JRNL_LN.SETTLEMENT_DT - Default record.field JRNL_HEADER.JOURNAL_DATE cannot be used, field type default used. (76,67)
Warning: JRNL_POST_REQ.SKIP_ESSBASE_LOAD - Default record.field OPR_DEF_TBL_GL.SKIP_ESSBASE_LOAD does not exist, field type default used. (76,64)

Warning: OPR_DEF_TBL_PC.PC_TOT_PER_QTY - Default record.field INSTALLATION_PC.PC_TOT_PER_QTY does not exist, field type default used. (76,64)

Warning: PC_FND.ONE_TARGET_SW - Default record.field PROJECT.ONE_TARGET_SW has more than one row, field type default used. (76,65)
Warning: PROJECT.PM_AUTO_POP - Default record.field PROJ_TYPE_TBL.PM_AUTO_POP does not exist, field type default used. (76,64)

Warning: SP_EX_TIME_INCI - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)

Warning: SP_EXT_TIME_DTL - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SP_EXT_TIME_INC - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_DTA_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_DTA_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_DTA_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_DTA_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_DTA_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_DTA_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIM_DTL_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIM_DTL_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIM_INCIDNT - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIM_INCIDNT - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIME_DTL - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIME_DTL - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIME_WO - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIME_WO - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIME_WO_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TIME_WO_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TM_DTL_HRLY - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TM_DTL_HRLY - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TM_HRLY_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TM_HRLY_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPA_TMINCDT_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPA_TMINCDT_ADJ - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HR_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HR_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HR_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HR_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HR_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HR_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HRA_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HRA_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HRA_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HRA_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HRA_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_HRA_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WO_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WO_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WO_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WO_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WO_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WO_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WOA_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WOA_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WOA_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WOA_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WOA_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPAT_WOA_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTIME_DTL_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTIME_DTL_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTIME_DTL_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTIME_DTL_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTIME_DTL_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTIME_DTL_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLADJ_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLADJ_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLADJ_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLADJ_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLADJ_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLADJ_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLINC_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLINC_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLINC_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLINC_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLINC_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMDTLINC_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMINCADJ_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMINCADJ_TEO1 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMINCADJ_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMINCADJ_TEO2 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)
Warning: SPTMINCADJ_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT from 23.4 to 23.3. processed (76,27)
Warning: SPTMINCADJ_TEO3 - Decimal positions may be lost when converting field TIME_AMOUNT_BSE from 23.4 to 23.3. processed (76,27)



STEPS
-----------------------
The issue can be reproduced at will with the following step:
1. Run Step Building the create and Alter script



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