PeopleSoft Technical Interview Questions & Answers (60 Questions)
Category: Category 1: PeopleCode 20 Interview Questions & Answers
1. What are different PeopleCode events and their sequence?
Answer:
FieldDefault, FieldFormula, RowInit, RowInsert, FieldEdit, FieldChange, SaveEdit, SavePreChange,
Workflow, SavePostChange.
Sequence: FieldDefault FieldFormula RowInit FieldEdit FieldChange SaveEdit SavePreChange
Workflow SavePostChange
2. What is the difference between FieldChange and FieldEdit?
Answer:
FieldEdit: Used for validations (fires on Save or tab out).
FieldChange: Used to trigger business logic (e.g., recalculations, UI changes).
3. What is RowInit used for?
Answer:
Used to initialize field values when a row loads from the database.
4. How do you use MessageBox in PeopleCode?
Answer:
MessageBox(0, "", 0, 0, "Invoice submitted successfully!");
5. How to write a SQL SELECT using PeopleCode?
Answer:
SQLExec("SELECT NAME FROM PS_PERSONAL_DATA WHERE EMPLID = :1", &emplid, &name);
6. What is the difference between SQLExec and CreateSQL?
Answer:
SQLExec: Single row retrieval.
CreateSQL: Used to iterate over multiple rows.
7. How do you handle exceptions in PeopleCode?
Answer:
Try
/* Logic */
Catch Exception &e
MessageBox(0, "", 0, 0, "Error: " | &e.ToString());
End-Try;
8. What are derived/work records used for in PeopleCode?
Answer:
Used for temporary or UI-only fields not stored in the DB.
9. How do you trigger dynamic prompting using PeopleCode?
Answer:
DERIVED.FIELD.DropDownList.AddItem("A", "Active");
10. How can you hide or disable a field using PeopleCode?
Answer:
Gray(PERSONAL_DATA.BIRTHDATE); // disables
Hide(PERSONAL_DATA.BIRTHDATE); // hides
11. What is Component Buffer in PeopleCode?
Answer:
It's the in-memory representation of component data during a session.
12. What is the difference between GetLevel0() and GetRowset()?
Answer:
GetLevel0(): top-level rowset.
GetRowset(): access child rowsets.
13. How do you trigger Workflow using PeopleCode?
Answer:
TriggerWorkFlow(EVENT, "WORKFLOW_NAME", &keylist);
14. How do you dynamically change prompt table using PeopleCode?
Answer:
RECORD.FIELD.EditTable = "NEW_PROMPT_TABLE";
15. Explain the use of GetRecord and GetField methods.
Answer:
&rec = GetRecord(RECORD.MY_REC);
&field = &rec.GetField(FIELD.MY_FIELD);
16. How do you insert a new row using PeopleCode?
Answer:
&rsLevel1.InsertRow(&i);
17. What is PeopleCode meta-SQL and give an example.
Answer:
Meta-SQL is DB-independent syntax, e.g., %CurrentDateIn
18. How do you call an Application Engine from PeopleCode?
Answer:
&rqst = CreateProcessRequest("AppEngine");
&rqst.Run();
19. How can you trigger file export using PeopleCode?
Answer:
&file = GetFile("C:\export.txt", "W", "A", %FilePath_Absolute);
&file.WriteLine("Data Export");
&file.Close();
20. How do you validate Combo Edits in PeopleCode?
Answer:
Use FieldEdit logic or system combo edit rules.
Category: Category 2: Application Engine 20 Interview Questions & Answers
[Content continues...]
