PeopleSoft
| Forum | Topics | Posts | Last post |
|---|
decodePC.sqr as written by David L. Price has been rewritten to decodePC.java and expanded. It's general purpose is decoding PeopleCode stored as BLOB. The PeopleSoft database is accessed via a JDBC connection therefore there is no need to use Application Designer to look at PeopleCode, Application Engine programs, SQL, and XSLT. decodePC.java can read Application Engine programs and Application Packages and output them to a text file so you can get on with solving business problems.
Example of compiling decodePC.java with Oracle JDBC on a Unix box from a command prompt in the directory where decodePC.java exists:
javac -classpath /directorypath/ojdbc14.jar ./decodePC.java
Example of running decodePC.class with Oracle JDBC on a Unix box from a command prompt in the directory where decodePC.class exists:
java -classpath .:/directorypath/ojdbc14.jar decodePC
Example of compiling decodePC.java with MySQL JDBC on a Unix box from a command prompt in the directory where decodePC.java exists:
/usr/local/src/jdk1.6.0/bin/javac -classpath /directorypath/jars/mysql-connector-java-5.0.4-bin.jar ./decodePC.java
Example of running decodePC.class with MySQL JDBC on a Unix box from a command prompt in the directory where decodePC.class exists:
/usr/local/src/jdk1.6.0/bin/java -classpath .:/directorypath/jars/mysql-connector-java-5.0.4-bin.jar decodePC
| 2 | 10 | by rsandoz |
User saves Project in Application Designer using Tools, Copy Project, To File.
Within the saved .xml file <peoplecode_text> is XML text of the PeopleCode, but this is not what ends up in PSPCMPROG.PROGTXT. Note that this text has XML escape characters, e.g., double quote (ASCII hex 22) is represented as ".
<peoplecode_blob> is very similar to what ends up in table PSPCMPROG column PROGTXT, but not exactly. For example, object references in <peoplecode_blob> refer to <lpPnt> <row> entries in the XML which will become references to entries in table PSPCMNAME.
| 0 | 0 | n/a |
Following message appears when attempting to delete or rename the
message: "Object is in use by the Publish / Subscribe system". Tools, Copy
Project From File cannot update the message object.
1) Need to purge message data from PS region with DataMover script
AppMsgPurgeAll.dms.
2) Need to uncheck the Done indicator in the Project's Upgrade tab if
attempting to bring in project data again.
| 0 | 0 | n/a |
Some of the slickest technology around allowing all of the business logic to exist in one place. OK, PeopleSoft can be absurdly hard to change, but the one little piece of logic to do what you want it to do is generally in one place.
| 1 | 2 | by Anonymous |
When populating api messages that contain dates, it's not possible to use select *, instead in Application Designer use Meta-SQL %DateOut to convert dates to format CCYY-MM-DD.
| 0 | 0 | n/a |
Create a new Effective Date Publish utility, EOP_PUBLISHE for PS ver 8.8, (it's an Application Engine process) so that full message is published when any data becomes effective, else PeopleSoft publishes a partial message and FI Connect is not designed to handle it.
EOP_PUBLISHE is a scheduled process viewable via PeopleTools > Process Scheduler > Process Monitor. EOP_PUBLISHE can be run one time via: (PS 8.8) Enterprise Components > Integration Definitions > Initiate Processes, Effective Date Publish. (PS 8.4) Define Integration Rules FDM > Request Processes > Effective Date Publish.
| 2 | 4 | by webmaster |
http://sfs.doit.wisc.edu/support/
Entity Relationship Diagrams.
Helpful for those times when you need to know about PeopleSoft tables, but haven't been given database access.
| 0 | 0 | n/a |
PeopleSoft (PS) carries a lot more information about a vendor than PP therefore it makes sense that it is the master application. PS's vendor maps to PP vendor and the PS vendor location maps to the PP vendor suffix. 1
| 0 | 0 | n/a |
SendMaster utility is a basic tool for sending xml messages to a server:port:service and displaying the xml response.
Attached is a Java program that does the same thing as SendMaster.
| 1 | 2 | by webmaster |
Java client program using SAAJ to build OASIS "WS-Security Core Specification 1.1" SOAPHeader to provide the Oracle PeopleSoft Integration Broker header with <IBInfo><From><ExternalUserName>
| 2 | 2 | by webmaster |
This is related to api messages being published and subscribed to by the PeopleSoft Integration Broker.
| 2 | 4 | by Anonymous |
|