PeopleTools tables: Meta data

PeopleTools tables Categorized 

PeopleSoft Project:   PSPROJECTDEFN, PSPROJECTITEM

PeopleSoft Portal Structure : PSPRSMDEFN, PSPRSMPERM

XLAT information: PSXLATTABLE, PSXLATDEFN, PSXLATITEM

PS records: PSRECDEFN

PS fields: PSDBFIELD

PS Pages:  PSPNLDEFN

PS Components: PSPNLGRPDEFN

Message Catalog tables:  PSMSGCATDEFN

Application engine:  PSAEAPPLDEFN, PSAEAPPLSTATE, PSAESECTDEFN, PSAESECTDTLDEFN, PSAEAPPLTEMPTBL, PSAESTEPDEFN, PSAESTMTDEFN, PSAESTEPMSGDEFN

So many other Peopletools tables are there. But above listed we will use on very regularly in our development practice.

Intrested in PeopleSoft Learning Please reach us on  info@OnlineIT365.com 
OnlineIT365.com.
www.facebook.com/ONLINEIT365
twitter.com/ONLINEIT365

Table lock identification in Database

We will face very regularly, Table lock issue which will cause the Application engines and SQR processes to error.

Here is the sql to find out the locked tables in Database.

select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine,
b.program,
b.type,
b.client_info
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id
and
a.object_id = c.object_id;

Once we identified the table is locked we can request DBA team to release the table.

Intrested in PeopleSoft Learning Please reach us on  info@OnlineIT365.com 
OnlineIT365.com.
www.facebook.com/ONLINEIT365
twitter.com/ONLINEIT365

XML Publisher secured PDF file generation

We can Create the PDF files with Password secure. Please find the below steps to create that.

1. Open the file in the navigation PSHOME> Appserver> XDO.cfg

2. In Original file the code will be looks like this. (as per the tools version 8.50)

<config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/">

    <properties>
        <!-- System level properties -->
        <property name="xslt-xdoparser">true</property> 
        <property name="xslt-scalable">true</property>
        <property name="system-cachepage-size">50</property>
        <property name="system-temp-dir"></property>
    </properties>


    <!--<fonts>-->
        <!--<font family="3 of 9 Barcode" style="normal" weight="normal">-->
            <!--<truetype path="C:\WINNT\Fonts\3of9.ttf" />-->
        <!--</font>-->
    <!--</fonts>-->


</config>

3. open the file and edit the code like below.

   <properties>
        <!-- System level properties -->
        <property name="xslt-xdoparser">true</property> 
        <property name="xslt-scalable">true</property>
        <property name="system-cachepage-size">50</property>
        <property name="system-temp-dir"></property>
     
       <!-- PDF compression -->
        <property name="pdf-compression">true</property>
       <!-- PDF Security -->
        <!-- <property name="pdf-security">true</property> -->
        <!-- <property name="pdf-open-password">user</property> -->
        <!-- <property name="pdf-permissions-password">owner</property> -->
    </properties>





Intrested in PeopleSoft Learning Please reach us on  info@OnlineIT365.com 
OnlineIT365.com.
www.facebook.com/ONLINEIT365
twitter.com/ONLINEIT365