Recent Forum Posts

From categories:
page 1123...next »

· DataTerrain launches new reports conversion solution for customers who are migrating PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud. Our well defined framework enables customers with PeopleSoft pre-built Tax/HR/Payroll/Benefits reports to migrate accurately to Oracle Fusion HCM as custom Extracts and Reports.

· Take advantage of our expertise to preserve years of efforts in designing and creating the custom layouts / designs and migrating to Oracle Fusion HCM cloud. DataTerrain technical team provides experience and expertise to rebuild the custom logic to HCM Extracts.

· Our framework includes the analysis phase, which examines all the elements, identifies the missing elements and provides detailed log that can be used for pin pointed analysis to narrow down to report conversion issues. Our experts can help recommend solutions for the compatibility issues and resolve.

· We can also create OTBI (Oracle Transactional Business Intelligence) analysis with the required prompts and fields and embedded in dashboard for the users to view the report. The interactive reports are visually and feature rich. Users can also create ad hoc reports, dashboards and alerts to aid daily decision making using OTBI.

· Interested to know further? - For a limited time, Dataterrain offers to analyze a set of your reports, metadata and demo a proof of concept using our framework and automation tool at no cost! Please contact moc.niarretatad|tcennoc#moc.niarretatad|tcennoc for a free proof of concept to have direct real-time experience.

Casey (guest) 24 Aug 2017 17:40
in discussion Forum / Help » Connected Query passing prompt value w pcode

You can write your parameters to the connected query run control table PSCONQRSRUNPRMX. I have made the following code work;

Local PSXP_RPTDEFNMANAGER:ReportDefn &ReportDefinition;
Local Record &recQueryParameters;
Local string &ReportName, &TemplateName, &LanguageCode, &OutputFormat, &RunControl;
Local string &ConnectedQueryName, &QueryName, &QueryBindName;
Local date &AsOfDate;
Local boolean &result;

&ReportName = "COCGL1025";
&TemplateName = "COCGL1025_1";
&LanguageCode = "ENG";
&OutputFormat = "PDF";
&RunControl = "1";
&ConnectedQueryName = "COCGL1025_ONLINE_JOURNAL_PRINT";
&QueryName = "COCGL1025_JRNL_PRINT_HEADER";
&QueryBindName = "COCGL1025";

&ReportDefinition = create PSXP_RPTDEFNMANAGER:ReportDefn(&ReportName);
&ReportDefinition.Get();

SQLExec("DELETE FROM PSCONQRSRUNPRMX WHERE OPRID =:1 AND RUN_CNTL_ID =:2 AND CONQRSNAME=:3", %OperatorId, &RunControl, &ConnectedQueryName);

&recQueryParameters = CreateRecord(Record.PSCONQRSRUNPRMX);
&recQueryParameters.OPRID.Value = %OperatorId;
&recQueryParameters.RUN_CNTL_ID.Value = &RunControl;
&recQueryParameters.CONQRSNAME.Value = &ConnectedQueryName;
&recQueryParameters.QRYNAME.Value = &QueryName;
&recQueryParameters.BNDNUM.Value = "1";
&recQueryParameters.FIELDNAME.Value = "BUSINESS_UNIT";
&recQueryParameters.BNDNAME.Value = &QueryBindName;
&recQueryParameters.BNDVALUE.Value = JRNL_HEADER.BUSINESS_UNIT;
&recQueryParameters.Insert();

&recQueryParameters.OPRID.Value = %OperatorId;
&recQueryParameters.RUN_CNTL_ID.Value = &RunControl;
&recQueryParameters.CONQRSNAME.Value = &ConnectedQueryName;
&recQueryParameters.QRYNAME.Value = &QueryName;
&recQueryParameters.BNDNUM.Value = "2";
&recQueryParameters.FIELDNAME.Value = "JOURNAL_ID";
&recQueryParameters.BNDNAME.Value = &QueryBindName;
&recQueryParameters.BNDVALUE.Value = JRNL_HEADER.JOURNAL_ID;
&recQueryParameters.Insert();

&ReportDefinition.RunControlId = &RunControl;

