Hi All,
We have several crystal reports on ePerformance that are returning no information. The reports are basically printing blank.In the past when we had this problem I would run the Core Row Level Security processes.Recently though when I run this process for Transaction Sec. Join Table: SJT_PERSON, the process run to No Success.Any thoughts to run it success..

Thanks,
Ashok K.

Hi All,

I have date issues in the SQR AS Shown below
one value is AGE-LIMITSTUD=2009-03-03(birthdate+Age-limit)
and another one is (currentdate-30) 14-NOV-2009 .when i compare these two dates it is not working properly.
I can use Edit option which format i need to change these two dates two compare b'cause one is getting (2009-03-03 and another one is 14-NOV-2009 ) please help me on this.

Thanks in advance
sudha

Hi All,

I have one issue in the SQR where it will creates the employee_details.txt output file ,this file i need to send to Different server with Encryption.
we are Using, call system command in the SQR for this to Execute
we will create all the FTP related command in .batch file and call this batch file in the SQR
Here my Question we are using PGP Command for encryption ,can any one explain me the Below command ,Iam new to PGP commands.I have idea on FTP process.
customer has sent me their Public Key and Fingerprint.txt file

Hi All,
We are implementing the DataConversion Process for ePerformance 8.9 to 9.0.Im new for this implementation. Now Im struck at an instance.We have data in a table T1 with 90 rows in 8.9 and 160 rows in 9.0.And the problem is that some rows with key fields are carrying different data in both the databases for the same key fields.
In 8.9:
key:a1
col1:120
col2:130

In 9.0
key:a1
col1:124
col2:130

Can anyone help me how to move this data to the upgraded database with out loss of data..

Thanks,
Ashok K.

Hi All,

we are getting the below error, (Field is Required x_trm_tbl - Action(124,64)
actually we are not using this record in that page also. but dont know why it is coming. Can any one please tell when this error comes.

thanks,
San

Hi All,
Can anyone provide me a list of Setup and Transaction tables for eHR8.9 version if you have them..Any help appreciated.

Thanks,
Ashok K.

Hi All,
While giving Rule step definition properties for an Approval Rule set in work flow,we assign max and min amounts for AMT_PERSONAL and PO_TOTAL_VAL. Why do we have both AMT_PERSONAL and PO_TOTAL_VAL? Ofcourse one field is necessary to give grand total amount.Any thoughts!!!

Thanks,
Ashok K.

Hi All,
Im designing a page in Peoplesoft with an object HTML Area.Im able to expand the root and 1st level child nodes.When im trying to expand 1st level child im getting the child leaves along with a repeated 1st level child node as

First | Previous | Next | Last | Left | Right
-ERPA_AK_AE_6
-Records
+Records
ERPA_AK_APP_6

Where ERPA_AK_APP_6 is the Record present in the Project ERPA_AK_AE_6.Im fetching the records from the project using "CreateSQL".Im trying so that the 1st level child node(Record) should not expand again.Please help me..

Can anyone tell me the differences between Crystal Reports and SQR's in PeopleSoft.Which is the best of them?

Can any one tell me how to insert values from one table to another table using people code based on a condition on a field.we cant use sqlexec as it returns only one row.