TriniDBA

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.