Problem:
After installing Enterprise FSCM 9.0 PeopleBooks and bouncing PeopleBooks web server, they do not appear in the list of PeopleBooks.
Solution:
Enterprise FSCM 9.0 PeopleBooks installed to wrong directory. It should be installed to the htmldoc directory:
E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warhtmldoc
Problem:
After running the SYSAUDIT report, the following errors appear under Integration Broker Audits:
(IBRK-08): IB Routing referencing invalid service operation:
Routing Operation Version
– —— ——— ——-
~GEN~UPG~24567 IB_INST_VER_ASYNC_MSG VERSION_1
~GEN~UPG~17626 IB_INST_VER_RESP_MSG VERSION_1
2 Total Rows
Solution:
Delete the above two routings:
1. Query records that appear in Integration Broker Audit section IBRK-08
select * from PSIBRTNGDEFN where ROUTINGDEFNNAME = ‘~GEN~UPG~24567’ or ROUTINGDEFNNAME = ‘~GEN~UPG~17626’
2. Launch PIA and search for the page that contains these values. Navigate to Integration Broker > Integration Setup > Routings. In the Find an Existing Value tab, in the Routing Name begins with field, enter ~GEN~UPG~24567. Click Search. It returns ‘No matching values were found.’ Then click the Add a New Value tab. The record appears.
3. Type Ctrl + J to get the page information. Note the Page (IB_ROUTINGDEFN).
4. On GL-WEB-APP, launch Application Designer. Insert Definitions into Project. Choose Definition Type Page and enter IB_ROUTINGDEFN in the Name field. Then press Enter. Insert the IB_ROUTINGDEFN page.
5. Right-click the Service Operation field, and choose Field Definition. In the Record Definition, choose Record Field Properties. Click the Edits tab and note the Prompt Table: PSOPERATION.
select * from PSOPERATION
select * from PSOPERATION where IB_OPERATIONNAME = ‘IB_INST_VER_RESP_MSG’ or IB_OPERATIONNAME = ‘IB_INST_VER_ASYNC_MSG’
6. Delete the two routings above (~GEN~UPG~24567 and ~GEN~UPG~17626). In PIA, navigate to PeopleTools > Integration Broker > Service Utilities > Service Administration. Select the Routings tab, and expand the Delete section. For each routing name (~GEN~UPG~24567 and ~GEN~UPG~17626), enter the Routing Name and click Search. The routing name appears. Check Select and then click Delete.
Reference:
E-IB: IBRK-xx SYSAUDIT exceptions after applying Maintenance Pack(s) (Doc ID 654766.1)
EFSCM: Orphan routing issue for FSCM9 customers after upgrading to 8.49 tools (Doc ID 661088.1)
[amazon asin=0071664939&template=iframe image&chan=default] [amazon asin=1430237074&template=iframe image&chan=default] [amazon asin=0071787925&template=iframe image&chan=default]
DDDAUDIT Errors After Running FSCM MP5
Problem:
After completing FSCM MP5, the DDDAUDIT report is run. The following errors appear:
(TABLE-2) SQL Table defined in the Application Designer and not found in the Database: Record Name Ownerid --------------- ------- BP_ACT2_TAO FGL BP_APA_S_TAO FAP BP_APN_S_TAO FAP BP_APV_S_TAO FAP BP_ARM_S_TAO FAR BP_ARR_S_TAO FAR BP_BDHDR_TAO FGL BP_BDLN_TAO FGL BP_BI_S_TAO DBI BP_BKOUT_TAO FGL BP_CF_TAO FGL BP_CM_S_TAO DCM BP_EX_S_TAO FEX BP_FSRC_TAO FGL BP_GEN_S_TAO FGL BP_GLB_S_TAO FGL BP_GL_S_TAO FGL BP_GM_S_TAO FGM BP_HR_S_TAO FGL BP_LQDFS_TAO FGL BP_LQD_TAO FGL BP_PC1_S_TAO FPC BP_PC_S_TAO FPC BP_PFS1_TAO FGL BP_PFS2_TAO FGL BP_POA_S_TAO DPO BP_POC_S_TAO DPO BP_PO_S_TAO DPO BP_PRNT_TAO FGL BP_PST1_TAO FGL BP_PST2_TAO FGL BP_REFDBK_TAO FGL BP_REFD_TAO FGL BP_RQN_S_TAO DPO BP_RQ_S_TAO DPO BP_TA_S_TAO FEX BP_XCF2_TAO FGL BP_XCF_TAO FGL BP_XLBP_TAO FGL EX_ADVLN_TAO FEX EX_ADVLSS_TAO FEX EX_STGSHT_TMP FEX FS_CE_CFV_TAO FGL VUN_DOC_TAO FAP VUN_RVS_TAO FAP VUN_UNP_TAO FAP 46 Total Rows (TABLE-3) SQL Table defined in the Database and not found in the Application Designer: SQL Table Name ------------------ PS_VNDR_ORDER_TMP PS_VNDR_REMIT_TMP PS_WEBLIB_EX_TV 3 Total Rows (TABLE-4)INFORMATIONAL ONLY - Tablespace not defined for SQL Table in the Application Designer: No rows found. (TABLE-5) Table Contains More Than 500 Fields : No rows found. (VIEWS-1) Views defined in the Application Designer and not found in the Database: No rows found. (VIEWS-2) Views defined in the Database and not found in the Application Designer: No rows found. (INDEX-1) Index defined in the Application Designer and not found in the Database: Record Name Index ID Ownerid --------------- -------- ------- BP_ACT2_TAO A FGL BP_ACT2_TAO B FGL BP_ACT2_TAO _ FGL BP_APA_S_TAO A FAP BP_APA_S_TAO B FAP BP_APA_S_TAO _ FAP BP_APN_S_TAO A FAP BP_APN_S_TAO B FAP BP_APN_S_TAO _ FAP BP_APV_S_TAO A FAP BP_APV_S_TAO B FAP BP_APV_S_TAO _ FAP BP_ARM_S_TAO A FAR BP_ARM_S_TAO _ FAR BP_ARR_S_TAO A FAR BP_ARR_S_TAO _ FAR BP_BDHDR_TAO 0 FGL BP_BDHDR_TAO _ FGL BP_BI_S_TAO A DBI BP_BI_S_TAO B DBI BP_BKOUT_TAO A FGL BP_CF_TAO A FGL BP_CF_TAO B FGL BP_CM_S_TAO A DCM BP_CM_S_TAO B DCM BP_CM_S_TAO _ DCM BP_EX_S_TAO A FEX BP_EX_S_TAO B FEX BP_EX_S_TAO _ FEX (INDEX-1) Index defined in the Application Designer and not found in the Database:(continued) Record Name Index ID Ownerid --------------- -------- ------- BP_FSRC_TAO A FGL BP_GEN_S_TAO A FGL BP_GEN_S_TAO _ FGL BP_GLB_S_TAO A FGL BP_GLB_S_TAO _ FGL BP_GL_S_TAO A FGL BP_GL_S_TAO _ FGL BP_GM_S_TAO A FGM BP_GM_S_TAO B FGM BP_HR_S_TAO A FGL BP_HR_S_TAO B FGL BP_LQDFS_TAO A FGL BP_LQD_TAO A FGL BP_PC1_S_TAO A FPC BP_PC1_S_TAO B FPC BP_PC_S_TAO A FPC BP_PC_S_TAO B FPC BP_POA_S_TAO A DPO BP_POA_S_TAO B DPO BP_POC_S_TAO A DPO BP_POC_S_TAO _ DPO BP_PO_S_TAO A DPO BP_PO_S_TAO B DPO BP_PO_S_TAO _ DPO BP_PST1_TAO A FGL BP_REFDBK_TAO A FGL BP_REFD_TAO A FGL BP_RQN_S_TAO A DPO BP_RQN_S_TAO _ DPO BP_RQ_S_TAO A DPO BP_RQ_S_TAO _ DPO BP_TA_S_TAO A FEX BP_TA_S_TAO _ FEX BP_XCF_TAO A FGL BP_XCF_TAO B FGL BP_XCF_TAO C FGL EX_ADVLN_TAO A FEX EX_ADVLN_TAO _ FEX EX_ADVLSS_TAO _ FEX EX_STGSHT_TMP A FEX EX_STGSHT_TMP B FEX EX_STGSHT_TMP _ FEX FS_CE_CFV_TAO A FGL VUN_DOC_TAO _ FAP VUN_RVS_TAO _ FAP VUN_UNP_TAO _ FAP 75 Total Rows
Solution:
See the Acceptable Audit Errors section on page 53 for tips to resolving these errors, including deleting the tables under section TABLE-3
To rebuild the tables under the TABLE-2 section of the DDDAUDIT report, the RBL_MP5ERRORS_VS project was created in Application Designer and the SQL script was built to create the missing tables.
Problem:
After completing installing FSDEMO, SYSAUDIT is run. The following errors appear on the report:
Application Engine Audits Result: OK Clear List Audits Result: OK Electronic Commerce Audit Result: OK Field Definition Audit Result: OK Menu Definition Audit Result: OK Security Audits Result: Exception(s) Found (SEC-30) Role User table (ROLEXLATOPR) should be populated when new User Profiles (entries in PSOPRDEFN) are created using User Profile component through PIA. The following User Profiles need to be fixed by simply opening and saving them through PIA: Oper ID Description - ----------------------------- ------------------------------ ENTMGR_PRO Procurement Catalog Manager 1 Total Rows Page Definition Audit Result: OK PeopleCode Definition Audit Result: OK Process Scheduler Audit Result: OK Query Definition Audit Result: Exception(s) Found (QUERY-27) Following Queries Use XLAT Fields Whose Values Do not Exist In PSXLATITEM Table: Query Name Field Name - --------------------------------------------------------------------- ARDISH01 DRAFT_TYPE 1 Total Rows Record Definition Audit Result: OK Language Definition Audit Result: OK SQL Audits Result: OK Tree Definition Audit Result: OK Version Check Audits Result: OK XLATT Definition Audit Result: OK Analytic Audit Result: OK XML Publisher Audit Result: OK Integration Broker Audits Result: Exception(s) Found (IBRK-08) : IB Routing referencing invalid service operation: Routing Operation Version - ------ --------- ------- ~GEN~UPG~24567 IB_INST_VER_ASYNC_MSG VERSION_1 ~GEN~UPG~17626 IB_INST_VER_RESP_MSG VERSION_1 2 Total Rows (IBRK-21) : Operations with duplicate routings: Operation Version Routing - -------- ------- ------- QAS_CRASH_MSG VERSION_1 ~GEN_UPG~18727 QAS_CRASH_MSG VERSION_1 ~GEN~UPG~19278 2 Total Rows
Solution:
Apply the latest Financials/SCM Maintenance Pack to resolve some of these errors.
Problem:
After deploying files from MP5, the COBOL programs must be compiled. However, some files do not compile:
E:tempcompile>set PS_HOME=E:PSOFTFS900
E:tempcompile>set COBROOT=E:cobolBase
E:tempcompile>cd /d E:PSOFTFS900setup
E:PSOFTFS900setup>cblbld E: tempcompile
ASCII Cobol Compilations Proceeding
Logging progress to file E:tempcompileCBLBLD.LOG
COBOL compiler found in E:cobolBase
Target directory (E:PSOFTFS900CBLBINA) exists and is writable
Copying source files …
Building the COBOL targets …
File(s) that failed to compile or link:
.
Compile error for CPPIPRDN.obj
Compile error for INPFVALD.obj
Compile error for INPGPROC.obj
Compile error for INPGREPL.obj
Compile error for INPJIURV.obj
Compile error for INPPPROC.obj
Compile error for INPTVALD.obj
Compile error for INPVPROC.obj
Compile error for INPVVALD.obj
Compile error for INPZPWFB.obj
Compile error for SFPBPCFG.obj
Compile error for SFPDCDRV.obj
Compile error for SFPDCOMP.obj
Compile error for SFPDCVAL.obj
Compile error for SFPDISUE.obj
Compile error for SFPSGBRC.obj
Compile error for SFPSUPDT.obj
Compile error for SFPSVALD.obj
The error list is in E:tempcompileERROR.LIS
.
Aborting this process !!! EXEs/GNTs/INTs are not going to be copied/replaced…
.
Please fix the errors and rerun this batch file !!!!!!!
.
Symptoms:
The problem is with COBOL compiles, where if the customer doesn’t have all the products licensed when we compile the COBOLs from recent Maintenance Packs we get errors. This is due to the fact that CA is not looking at the licensed products or dbcodes to validate licensed products. Therefore errors are displayed during the compilation as copybooks are not supplied for the non licensed products.
Here’s an example list of the COBOLs that don’t compile:
CEPCSQL2, CPPICSTI, CPPIPRDN, INPADYN3, INPADYN4, INPAPROC, INPIVALD, INPOTEST, INPSDRCT, INPVIADJ, INPVPROC, INPVVALD, INPXPROC, SFPDISUE, SFPEPROC, SFPFPROC, SFPREVAL
Here’s a copy of what’s in the dbcodes.ep:
EP PeopleSoft FIN/SCM Database
EP PeopleSoft FIN/SCM Demo Database
AM PeopleSoft Asset Management
CM PeopleSoft Cash Management
CO PeopleSoft Common Objects
TR = PeopleSoft Deal Management
EO = PeopleSoft Enterprise Components
EPO = PeopleSoft eProcurement
GL = PeopleSoft General Ledger
AP = PeopleSoft Payables
PO = PeopleSoft Purchasing
Cause:
Not Applicable
Solution:
Tools incident 714685000 was created. The incident is considered to be an enhancement for change assistant in a tools versions greater than 8.45.
If the customer does not have licenses for the modules related to the cobol files that are failing, they can ignore the compile errors. If they do not want to ignore the error messages, they can remove the erroring files from the src directory (move them to another directory) and run compile again.
Reference:
E-CA Change assistant not checking the license before compiling the cobols (Doc ID 623178.1)
Problem:
After installing PeopleSoft Financials, the COBOL batch programs not running.
Solution:
1. Download Micro Focus Cobol Net Express Edition from:
http://www.download.com/Net-Express-with-NET/3000-2069_4-10866201.html
http://microfocus.com/products/netexpress/
http://microfocus.com/products/netexpresswithnet/index.asp
2. Install Micro Focus Cobol Net Express With .Net on the batch server. Disable the option to install .Net, as it will require Microsoft Visual Studio 2008.
DDDAUDIT Errors after Partially Running Change Assistant (FSCM MP5)
Problem:
After partially running Change Assistant (FSCM MP5), many errors are appearing on the DDDAUDIT.sql report (e.g. objects are now missing from the database):
PeopleSoft
Report Name :DDDAUDIT APPLICATION DESIGNER/DATABASE AUDIT REPORT Page No : 1
Database Name: Run Date: 11/25/2008
Platform :WINDOWS-NT DBType: Microsoft SQL Server Run Time: 15:57:39
(TABLE-1) SQL Table Names defined in the
Application Designer that are not blank and
not the same as the Record Name: No rows found.
(TABLE-2) SQL Table defined in the
Application Designer and not found in the
Database:
Record Name Ownerid
————— ——-
AE_DETIJ_AET TTS
AE_DETIS_AET TTS
AE_DETW_AET TTS
AE_PEPXPLOD_AET TTS
AM_EXT_AUD_DTL FAM
AM_EXT_AUD_HDR FAM
AM_JE_DTL_TMP FAM
APS8003_RPT FAP
AP_APS8003_AET FAP
AP_DAM_LTD_T FAP
AP_IU_LN2_AET FGL
AP_IU_LN_AET FGL
AP_MTVLN5A_T FAP
BP_ACT2_TAO FGL
BP_ACTFS_TAO FGL
BP_ACT_TAO FGL
BP_APA_S_TAO FAP
BP_APN_S_TAO FAP
BP_APV_S_TAO FAP
BP_AREV_G_TAO FGL
BP_ARM_S_TAO FAR
BP_ARR_S_TAO FAR
BP_ASEXLG_TAO FGL
BP_BDHDR_TAO FGL
BP_BDLN_TAO FGL
BP_BI_S_TAO DBI
BP_BKOUT_TAO FGL
BP_BP_TAO FGL
BP_CF_TAO FGL
BP_CM_S_TAO DCM
BP_EE_TAO FFA
BP_EXCPTN_TAO FGL
BP_EX_S_TAO FEX
BP_FSRC_TAO FGL
BP_GEN_S_TAO FGL
BP_GLB_S_TAO FGL
BP_GL_S_TAO FGL
BP_GM_S_TAO FGM
BP_HR_S_TAO FGL
BP_KKAMT_TAO
BP_LEDGER_TAO FGL
BP_LGRP_TAO FGL
BP_LQDFS_TAO FGL
BP_LQD_TAO FGL
BP_PC1_S_TAO FPC
BP_PC_S_TAO FPC
BP_PFS1_TAO FGL
BP_PFS2_TAO FGL
BP_POA_S_TAO DPO
BP_POC_S_TAO DPO
BP_PO_S_TAO DPO
BP_PRNT_TAO FGL
PeopleSoft
Report Name :DDDAUDIT APPLICATION DESIGNER/DATABASE AUDIT REPORT Page No : 2
Database Name: Run Date: 11/25/2008
Platform :WINDOWS-NT DBType: Microsoft SQL Server Run Time: 15:57:39
(TABLE-2) SQL Table defined in the
Application Designer and not found in the
Database: (continued)
Record Name Ownerid
————— ——-
BP_PST1_TAO FGL
BP_PST2_TAO FGL
BP_REFDBK_TAO FGL
BP_REFD_TAO FGL
BP_RFLDS_TAO FGL
BP_RQN_S_TAO DPO
BP_RQ_S_TAO DPO
BP_TA_S_TAO FEX
BP_XCF2_TAO FGL
BP_XCF_TAO FGL
BP_XLBP_TAO FGL
BS_BLD_PROJ ENV
BS_MRG_PRJ_AET ENV
BS_PRJ_MRG_RN ENV
CA_CH_APS_TA1 FCA
CE_LOP_PROC_T DCM
DEPR_RP43_TMP FAM
DEPR_RP50_TMP FAM
DEPR_RP51_TMP FAM
DIST_LN3_TAO FAM
DIST_LN4_TAO FAM
DP_CALCLIB_RC DDP
DP_DDH_BI_TAO DDP
DP_DDH_CK_TAO DDP
DP_DDH_CP_TAO DDP
DP_DDH_IN_TAO DDP
DP_DDH_KN_TAO DDP
DP_DDH_OM_TAO DDP
DP_DDH_SO_TAO DDP
DP_FCADJHSTAO DDP
DP_FCITEMSDRV DDP
DP_FCITEMSTAO DDP
DP_FCITMDRV_AET DDP
DP_FCITMD_TAO DDP
DP_FCPRDS_TAO DDP
DP_FCWRKQMTAO DDP
EXPLODE_IDS TTS
EXPLODE_IDS_NUM TTS
EXP_CHUNK_TMP TTS
EXP_CTRL TTS
EXP_FIELD_SEQ TTS
EXP_PROJ TTS
EXP_RECDEFN TTS
EXP_RECFIELD TTS
EXP_REQUEST TTS
EXP_REQUEST_OPT TTS
EXP_SEQ TTS
EXP_STMT TTS
EXP_STMT_CHUNK TTS
EXP_TBL TTS
EX_ADVLN_TAO FEX
EX_ADVLSS_TAO FEX
EX_ADV_HDR_TMP FEX
EX_ADV_HDR_TMP2 FEX
EX_BCHK_ERTAO
EX_PYNTFY_TAO FEX
EX_PYNTFY_TBL FEX
PeopleSoft
Report Name :DDDAUDIT APPLICATION DESIGNER/DATABASE AUDIT REPORT Page No : 3
Database Name: Run Date: 11/25/2008
Platform :WINDOWS-NT DBType: Microsoft SQL Server Run Time: 15:57:39
(TABLE-2) SQL Table defined in the
Application Designer and not found in the
Database: (continued)
Record Name Ownerid
————— ——-
EX_STGSHT_TMP FEX
FS_CE_CFS_TAO FGL
FS_CE_CFV_TAO FGL
GBR_RUN_CTL_CIS FAP
GL_ACCT_ENTRY AGC
IN_ALMDMND_AET DIN
IN_DEMAND1_T DPO
IN_RLS_OPCK_TAO DIN
IN_UNDOSDPTAO DIN
IN_UNDOSETTAO DIN
JRNL_IUW2_AET FGL
JRNL_IUWK_AET FGL
KK_DUP_SHDR FGL
KK_SHDR_TAO FGL
OCH_ITLD_TAO DOM
OCH_LOCK_TAO DOM
OMA_LOCK_TAO DOM
OMB_ITLD_TAO DOM
OMB_LOCK_TAO DOM
OMCB_LOCK_TAO DOM
OMD_LOCK_TAO DOM
OMEC_OUTLS_INF DOM
OME_ITLD_TAO DOM
OME_LOCK_TAO DOM
OMH_LOCK_TAO DOM
ORD_HEADER_LOCK DOM
PC_BUD_SM_TMP FPC
PC_OLT_TAO FPC
PG_PNVAT3_TAO FAR
POP_PROJ TTS
POP_SEQ TTS
POP_TBL TTS
PST_APPCT_TMP FAP
PST_WVCH_TMP FAP
RECV_ASN_DIST2 DPO
REC_COUNT TTS
REC_COUNT_WRK2 TTS
REQ_CHG_HDR_T DPO
REQ_CHG_LN_T DPO
REQ_CHG_ORD_TMP DPO
REQ_CHG_SHP_T DPO
REQ_CNCL_CO_TMP DPO
RUN_TDS_ANNEXUR FLC
RUN_TDS_QRETURN FLC
RVL_AR_TAO FAR
SF1219_DTL_TBL FGL
SF1219_SUM_TBL FGL
SF1219_TMP_TBL FGL
SUMLED_REQ_BU FGL
TDS_QRETURN_DTL FLC
TDS_QRETURN_TAO FLC
TDS_QRETURN_TBL FLC
TDS_QRET_NMHDR FLC
TDS_QRET_NUM FLC
TDS_REP_TBL FLC
TT_WRK2 TTS
UPD_QTY_TMP
Solution:
Run Application Designer.
In a new project, click Insert > Definitions Into Project
Search for and insert all Records and Indexes
Click Build > Project
Click Settings. Ensure the following are set:
• Skip table if it already exists
• Recreate view if it already exists
• Recreate index only if modified
Check Create Tables and Create Views
Recent Comments