Runtime Definition Integrity

The following table describes the audit queries and resolutions for this area:

Query Description Resolution

SYSRTDEFN-01

System table audit against PSRECFIELD. This audit identifies runtime fields on design time records.

In Application Designer, open the record and remove the reported runtime field.

SYSRTDEFN-02

System table audit against PSRECDEFN. This audit identifies runtime fields that are Set Control Field properties on design time records.

In Application Designer, open the record and remove the reported runtime field.

SYSRTDEFN-03

System table audit against PSRECDEFN. This audit identifies runtime records that are Parent Record properties on design time records.

In Application Designer, open the record and remove the reported runtime record.

SYSRTDEFN-04

System table audit against PSRECDEFN. This audit identifies runtime records that are Related Language Record properties on design time records.

In Application Designer, open the record and remove the reported runtime record.

SYSRTDEFN-05

System table audit against PSRECDEFN. This audit identifies runtime records that are Query Security Record properties on design time records.

In Application Designer, open the record and remove the reported runtime field.

SYSRTDEFN-06

System table audit against PSRECDEFN. This audit identifies runtime records that are Analytic Delete Record properties on design time records.

In Application Designer, open the record and remove the reported runtime record.

SYSRTDEFN-07

System table audit against PSRECDEFN. This audit identifies runtime records that are Audit Record properties on design time records.

In Application Designer, open the record and remove the reported runtime record.

SYSRTDEFN-08

System table audit against PSRECDEFN table. This audit identifies runtime fields that are System ID field properties on design time records.

In Application Designer, open the record and remove the reported runtime field.

SYSRTDEFN-09

System table audit against PSRECDEFN. This audit identifies runtime fields that are Timestamp Field properties on design time records.

In Application Designer, open the record and remove the reported runtime field.

SYSRTDEFN-10

System table audit against PSRECFIELD. This audit identifies runtime records that are Default Value Record properties on design time record fields.

In Application Designer, open the record field and remove the reported runtime record.

SYSRTDEFN-11

System table audit against PSRECFIELD. This audit identifies runtime fields that are Default Value Field properties on design time record fields.

In Application Designer, open the record field and remove the reported runtime field.

SYSRTDEFN-12

System table audit against PSRECFIELD. This audit identifies runtime records that are Prompt Table properties on design time record fields.

In Application Designer, open the record field and remove the reported runtime record.

SYSRTDEFN-13

System table audit against PSRECFIELD. This audit identifies runtime fields that are Set Control Field properties on design time record fields.

In Application Designer, open the record field and remove the reported runtime field.

SYSRTDEFN-14

System table audit against PSRECFIELD. This audit identifies runtime fields that are Currency Control Field properties on design time record fields.

In Application Designer, open the record field and remove the reported runtime field.

SYSRTDEFN-15

System table audit against PSRECFIELD. This audit identifies runtime fields that are Time Zone field properties on design time record fields.

In Application Designer, open the record field and remove the reported runtime field.

SYSRTDEFN-16

System table audit against PSRECFIELD. This audit identifies runtime fields that are Related Time Date field properties on design time record fields.

In Application Designer, open the record field and remove the reported runtime field.

SYSRTDEFN-17

System table audit against PSPNLFIELD. This audit identifies runtime records on pages.

In Application Designer, open the page and remove the reported runtime record.

SYSRTDEFN-18

System table audit against PSPNLTREECTRL. This audit identifies runtime records that are on Tree Control fields of a page.

In Application Designer, open the page and remove the reported runtime record.

SYSRTDEFN-19

System table audit against PSPNLGRPDEFN. This audit identifies runtime records that are Search Record properties on components.

In Application Designer, open the component and remove the reported runtime record.

SYSRTDEFN-20

System table audit against PSPNLGRPDEFN. This audit identifies runtime records that are Add Search Record properties on components.

In Application Designer, open the component and remove the reported runtime record.

SYSRTDEFN-21

System table audit against PSPCMPROG. This audit identifies runtime records with PeopleCode.

To resolve, run this SQL:

DELETE * FROM PSPCMPROG 
WHERE OBJECTID1 = 1 
    AND OBJECTVALUE1 = <runtime record name>

SYSRTDEFN-22

System table audit against PSOPTREC. This audit identifies runtime records on Analytic Types.

