Looking for SQL to show all PeopleCode on Componet.

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

1 reply [Last post]

Mon, 05/18/2015 - 11:09pm

Offline

Joined: 09/24/2008

Posts: 9

Given a Component Name I want the list of all Peoplecode that it have on records and events, pages, etc..
If some have one idea... thanks in advance.

Bookmark/Search this post with

Mon, 06/15/2015 - 6:37pm

#1

Offline

Joined: 03/01/2015

Posts: 5

Re: Looking for SQL to show all PeopleCode on Componet.

You can use something like

SELECT * FROM PSPCMTXT WHERE OBJECTID1 = 10
and OBJECTVALUE1 = 'SFA_RUN_EDITMSG';

where OBJECTVALUE1 is your component name.

PSPCMTXT is the table where you can find read only versions of the PeopleCode programs.

Unanswered Forum Posts

Title	Under	Posted on
Component interface Error: no rows exist for the specified keys	PeopleSoft Technical	03/15/2019 - 3:54am
ADD 24 months starting from current month.(peoplesoft)	PeopleSoft Functional	07/29/2018 - 8:44pm
TRC values dropdown	PeopleSoft Technical	04/04/2018 - 12:54am
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode	PeopleSoft Technical	09/11/2017 - 4:49am