Multiple SQL statements in one single Application Engine SQL Action

%Execute([/])
statment1{; | /}
statment2{; | /}
statment3{; | /}

ex:

%Execute(/)
statment1
/
statement2
/
statement3
/

How to find PeopleSoft current bundle number

use below Sql in DESCR place you can get bundle number info

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like '%BUNDLE%' ORDER BY 3 DESC

Some good peoplesoft blogs :

http://peoplesofthrms.blogspot.in

To restrict  Component Interface to execute the code

using  %CompIntfcName  you'll get component interface name

If %CompIntfcName <> "Your CI name" then
Messagebox("Message")
End-If

The above condition will restrict the message box from executing when the People code is executed from your CI.

Peoplesoft tables

http://www.pscustomizer.com/peoplesoft-examples/peopletools-metadata/

IB Configation

http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tibr/chapter.htm?File=tibr/htm/tibr08.htm

AWE

http://peoplesoftlearnings.blogspot.in/2010/02/peoplesoft-awe-workflow-configuration.html

SQLExec : Return: 8015 - Bind value is too long

SQLExec : Return: 8015 - Bind value is too long

You get this error in an online page or while running a Application engine program. This error happens when you try to insert more than 254 characters in a long field using sqlexec and do not use %TextIn meta sql.
Resolution
Use %TextIn meta-sql for the bind variable that is used for inserting into a long field. For e.g. %TextIn(:1)
%TextIn is documented in peoplebooks and is mandatory for all insertions/update of LongChar fields using sqlexec for all database platforms.
Here are some resolutions that discusses this issue in Metalink – Oracle support site.
E-AE Application Engine PeopleCode Step with SQLExec Receives Error; return code 8015 "Bind value is too long" [ID 889806.1]
E-PC:"Bind value is too long" Error When Using SQLExec to Insert into Long Char Field [ID 620874.1]

 

 

i got above info from http://peoplesoftexperts.blogspot.in/

Display Prompt on a Search dialog box

Display Prompt on a Search dialog box

If you have a prompt defined on a search record, it does not get displayed if you have component properties –> Internet tab set to use Basic Mode. (Default). Only Advanced mode displays the prompt on the search dialog box.

got ablove info from http://peoplesoftexperts.blogspot.in/