Posts

Showing posts from February, 2017

Generate Report from the XML file.

-
REM ****************************************Modification Summary ******************************************; REM SL.No    Developer       Mod. No.   Date          Changes REM -----  -----------      ---------- ----------  ------------------------------------------- REM  01         Krishnam Raju N      XXXX      11/17/2015       Added code to generate the CSG Report output REM********************************************************************************************************; import PSXP_RPTDEFNMANAGER:*; Local Record &rcdQryPrompts; Local string &sTmpltID, &sLangCd; Local date &AsOfDate; Local File &file; /* get report definition object */ &sRptDefn = "XXX_EOPS_RPT"; Local string &OUTPUTFMT = "PDF"; &oRptDefn = create PSXP_RPTDEFNMANAGER:ReportDefn(&sRptDefn); &oRptDefn.Get(); &OUTPUTfile = "XXX_EOPS_" | XXX_EOPS_AET.PROCESS_INSTANCE.Value | ".XML"; MessageBox(0, "", 0,
Post a Comment
Read more

XML Generation Code for a single staging table in PeopleSoft

-
REM ****************************************Modification Summary ******************************************; REM SL.No    Developer      Mod. No.   Date          Changes REM -----  -----------     ---------- ----------  ------------------------------------------- REM  01          Krishnam Raju      XX0005      11/17/2015      The below code will generate the XML file REM********************************************************************************************************; Function StartObjectNode(&ObjectTypeCode As string)    Evaluate &ObjectTypeCode    When "-1"       &inXMLProjObjNode = &inXMLDoc.DocumentElement.AddElement("XXX_EOPS_RPT");       Break;    End-Evaluate; End-Function; Function EndObjectNode(&ObjectTypeCode As string)    Evaluate &ObjectTypeCode    When "0"       &inXMLRecCount.NodeValue = String(&inXMLRecObjNode.ChildNodeCount - 1);       Break;    End-Evaluate; End-Function; Function
Post a Comment
Read more

Getting the Excel output using peoplecode in peoplesoft(Without HTML)

-
Local Record &Rec; Local Rowset &rowSet; Local File &file1, &file2; Local SQL &SQL1, &SQL2, &SQL3; Local string &PresidentsHornor; &CUR_DATE = DateTimeToLocalizedString(%Datetime, "MMddyyyy"); &OPRID = %UserId; &PI = XXX_PRSDNT_AET.PROCESS_INSTANCE.Value; /* Output File Processing */ &FILE_NAME = "President_List_Processing_" | &CUR_DATE | "_" | &PI | "_Success" | ".xls"; &ERROR_FILE = "President_List_Processing_" | &CUR_DATE | "_" | &PI | "_Error" | ".xls"; &file1 = GetFile(&FILE_NAME, "W", %FilePath_Relative); &file2 = GetFile(&ERROR_FILE, "W", %FilePath_Relative); &PresidentsHornor = "President’s Honors"; If &file1.IsOpen Then    &rowSet = CreateRowset(Record.XXX_PRSDNT_TBL);    &NUM_READ = &rowSet.Fill("WHERE PROCESS_INSTANCE= :1"
Post a Comment
Read more

Getting the Excel output using html format using people code.

-
Local Record &Rec; Local Rowset &rowSet; Local File &file1, &file2; Local SQL &SQL1, &SQL2, &SQL3; Local string &PresidentsHornor; &CUR_DATE = DateTimeToLocalizedString(%Datetime, "MMddyyyy"); &OPRID = %UserId; &PI = XXX_PRSDNT_AET.PROCESS_INSTANCE.Value; /* Output File Processing */ &FILE_NAME = "President_List_Success_" | &CUR_DATE | "_" | &PI | ".xls"; &ERROR_FILE = "President_List_Error_" | &CUR_DATE | "_" | &PI | ".xls"; &file1 = GetFile(&FILE_NAME, "W", %FilePath_Relative); &file2 = GetFile(&ERROR_FILE, "W", %FilePath_Relative); &PresidentsHornor = "President’s Honors"; &HTML_Success = "<html> <font face = 'Trebuchet MS'> <table border = 1> <tr style='font-size:10pt' ><th bgcolor = &quot;#99CCFF&quot; >EMPLID<
Post a Comment
Read more

Dynamic Promots Examples in PeopleSoft

-
Image
Understanding Dynamic Prompts in PeopleSoft Every so often during the interviews, we encounter this question a lot and without a proper understanding we end up improvising the explanation. The question is -  What do you know about dynamic prompts and how we can create them? Well, let’s get to the point and try understanding the concept with examples. Prompts enable user to select a value from the list of predefined control values for a field in a page during transactions.  For Example, when we create a new department, to select the company we click on the prompt for company field and select one of the listed values. In this case, the list of companies displayed in the prompt is static and is directly pulled from the record COMPANY_TBL.  Below is the record field properties of COMPANY field in the record DEPT_TBL, In this case, there is no control over what are all the values will be prompted to the user, whatever is available in the record COMPANY_TBL, will b
Post a Comment
Read more

Implementing the Parallel Processing in APpl

-
This summary is not available. Please click here to view the post.
Post a Comment
Read more