&ReportDefinition.ProcessReport(&TemplateName, &LanguageCode, &AsOfDate, &OutputFormat);
DoSaveNow();

&ReportDefinition.DisplayOutput();

Hope it helps.

by Casey (guest), 24 Aug 2017 17:40

The transfer credit rules, articulation agreements, etc are all built and an individual summary can be posted and printed; however how do we build a query or report for all info posted as well as take the rules/schools that were built into a searchable items on the web to see if the course is equivalent to our courses and transferable using our rules???

Transfer Credit build searchable by Jenni (guest), 25 Jul 2017 21:09
abc (guest) 07 Jul 2017 01:53
in discussion Forum / General » Peoplesoft Training in Hyderabad , 11 years old Institute

Hi,

I have 8 years experience as Unix Admin. I want to move to people soft, which technology in people soft is good for me ?

by abc (guest), 07 Jul 2017 01:53
CAPS (guest) 05 Jul 2017 22:20
in discussion Forum / Help » SQR Connect Error

Hi Vonita, could you please share your resolution? We have a similar incident

by CAPS (guest), 05 Jul 2017 22:20
Creating REST Service
John (guest) 25 Jun 2017 04:23
in discussion Forum / Help » Creating REST Service

I have soup service for grades, I need to make a REST service of that existing service. Please help me with steps or share any helpful info.Appreciated THANKS

Creating REST Service by John (guest), 25 Jun 2017 04:23
rahul (guest) 09 Jun 2017 20:45
in discussion Forum / Help » designer failed to connect to ps/nvision

does any body know what caused this error?

by rahul (guest), 09 Jun 2017 20:45

Hello,

Are there ways in which you can define parameters (such as Start and End Dates) that can be attached to Travel and Expense 'Expense Reports'? For example, is it possible to define that an employee is only entitled to Breakfast if he/she left for travel a certain amount of time before so that it can be claimed. An employee may leave for travel at 10:00 AM but could only claim Breakfast if they left before 8:30AM? Or maybe that the employee would need to leave 2 hours before 8:30 to be able to claim the expense?

Thanks in advance.
Alex

PeopleSoft Financials - Expense Parameters for T&E by Alex (guest), 08 Jun 2017 17:59
Dynamic Role assignment
Gaurav (guest) 02 Jun 2017 11:23
in discussion Forum / Help » Dynamic Role assignment

I m new to Dynamic Role assignment feature. I created a query in Application designer as follows -

Function AssignDynamicRole()

Local string &sOprid;
Local SQL &sqlGET_EXAMPLE_USERS;

&sqlGET_EXAMPLE_USERS = GetSQL(SQL.GET_EXAMPLE_USERS);

While &sqlGET_EXAMPLE_USERS.Fetch(&sOprid)
%RoleDynamicMembers.Push(&sOprid);
End-While;

End-Function;

I created an another SQL which gives me 3 OPRID's as output.

But when I test rule from Dynamic Members tab, I am not able see any OPRID's in pop up.

Can you please help?

Dynamic Role assignment by Gaurav (guest), 02 Jun 2017 11:23
rahul (guest) 12 May 2017 17:55
in discussion Forum / Help » designer failed to connect to ps/nvision

how did it get resolved?

by rahul (guest), 12 May 2017 17:55
Need REST APIs for PeopleSoft HCM
Shreeya (guest) 26 Apr 2017 09:19
in discussion Forum / Help » Need REST APIs for PeopleSoft HCM

I am looking for available APIs for PeopleSoft HCM. Can someone please help me out with the same?

Need REST APIs for PeopleSoft HCM by Shreeya (guest), 26 Apr 2017 09:19
sdell0000@gmail.com (guest) 06 Apr 2017 18:11
in discussion Forum / Help » Writing a Date expression in PS Query

i am trying the assign a Monday Date as mm-dd-yyyy from a Date field.
How can i do that in Query Manager, when creating a new query against PO_HDR Table using the PO_DT?

by sdell0000@gmail.com (guest), 06 Apr 2017 18:11

Below is the code for both the function I tried- ty

— FILEEXIST -

