Rahul Bagade

Hi,

I’m facing a problem with the worklist. When I enter a particular

component through the menu navigation, the component launches. But when

I try to enter to the component thro’ a worklist entry, it shows “you

are not authorized for this page”. And this occurs only for a

particular UserId. What might be the problem??

Thank you for posting your question

Answer –

This should not happen in case of Worklist even. The only possibility is that the worklist is directing you to some other Page/ Component. Please investigate further to confirm that you are checking the correct component/page. If this doesn’t solve your issue, please let me know the Component name and the worklist so that I can check it at my end.

Shekhar Goel

Rahul Bagade

Hi,

I am using rowset.flush method to clear all data from the scroll and Using rowset.select(“Some Condition”) to populate the same scroll with additional criteria. Whenever I try to Save the component with some data changes, I am getting error message “Page Data Inconsistent with Database”.

If I remove rowset.flush, rowset.select(“Some Condition”) statements Save is happening normally. Can you please tell me why I am getting above error?

Thank you for posting your question

Answer –

Please check if any of the following points are valid for your PeopleCode:

1. You are changing the page data from SavePostChange PeopleCode, without making a corresponding change to the database.

2. Changing the database via SqlExec, for data that is also in the component buffers.

If this doesn’t work, could you please send me the piece of code that’s giving you the error.

Shekhar Goel

v_hotstepper

Hi,

I want to extract the longtranslatevalue of a transltae field in sqlexec statement.

eg

sqlexec(‘select field from Table where Field1=2’, &field);

How to get the long translate value of “field”

Thank you for posting your question

Answer –

You can get this value from PSXLATITEM record and the fieldname is XLATLONGNAME.

Shekhar Goel

Posted by Senthil Kumar Theagarajan
Comments (4)
January 6th, 2010

Comments (4)

Rahul Bagade - March 30th, 2010

Hi, I am using CSV file & Component Interfave to upload data in Peoplesoft Component. Can you please tell me how to skip errorneous row? My CSV file is having 10 rows and if there is an error on 5th row, I want to skip it and continue with 6th and above row.

Ravi Jain - February 6th, 2010

How to design / create Parallel Processing AE for Data Import ?? We have to import millions of customer information from legacy system into PeopleSoft CRM. We have developed an AE which uses delivered Application Packages to do that. However, it requires 4.5 days to import 3.2 lac customer info. 1. How to develop an AE, multiple instances of which will import data in Parallel, thus reducing the import time ? 2. What will be impact (or likelyhood of deadlocks) if all the instances insert / update data for same set of records ? Environment Details: CRM 9.00, PeopleTools 8.49 DB: Oracle 10g Enterprise on AIX 6.1 (4 dual core Xeon / 8 GB RAM) App Server: Windows 2003 Enterprise

Anurag Mishra - January 19th, 2010

Hi Sujeet, Business Title Field captures actual official job title for an employee which may be different from the job code/job title or you can say 'Designation'. This is located on the 'Employment data' page. also it depends upon customer how they want to use it. If customer is using full or partial position management you can default the business title for the position so whenever you are entering a position for an employee on the job data work location page business title will get defaulted for the position number. Hope this helps. Anurag Mishra

Sujeet Kumar - January 19th, 2010

What is Business Title field in PeopleSoft HCM?? How we capture the Designation of employee in PeopleSoft HCM.

Comments are closed.