Peoplesoft Troubleshooting

Opening a new window

Soure: http://peoplesoft.wikidot.com/opening-a-new-window

/*****************************************************************************
NewWinUrl(&strUrl)

This function modifies a URL to return a new window URL
It allows a new state block to be generated in a separate browser instance.
http://server:port/psp/ps/EMPLOYEE/HRMS/c/......
turns into
http://server:port/psp/ps_newwin/EMPLOYEE/HRMS/c/......
which renders to the browser as
http://server:port/psp/ps_1/EMPLOYEE/HRMS/c/......

Input parameters: &strUrl - a URL to manipulate
Output parameters: &strUrlModified - New URL with _newwin parameter

****************************************************************************/

Function NewWinUrl(&strUrl As string) Returns string;
Local string &sRegex, &sReplace, &Result;
/* Declare java object */
Local JavaObject &jUrl;

/**
* Peoplesoft Content types:
* -------------------------
* Component: c
* Script: s
* External: e
* Homepage: h
* Template: t
* Query: q
* Worklist: w
* Navigation: n
* File: f
**/

/* Regex strings */
/* psc/psp Site Portal Node Content Type */
&sRegex = "/(ps[cp])/([^\/]*)?/([^\/]*)?/([^\/]*)?/([csehtqwnf]{1})/";
&sReplace = "/$1/$2_newwin/$3/$4/$5/";

/* Instantiate objects and replace */
&jUrl = CreateJavaObject("java.lang.String", &strUrl);

&Result = &jUrl.replaceAll(&sRegex, &sReplace);

/* Return modified URL */
Return &Result;
End-Function;

SQL.Fetch: SamFetch: [Microsoft][SQL Server Native Client 11.0]Function sequence error (SQLSTATE S1010) 0. (2,294)

This error occurs when your code is binding with Data-At-Execution.

The function sequence error must be in SQLFetch or the next API after SQLExecute.

SQL_NEED_DATA is returned when a parameter is bound with a StrLenOrInd value of SQL_LEN_DATA_AT_EXEC(x) or SQL_DATA_AT_EXEC.

If you are not explicitly setting this in the SQLBindParameter call, then it is likely an uninitialized variable that is occasionally being set to these values.

If you don't want to stream input parameters, the best way to deal with it is to fix StrLen_or_IndPtr to the appropriate value for the type.

If you do want to send Data at exec, you need to call SQLParamData after SQLExecute. It will return the value you passed in for "ParameterValuePtr" below.

You can then use this to key into the stream to send with SQLPutData. You use SQLPutData to push the data up in chunks until you are done, then call SQLParamData again to get the next parameter to fill or to finish streaming.

The final SQLParamData will return the return code that would originally have been returned by SQLExecute.

SQLRETURN SQLBindParameter(
      SQLHSTMT        StatementHandle,
      SQLUSMALLINT    ParameterNumber,
      SQLSMALLINT     InputOutputType,
      SQLSMALLINT     ValueType,
      SQLSMALLINT     ParameterType,
      SQLULEN         ColumnSize,
      SQLSMALLINT     DecimalDigits,
      SQLPOINTER      ParameterValuePtr,
      SQLLEN          BufferLength,
      SQLLEN *        StrLen_or_IndPtr); <--- this is the value that is causing SQL_NEED_DATA to be returned

Invalid Item_Type

If you are getting invalid ITEM_TYPE, do the following steps:

1. Check the institution set.
2. Check the effective date on your item type page. It should match with your default term.

3. Check the effective date on Charge Priority list.

Setup SACR > Product Related > Student Financials> Charges and Payments> Charge Priority List

FieldChange PeopleCode event won’t fire

Sometimes (on radio buttons for instance) FieldChange PeopleCode event won’t fire if the component is set to deferred processing and at the field level, the allow deferred processing checkbox is selected.

To always ensure that FieldChange (and other) PeopleCode events fire, leave the allow deferred processing checkbox unchecked for in the page-field settings.

In the component properties, change it to Interactive instead of Deferred.

Integrating population selection

Found an interesting source on how to integrate population selection into custom processes.

Source : http://www.udeps.com/Articles/Pop_Select.pdf

Download it here: http://www.udeps.com/Articles/Pop_Select.pdf

Adding Pop Select to your own processes

Here are the links to some documentation about Population Selection and how to integrate it into a custom process.

You can also check out the run control page for some of the PS delivered processes in CS:

· Campus Community > Service Indicators > Person > Mass Assign

· Student Financials > Charges and Payments > Group Processing > Mass Select Transactions

· Records and Enrollment > Career and Program Information >Process Student Groups

PeopleBooks:

http://docs.oracle.com/cd/E56917_01/cs9pbr4/eng/cs/lscc/task_DefiningandMappingContexts-ea7ff2.html#topofpage

HEUG

Oracle over view on how to enable Pop Select in your own processes:

https://www.heug.org/p/do/sd/topic=950&sid=5272

Example from a school that used it to build a process to assign advisors to students

https://www.heug.org/p/do/sd/topic=2364&sid=14908

Grade Change Audit Table Triggers

Grade Change Audit is done through table triggers.

There's a bit of info on this Customer Connection article: https://support.oracle.com/epmos/faces/DocContentDisplay?id=1495960.1

To turn on Grade Auditing, a SQL script just needs to be run against environment.

The grade audit one is called ssr_mss_grade_tr.sql.

You'll also see a bunch of other scripts in there starting with ssr_ to audit other tables.

If any future auditing is needed, just run the appropriate script in that folder. Only run scripts that contain _mss_ (Microsoft SQL Server); the other scripts are for Oracle and DB2.

Pages