How to use Peoplecode While Fetch of peoplesoft. You can use function while with fetch data from sql for get data from sql.
Local SQL &SQL_DM = CreateSQL( ” SELECT MANAGER, NAME FROM TABLE “);
&i = 0;
While &SQL_DM.Fetch(&MANAGER,&NAME );
/* Do statement*/
End-while;
You can use Dynamic View in Peoplesoft for each purpose such record in grid or scroll area of peoplesoft page or prompt table for search record.
Dynamic view in peoplesoft page
Step1 1 : Create dynamic view and assign it to grid or scroll area
Step 2 : Create sql for flush data to dynamic view in grid or scroll area
Step 3 : Populate data to grid/ scroll area by scrollflush & scroll select
Dynamic view for prompt table
You can read more about create dynamic view table and assign record field properties is prompt table from dynamic view and assign dynamic sql by peoplecode at here.
1. select fields for your table for use dynamic view prompt table
2. Choose record type = Dynamic View
3. Click to open SQL editor and past sql in record
4. Define prompt table in derived field
5. Past peoplecode of RC of each purpose
|
1 2 3 4 5 6 7 8 9 10 11 |
/*-- Store SQL in Table and bind parameter :1, :2 --*/ SQLExec("SELECT %textin(DESCR) FROM PS_JLT_HRMS_CODE WHERE JLT_SEQ ='5004'", &SQL_RC_FILTER); &RC_Owner_TOP ='10030'; &sql_str_rc_filter = &SQL_RC_FILTER; /*-- Replace Data in SQL Text --*/ &sql_str_rc_filter = Substitute(&sql_str_rc_filter, ":1", Quote(&RC_Owner_TOP)); &sql_str_rc_filter = Substitute(&sql_str_rc_filter, ":2", JLT_DERIVED_CTR.JLT_CNTRC_RUN.Value); rem WinMessage(&sql_str_rc_filter, 1); DERIVED_CTR.RC.SqlText = " SELECT mm3.RC,mm3.descr100 FROM ps_rc_code mm3 WHERE mm3.RC in ( " | &sql_str_rc_filter | ")"; |
You can define peoplecode in sql text by this syntax at below.
DERIVED_CTR.RC.SqlText = ExpandSqlBinds(FetchSQL(SQL.SQL_RC_FILTER), &RC_CODE);
1. Select Edits tab of record field and then select Table Edit.
2. Select Prompt table with edit( or No Edit) and past %EDITTABLE in prompt table.
3 : Place field DERIVED.EDITTABLE on the page peoplesoft.
4 : Write code in field change event of purpose field of each requirement.
|
1 2 3 4 5 |
if &Flag ="Y"; DERIVED.EDITTABLE = "RC1_VW"; Else DERIVED.EDITTABLE = "RC2_VW"; End-fi; |
How to Default Correct History Peoplesoft : When user search page of peoplesoft and defualt correct history at search page by change action of component is correction.
How to Bypass Search Record By Peoplecode in Peoplesoft :
1. You can use function peoplecode setsearchdialogbehavior(0) at searchinit keyfield for bypass search record.
2. Use search record is INSTALLATIION
How to change field name mouse over popup page design peoplesoft
Go to Menu : Main Menu > Set Up HRMS > Common Definitions > Mouse Over Popup > MouseOver Page Design
You can change label of fieldname and define field type , Display data of field and sort order of field display on mouseover popup page in peoplesoft.
I have problem about mouseover popup page incorrect manager peoplesoft about detail employee. When employees transferred to other branch but detail of manager not update.
Solution: Run Process at menu : Main Menu > Set Up HRMS > Common Definitions > Direct Reports for Managers > Direct Reports Tables Build
Direct Reports Tables Build has 2 Build Mode
1. Full – Complete Rebuild: Truncates and reloads all reporting data.
2. Incremental – Current Date Upd: Gathers changes made to reporting data or information that has become current since the last run of this process and applies the changes to the direct reports tables.
Reference: https://docs.oracle.com/cd/E39904_01/hcm92pbr0/eng/hcm/hhaf/task_ConfiguringDirectReportsFunctionality-e32525.html