In Application Designer, open the Analytic Type and remove the reported runtime record.

SYSRTDEFN-23

System table audit against PS_APPR_RULE_HDR. This audit identifies runtime records as Currency Records on Approval Rules.

In Application Designer, open the object and remove the reported runtime record.

SYSRTDEFN-24

System table audit against PSFLDSEGDEFN. This audit identifies runtime records on File Layouts.

In Application Designer, open the File Layout and remove the reported runtime record.

SYSRTDEFN-25

System table audit against PSOPTSETDIM. This audit identifies runtime records on the Optimization Model Index Set.

In Application Designer, open the Optimization Model and remove the reported runtime record.

SYSRTDEFN-26

System table audit against PSOPTPARARRAY. This audit identifies runtime records on the Optimization Model Parameter Array.

In Application Designer, open the Optimization Model and remove the reported runtime record.

SYSRTDEFN-27

System table audit against PSEVENTDEFN. This audit identifies runtime records on Activity Events.

In Application Designer, open the Activity and remove the reported runtime record.

SYSRTDEFN-28

System table audit against PSEVENTROUTE. This audit identifies runtime records on Activity Event Routes.

In Application Designer, open the Activity and remove the reported runtime record.

SYSRTDEFN-29

System table audit against PSMAPROLEBIND. This audit identifies runtime records on the Activity Map Role Bind table.

In Application Designer, open the Activity and remove the reported runtime record.

SYSRTDEFN-30

System table audit against PSMAPLEVEL. This audit identifies runtime records on Activity Event Level mapping.

In Application Designer, open the Activity and remove the reported runtime record.

SYSRTDEFN-31

System table audit against PSMAPRECFIELD. This audit identifies runtime records on Activity Event Field mapping.

In Application Designer, open the Activity and remove the reported runtime record.

SYSRTDEFN-32

System table audit against PSAEAPPLSTATE. This audit identifies runtime records that are State Record properties on Application Engine programs.

In Application Designer, open the AE program and remove the reported runtime record.

SYSRTDEFN-33

System table audit against PSAEAPPLTEMPTBL. This audit identifies runtime records that are Temp Table properties on Application Engine programs.

In Application Designer, open the AE program and remove the reported runtime record.

SYSRTDEFN-34

System table audit against PSROLEDEFN. This audit identifies runtime records on roles.

Access the Roles Page (select PeopleTools, and then Security, and then Permission and Roles, and then Roles). Select the Dynamic Members tab, and remove the runtime record.

SYSRTDEFN-35

System table audit against PSARCHOBJREC. This audit identifies runtime records on Archive Objects.

Access the Manage Archive Object page (select PeopleTools, and then Data Archive Manager, and then Manage Archive Objects), and remove the Archive Object.

SYSRTDEFN-36

System table audit against PS_ARCH_TBL table. This audit identifies runtime records on Archive Templates.

Run the following SQL:

DELETE FROM PS_ARCH_TBL WHERE PSARCH_ID=<Archive ID> AND RECNAME=<Runtime Record name>;

SYSRTDEFN-37

System table audit against PS_ARCH_CTRL. This audit identifies runtime records on the Archive Template Control table.

Run the following SQL:

DELETE FROM PS_ARCH_CTRL WHERE PSARCH_ID=<Archive ID> AND RECNAME=<Runtime Record name>

SYSRTDEFN-38

System table audit against PS_ARCH_OTH_CTRL. This audit identifies runtime records on the Archive Template Other Control table.

Run the following SQL:

DELETE FROM PS_ARCH_OTH_CTRL WHERE PSARCH_ID=<Archive ID> AND RECNAME=<Runtime Record name>;

SYSRTDEFN-39

System table audit against PS_ARCH_SQL_LNG. This audit identifies runtime records on the Archive Template SQL table.

Run the following SQL:

DELETE FROM PS_ARCH_SQL_LNG WHERE PSARCH_ID=<Archive ID> AND RECNAME=<Runtime Record name>;

SYSRTDEFN-40

System table audit against PSBCITEM. This audit identifies runtime records on Component Interface items.

In Application Designer, open the Component Interface and remove the reported runtime record.

SYSRTDEFN-41

System table audit against PSCONQRSMAP. This audit identifies runtime records on Connected Query Relationships.

