PeopleSoft - AppEngine

ORA-01407: Cannot Update ('SYS ADM'.'PS STAGE TMP'.'DEPTID') to NULL

Hi All,

I am facing ORA-01407 error while updating deptid field but when I checked the SELECT query rt there was no such data that holds NULL deptid in fact there were 12 rows with DEPTID data in it.

UPDATE %Table(PS_STAGE_TMP)TMP
SET TMP.DEPTID = (
SELECT BI.DEPTID
FROM PS_BUS_UNIT_BI BI
WHERE BI.BUSINESS_UNIT = TMP.BUSINESS_UNIT_BI
AND BI.PLACEMENT_TYPE=TMP.PLACEMENT_TYPE
AND BI.LOCAL_FLAG=TMP.LOCAL_FLAG
AND BI.EFFDT=(
SELECT MAX(A.EFFDT)
FROM PS_BUS_UNIT_BI A
WHERE A.SETID=BI.SETID
AND A.ACCT_TYPE=BI.ACCT_TYPE

AppEngine Performance issue

Hi All,

One of our jobs that consist AE was taking 10 minutes earlier and now a days it is taking 35 +minutes to get completed.

The SQL it is getting stuck at "ANALYZE TABLE %Table(REC1_TAO) COMPUTE STATISTICS".
Can you let me know what I can do to tune SQL and performance?

We have tried to use %UpdateStats(REC1_TAO,high) but not working, tried to check Indexing aswell no luck.

PS ver 8.9
Tool: 8.48

Regards,
Siva

PeopleSoft Tree Manager

Hi,

we are facing an error while deleting child node in Tree Manager, the page automatically timout occured. we increased service timout parameter but did not help to us.

we verified application server logs find an error like :

(NETSPACE 5.0; WINNT) ICPanel

can not convert type Boolean to object type ApiObject.(180,604) PSTREEMGRFUNCS.FUNCLIB.FieldFormula Name:checkAPEEMGRUNCS.TREECTLEVENT.FieldChange Name:DeleteNode

can any one know the issue.

Sendmail Function In Peoplecode Not Sending Email

Hello !!

I'm sending the sample code through page and Application Engine. It's working fine with page although when run the code in AE process goes in Processing state for undefined time.

Does anyone know how to resolve this?

Local string &MAIL_CC, &MAIL_TO, &MAIL_BCC, &MAIL_SUBJECT, &MAIL_TITLES, &MAIL_TEXT, &MAIL_FILES, &MAIL_FROM, &REPLYTO, &SENDER;
Local number &MAIL_FLAGS;

&MAIL_FLAGS = 0;
&MAIL_TO = "email-address-message-going-to";
&MAIL_CC = "";
&MAIL_BCC = "";
&MAIL_SUBJECT = "Test email";
&MAIL_TEXT = "Sending an email from PeopleCode.";
&MAIL_FILES = "";

generic application engine file attachment program steps

Hi,

anybody ca help me regarding how to write application engine file attachment program in generic way

Regards
raju

Insert hire rows in JOB Data without using CI

I Would like insert hire data in JOB Data component without using SQL.
Could you pls provide insert SQLs for this?

File layout

Hi,

I have to import data from a csv file which contains the header as a date. And the body contains the details of the transactions.The footer contains the count of the number of rows processed in transaction. I have to load the header in Table 1 and validate whether the date matches with the system date .And the transactions data in a separate table 2 and the footer into the table 3 and have to validate whether the total count of the transactions matches with the footer . Please help me out.

To load 1000 rows using application engine

I want to load 1000 rows from a record using app engine.
It shud not stop for errors.
The process shud display error in log and continue processing.
How to achieve this?Kindly help me.

running from sqr in peoplecode callappengine function

Hi guys,

I am running sqr from peoplecode callappengine function the following error will come"unable to open fileindex" can anyone help..

Regards
Guest

Application Engine inbound program

Hi,

Can you please send application engine inbound program code(without filelayouts)

Regards
Ravi