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

Warning: Application Engine Request is not active -- processing suspended (108,517):

 Some times when we try to schedule an application engine through AE it gives above error. & the process goes into success. It actually does not execute the application engine
  
 you have to  set the process frequency to "Always" in below page and then schedule process

Home > PeopleTools > Application Engine > Process > Request

 

Enable and Disable add and delete Buttons in Scroll:

 To enable and disable add/delete button using people code

Example With bit logic

 Local Rowset &PCS_CMP_HDR;

 & CMP_HDR = GetLevel0()(1).GetRowset(Scroll.PER_ROL_REC);

If &CMP_HDR(CurrentRowNumber()).PER_ROL_REC.WF_STATUS.Value = "A" Then

   &CMP_HDR.InsertEnabled = True;

Else

   &CMP_HDR.InsertEnabled = True;

End-If;

In front end  also you can do

1.

2.

Note:

 

In Scroll if all field all fields display only automatically add/deletions will become display only

to avoid this you have to make put at least one filed in editable and make visible property false