BI Publisher add in for Word 2016 not showing when you install BI Publisher of PeopleSoft (Download at: Reporting Tools > BI Publisher > Setup > Design Helper)
You should Check about Java version and System Type of Word 32/64 Bit
and more detail at below link
https://mani2web.wordpress.com/2016/06/18/issues-with-oracle-bi-publisher-with-microsoft-word-2016/
How to Install BI Publisher for Word. You can download bi publisher at menu : Reporting Tools > BI Publisher > Setup > Design Helper and select type of bit 32 or 64 and download and install it. After install BI Publisher tab should appear in the ribbon of word and Excel.
You can check version of your word before download at File > Account > About Word
BI Publisher in Word 2016
BI Publisher in Excel 2016
How to Use Split Function Peoplesoft in Peoplecode by use below syntax
Split(string, separator)
Use the Split function to convert a string into an array of strings by looking for the string separator in the given string.
For example: You read filename from your path and split file for write it to report.
&file_name = %FilePath | &Attachsysfilename;
MessageBox(0, “file_name”, 0, 0, ” &file_name= ” | &file_name);
&In_File = GetFile(&file_name, “E”, %FilePath_Absolute);
If &In_File.IsOpen Then
While &In_File.ReadLine(&file);
&line = Split(&file, “,”);
&EMPLID = &line [1];
&EFFDT = &line [2];
&EFFSEQ = &line [3];
/* Each statement */
end-while;
end-if;
ref:https://docs.oracle.com/cd/E13292_01/pt849pbr0/eng/psbooks/tpcl/chapter.htm?File=tpcl/htm/tpcl02.htm%23g037ee99c9453fb39_ef90c_10c791ddc07__3c45
How to use scrollselect in peoplecode : You can use scrollselect function of peoplecode for flush data from record, table and record view that populate data to scroll area/ grid on page of peoplesoft.
You can use scrollselect in many level of grid or scroll area by use this syntax at below
ScrollSelect(levelnumber of grid or scroll area, [record.level1_recname, [record.level2_recname,]] record.target_recname, record.sel_recname [, sqlstr [, bindvars]] [, turbo])
where bindvars is an arbitrary-length list of bind variables in the form: bindvar1 [, bindvar2].
ref : https://docs.oracle.com/cd/E13292_01/pt849pbr0/eng/psbooks/tpcl/chapter.htm?File=tpcl/htm/tpcl02.htm
You can remove upside down question marks or other strange non-printable characters form MS word or call “smart quote” when copy and past content from word to text field of page peoplesoft by use javascript for remove it.
Ref : https://www.cedarhillsgroup.com/knowledge-base/kbarticles/removing-word-smart-quotes-on-peoplesoft-pages/
How to use function peoplecode of peoplesoft about setcursorpos in peoplesoft. You can use this function for fix position of cursor on page.
This Syntax : SetCursorPos(Page.pagename,scrollpath, target_row, [recordname.]fieldname)
where scrollpath is: [RECORD.level1_recname,level1_row, [RECORD.level2_recname,level2_row, ]] RECORD.target_recname
To prevent ambiguous references, you can use SCROLL.scrollname, where scrollname is the same as the scroll level’s primary record name.
Pagename: The name of the page specified in the page definition, preceded by the keyword Page. The page name page must be in the current component. You can also pass the %page system variable in this parameter (without the Page reserved word).
scrollpath: A construction that specifies a scroll level in the component buffer.
[recordname .]fieldname: Specify a field designating the record and field in the scroll where you want to place the cursor.
target_row: The row number of the row in which you want to place the cursor.
This is example code set cursor when control cursor in page activate
This picture has page name is TEST_PAGE include scroll area level 1 is record of TEST_TBL. My requirement check Flag.
If Flag = Y then Set cursor at TEST_TBL.DESCR254_1.
If Flag = N then Set cursor at TEST_TBL.DESCR254_2.
Example 1 : SetCursorPos(Page.Page_name, Record.Field, &i);
You place peoplecode at page activate by condition if flag = Y then set cursor at Descr254_1.
This code is “SetCursorPos(Page.test_page, Record.TEST_TBL.Descr254_1, &i);”
Result
Example 2 :
SetCursorPos(Page.Page_name, Record.Field, &i);
You place peoplecode at page activate by condition if flag = N then set cursor at Descr254_2.
This code is “SetCursorPos(Page.test_page, Record.TEST_TBL.Descr254_2, &i);”
Result
Ref: https://docs.oracle.com/cd/E15645_01/pt850pbr0/eng/psbooks/tpcl/chapter.htm?File=tpcl/htm/tpcl02.htm%23g037ee99c9453fb39_ef90c_10c791ddc07__3c78
How to use messagebox peoplecode in Peoplesoft. You can Messagebox in PeopleCode event and use an application engine that shows in view log/trace.
This syntax
MessageBox(style,title,message_set, message_num,default_txt [, paramlist])
Returns either a Number value or a constant.
| Value | Constant | Meaning |
| -1 | %MsgResult_Warning | Warning was generated. |
| 1 | %MsgResult_OK | OK button was selected. |
| 2 | %MsgResult_Cancel | Cancel button was selected. |
| 3 | %MsgResult_Abort | Abort button was selected. |
| 4 | %MsgResult_Retry | Retry button was selected. |
| 5 | %MsgResult_Ignore | Ignore button was selected. |
| 6 | %MsgResult_Yes | Yes button was selected. |
| 7 | %MsgResult_No | No button was selected. |
Example 1. Use button in style OK/ Cancel
&result = MessageBox(1, “Confirm OK / Cancel”, 0, 0, “Confirm OK / Cancel”);
rem WinMessage(%MsgResult_OK, 0);
If &result = %MsgResult_OK Then
WinMessage(“OK”, 0);
/* — each statment in peoplecode–*/
Else
WinMessage(“Cancel”, 0);
/* — each statment in peoplecode–*/
End-If;
Description of example 1
The PeopleCode &result = MessageBox(1, “Confirm OK / Cancel”, 0, 0, “Confirm OK / Cancel”); shows image below
If you press the OK button then shows an image below
Ref : https://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tpcl/chapter.htm?File=tpcl/htm/tpcl02.htm%2337ee99c9453fb39_ef90c_10c791ddc07__3ce0