Customized Objects Inventory

Categories:
Tags:
Tailored Operational Context
  • Target Database: —
  • Context Type: —
  • Alert Severity: —
  • Triggered Time: —
  • Firing Context: —

Customized Objects Inventory Report

Report ID: objects-customized-inventory Category: Hygiene

Purpose

This report provides a complete inventory of all customized PeopleSoft objects across ten major object types. It answers the question: “What did we customize in this environment?”

Anything not stamped PPLSOFT is something you’ll have to defend during an upgrade.

Definition of “Customized”

An object is considered customized if its LASTUPDOPRID (last updated by operator) is not PPLSOFT. Objects delivered by Oracle PeopleSoft are stamped with PPLSOFT when installed. Any object modified by a customer operator will have a different value.

Object Types Covered

Object TypePeopleSoft TablepsLens Detail Page
RecordsPSRECDEFN/records/{name}
FieldsPSDBFIELD/fields/{name}
PagesPSPNLDEFN/pages/{name}
ComponentsPSPNLGRPDEFN/components/{name}
MenusPSMENUDEFN/menus/{name}
Application PackagesPSPACKAGEDEFN/apppackages/{name}
Application EnginesPSAEAPPLDEFN/appengines/{name}
SQL ObjectsPSSQLDEFN/sqlobjects/{name}
Service OperationsPSOPERATION/serviceoperations/{name}
RolesPSROLEDEFN/roles/{name}

Data Flow

1. For each object type:
   Query the primary table with LASTUPDOPRID <> 'PPLSOFT'
   (using paginated batches of 500 rows)
        |
        v
2. Collect all results across all pages
        |
        v
3. Generate summary table with counts per object type
        |
        v
4. Generate per-type detail sections with links to psLens detail pages

Report Output

The report contains:

  • Header with database name, generation timestamp, and definition of “customized”
  • Summary table showing the count of customized objects per type and a grand total
  • Detail section per object type, each with a markdown table listing:
    • Object name (linked to the psLens detail page)
    • Description (where available)
    • Object Owner ID (where available)
    • Last Updated By operator
    • Last Updated timestamp

Parameters

This report has no configurable parameters.

Interpreting Results

  • High counts in a specific object type indicate heavy customization in that area. This increases upgrade risk for those object types.
  • Object Owner ID (OBJECTOWNERID) shows the functional owner of the object (e.g., a product line or module). A customer-specific owner ID confirms the object is a true customization vs. a third-party product extension.
  • Last Updated By shows which operator last touched the object. Objects last updated by a system batch operator may have been auto-modified vs. intentionally customized.
  • Objects with no entry in a section means that type has no customizations, which is worth noting for upgrade planning.

Use Cases

  1. Pre-upgrade assessment. Run this report before a PeopleTools or application upgrade to understand the full scope of customizations that will need to be reviewed and re-applied.
  2. Customization audit. Share with Oracle support or an implementation partner to get an accurate picture of what has been changed in the environment.
  3. Developer handoff. Use as a starting inventory when onboarding new team members or transferring system ownership.