Tag Archives: ROLEXLATOPR

(SEC-30) Role User table (ROLEXLATOPR) should be populated

Posted by on January 20, 2009 No comments

Problem:

After running SYSAUDIT, the following error appears:

(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

Solution:

1. Launch the PeopleSoft instance (PIA) and log on as a user with access to the PeopleTools responsibility.
2. Navigate to PeopleTools > Security > User Profiles > User Profiles.
3. Click Search, and choose ENTMGR_PRO (Procurement Catalog Manager).
4. Make a change to the record (e.g. change Language Code from English to Finnish), and save the record.
5. Revert the change (e.g. change Language Code from Finnish to English), and save the record again.
6. Then run the SYSAUDIT report.

Errors on SYSAUDIT Report

Posted by on January 5, 2009 No comments

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.