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/

comments fields to outbound as xl file:

While comments fields to outbound as xl file, we will face some problems because of tabs ,new line chars and special chars so I searched in internet and I fund some logic and I added some logic to that code Below is code this will help adding commets to xl file

Function F2(&String As string) Returns string

Local string &sCurrChar, &sTmpStr;

Local number &nPos, &nLen;

Local string &VALID = "~`!#$%^&*()_|\{}[]:'<>?\/"; /* Special chars can be allowed */

&sStr = &String; &sTmpStr = RTrim(LTrim(&sStr));

 /* Trim blank spaces before and after string */

 If IsAlphaNumeric(&sTmpStr) Or IsDigits(&sTmpStr) Then

/* Return String if already IsAlphanNumeric */

       Return &sTmpStr;

Else

     &sTmpStr = Substitute(&sTmpStr, "-", "_");

     &nLen = Len(&sTmpStr);

    /* Get Length of string */

      &nPos = 1;

  /* Set initial position */

 While &nPos <= &nLen   

/* Loop through string one character at a time and strip out non alpha character. */

 &sCurrChar = Substring(&sTmpStr, &nPos, 1);

 /* Get one character from string at the current position */

 If IsAlphaNumeric(&sCurrChar) Then

/* Check if alpha character or space */

&nPos = &nPos + 1; /* Increment current position */

Else &V = Find(&sCurrChar, &VALID);

/* Leave spaces and some Special chars inside of string */

If &sCurrChar = " " Or &V > 0 Then

&nPos = &nPos + 1;

 /* Increment current position */

Else

    If &nPos < &nLen Then

       &sTmpStr = Substring(&sTmpStr, 1, &nPos - 1) | Substring(&sTmpStr, &nPos + 1, &nLen - &nPos);

/* Remove non-alpha character */

 &nLen = Len(&sTmpStr);

/* Get new length of string */

             Else /* Last character */
                     Return Substring(&sTmpStr, 1, &nPos - 1);
/* Return string without last character */
End-If;
 End-If;
End-If;
End-While;
End-If;
Return &sTmpStr;
End-Function;

Adding and updating data into record in peoplecode

&variable_name= CreateRecord(Record.Record_name);

&variable_name.field_name.value= data

&variable_name.field_name2.value= data

/*to insert new row*/

&variable_name.Insert()

/*to update existing data*/

&variable_name.update()

Note: when doing update key field’s data required

          If with same key fields data is already exist in table insert will not work

To get field name of that record

For &i = 1 To &variable_name.FieldCount
   &fn = &variable_nameGetField(&i).Name;

Creating structure (columns) from other table:   

To get only structure not data use below SQL

CREATE TABLE new_table
  AS (SELECT * FROM old_table WHERE 1=2)

 If you want data also

CREATE TABLE new_table
  AS (SELECT * FROM old_table)

Clicking of push button XL to CI :

Some times we will get requirement like this in a page click of push button is mandatory, so if you create XL to CI to the you have to include that push button field in that CI, then in  XL to CI give input as ‘Y’ so it’ll work