Access the Connected Query Manager page (select Reporting Tools, and then Connected Query, and then Connected Query Manager). Click Temp Tables, and then click Delete Temp Tables to remove the runtime record.

SYSRTDEFN-42

System table audit against PSPTCONTEXT. This audit identifies runtime records on the Field Context table.

Run the following SQL:

DELETE FROM PSPTCONTEXT WHERE RECNAME=<Runtime Record name>;

SYSRTDEFN-43

System table audit against PSOPTVARARRAY. This audit identifies runtime records on the Optimization Model Variable Array.

In Application Designer, open the Optimization Model and remove the reported runtime record.

SYSRTDEFN-44

System table audit against PSMSGREC. This audit identifies runtime records on the Message Definition record.

Access the Message Definition page (select PeopleTools, and then Integration Broker, and then Integration Setup, and then Message Definitions), and remove the runtime record.

SYSRTDEFN-45

System table audit against PSOPTREC. This audit identifies runtime records on Optimization Application records.

In Application Designer, open the Analytic Type and remove the reported runtime record.

SYSRTDEFN-46

System table audit against PS_PRCS_RUNPARM. This audit identifies runtime records on the Process Run Control Parameters table.

Access the Process Scheduler Processes page (select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes). Select the Runtime Parameters tab and remove the runtime record from the RunTime Parameters grid.

SYSRTDEFN-47

System table audit against PSQRYRECORD. This audit identifies runtime records on the Query Record table.

Access the Query Manager page (select Reporting Tools, and then Query, and then Query Manager). Open the Query, select the Query tab, and remove the runtime record.

SYSRTDEFN-48

System table audit against PSQRYFIELD. This audit identifies runtime records on Query fields.

Access the Query Manager page (select Reporting Tools, and then Query, and then Query Manager). Open the Query, select the Query tab, and remove the runtime record.

SYSRTDEFN-49

System table audit against PSQRYFIELDDEP. This audit identifies runtime records on Query Fields Dependencies.

Access the Query Manager page (select Reporting Tools, and then Query, and then Query Manager). Open the Query, select the Dependency tab, and remove all runtime records from the Field Dependency grid.

SYSRTDEFN-50

System table audit against PSPTCSSRVCONF. This audit identifies runtime records on Related Content Service configurations.

Access the Event Mapping Configuration page (select PeopleTools, and then Portal, and then Event Mapping, and then Event Mapping Configuration) and remove the runtime record.

SYSRTDEFN-51

System table audit against PSPTSF_RECORDS. This audit identifies runtime records on Search Definition Application records.

Access the Define Search Definition page (PeopleTools, and then Search Framework, and then Designer, and then Define Search Definition) and remove the runtime record from the Application Records grid.

SYSRTDEFN-52

System table audit against PSPTSF_SRCHATTR. This audit identifies runtime records on Search Definition Search attributes.

Access the Define Search Definition page (PeopleTools, and then Search Framework, and then Designer, and then Define Search Definition) and remove the runtime record from the Search Attributes grid.

SYSRTDEFN-53

System table audit against PSPTSF_GN_DCATR. This audit identifies runtime records on the Search Definition child table PSPTSF_GN_DCATR.

Access the Define Search Definition page (PeopleTools, and then Search Framework, and then Designer, and then Define Search Definition). Select the Security tab and remove the runtime record from the Field Mapping grid.

SYSRTDEFN-54

System table audit against PSPTTSTCOMMAND. This audit identifies runtime records on the Test Framework Test Commands table.

Open the Test in the PeopleSoft Test Framework (PTF) Client and delete the test step containing the runtime record.

SYSRTDEFN-55

System table audit against PS_APPR_RULE_FIELD. This audit identifies runtime records on the Approval Rule Defn Route Cntl.

In Application Designer, open the Approval Rule and remove the reported runtime record.

SYSRTDEFN-56

System table audit against PS_APPR_RULE_AMT. This audit identifies runtime records on Approval Rule Amounts.

In Application Designer, open the Approval Rule and remove the reported runtime record.

SYSRTDEFN-57

System table audit against PS_APPR_RULE_QTY. This audit identifies runtime records on Approval Rule Quantities.

In Application Designer, open the Approval Rule and remove the reported runtime record.