&DESTSERVFOL = "//axxxgparxxxx/intf/u01/int/LA9DEVT/inbound/transaction.txt ;
If FileExists(&DESTSERVFOL, %FilePath_Absolute) Then
WinMessage("File exists!", 0, " ");
End-If;

—FINDFILES -

&WILD_INDEX = FindFiles("//axxxgparxxxx/intf/u01/int/LA9DEVT/inbound/*.txt", %FilePath_Absolute);

We (Global security team) have some profiles that do not want local security admins to have access editing them. Let's say we have a profile call General User (PROF01), local team will create user profiles using copy user profile function. We do not want them to edit PROF01 (by accident or how), but they still need access to add roles/change password for other users. Is there a way to restrict the access for certain main profiles from the local team?

SV Soft has been well established with the prime objective of offering excellent IT training & Placements services. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. In PeopleSoft technologies we are covering different courses like PeopleSoft HRMS technical, PeopleSoft FSCM, PeopleSoft DBA and PeopleSoft HRMS Functional. PeopleSoft is a very important course that helps you to achieve world class financial processes, visibility into critical information and provides an accurate view related to all project activities.
Email id : moc.snoitulostfosvs|ofni#moc.snoitulostfosvs|ofni
website : www.svsoftsolutions.com
Phone no. : Usa:+1-845-915-8712
India : +91-9642373173

by Sona (guest), 27 Feb 2017 03:37
Sagar (guest) 24 Feb 2017 14:11
in discussion Forum / Help » Concurrent Processes

Enter the maximum number of occurrences of this process that can be active at one time across all process schedulers. If this field is left blank (default), the value becomes Unlimited.
Processes exceeding the maximum appear in the Process Monitor with a run status of Blocked. As active occurrences finish, blocked processes are released and queued.

by Sagar (guest), 24 Feb 2017 14:11

File: /vob/peopletools/src/psppr/ramget.cppSQL error. Stmt #: 655 Error Position: 186 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:SELECT PW_SMTP_SERVER, PW_SMTP_PORT, PW_TIME_TO_WAIT, DBNAME, PW_EMAIL_FROM_ALT, PW_EMAIL_TO_ALT, TO_CHAR(CAST((LASTUPDDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), LASTUPDOPRID FROM PS_PW_EMC_SETTINGS

I have a custom component in HRMS 9.20.00.000 (tool release 8.54.28
) that store file attachments in an HTTP repository (a PeopleSoft server).

The component works fine. However, sometimes the users got an error with error code 1 (constant value:
%Attachment_Failed, description: File transfer failed due to unspecified error.)

When this issues occurs, the users cannot view and upload any document. It does not just happen to some documents, but all. The error occurs, then disappear itself, then the users can view and upload document normally.

It's very difficult to debug because it's intermittent. And the issue cannot be duplicated in non-production environments.

Does any encounter the same issue? Would you please help? Thanks a lot.

NsainiNsaini 25 Jan 2017 13:18
in discussion Forum / Help » Web Service Help

Hi Team,

I just wanted to updated and get some help from this blog.

As I have setup SoapUI recently and I am new to this tool. when ever I am trying to get a message it show an error of appserv timeout after 10 minutes. Can anyone help me regarding the same, that what should I do to resolve this issue with SoapUI tool.

I am using peopletool 8.54.14
Linux- 6.6

Please help as I'm looking forward for help and some setting to increase the timeout in web-services or IB or any other as per the suggestion. Under Soap tool we have already set the timeout time of 200 minutes still its getting timeout after 10 minutes.

by NsainiNsaini, 25 Jan 2017 13:18

TechiesTutor has its ONLINE Training division with a dedicated team of experienced corporate Professionals.Our motto being “Simple teaching yet exponential learning”.
Techies Tutor provides an integrated high end technologies like C++, Java, J2EE, linux administration, Testing Tools Courses ,WebServices, Spring, Hibernate, MS SQL DBA and so on
The explanation of concepts include good number of real time illustrations that would lay you s trong basement in learning core concepts.

Contact Number:9849867963
Adress: Miyapur, Hyderabad

page 1123...next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License