Skip navigation.

Feed aggregator

Ask the Experts - 74

Nitin Pai - Fri, 2009-01-30 10:16
Hi I'd like to ask expert about " hint in peoplesoft". Except can choose "first_rows", "all_rows", can the sql be added the hint using index? Example, /*+ index (tb_name index_name )*/ Thanks, Thanks for posting your question! Yes, you can... Nitin Pai

Ask the Experts - 73

Nitin Pai - Fri, 2009-01-30 10:12
Hi,The default report orientation in sqr is portrait.If I have to change the default to landscape, where should I do that.Do we need any set up or modify any configuration file.Please advise Thanks for posting your question! As Asad Hamdare... Nitin Pai

Ask the Experts - 72

Nitin Pai - Fri, 2009-01-30 10:09
My User has a question:"Why should I run the Report(AE/SQR) using process monitor. Why doesn't it give the excel file just like that!" What is the best solution fot it? Especially when the output data is very huge.. I have... Nitin Pai

Ask the Experts - 71

Nitin Pai - Tue, 2009-01-27 10:57
Hi, I have a user from Japancomplaining about the alignment of two fields on a page. I have checked the same in English and its absolutely fine. So i adjusted the fields in Japanese language portal so that the fields... Nitin Pai

Ask the Experts - 70

Nitin Pai - Tue, 2009-01-27 10:52
Hi, PeopleBook says:"The only mutually exclusive actions within a single step are Call Section and SQL Statement; you cannot add a Call Section action to a step that already contains a SQL Statement action and visa versa. You can include... Nitin Pai

Ask the Experts - 69

Nitin Pai - Mon, 2009-01-26 14:32
How do I search for information in your blog. Collaborate had an article about determining user access to pages and there is SQL. I would rather copy/paste than to have to retype. Thanks. Search functionality is not available on this... Nitin Pai

Ask the Experts - 68

Nitin Pai - Wed, 2009-01-21 11:59
I am doing a mass data upload. I read a csv file and use CI for the upload. Each row in the CSV file is one row of data to be uploaded. If one of the rows has a validation... Nitin Pai

Ask the Experts - 67

Nitin Pai - Wed, 2009-01-21 11:00
Hi, Is there any way to copy the list of objects from App Designer (Upgrade View) into an Excel or Word Document? Making the Object Migration Forms and Technical Specification Forms, is a huge mechanical work, when the project is... Nitin Pai

Ask the Experts - 66

Nitin Pai - Mon, 2009-01-12 14:22
On press of prompt we get a search page. On this search page we have one dropdown field with NAME and PERSON_ID as values. Whenever we try to do a search with name field the system logs out. Through trace... Nitin Pai

Ask the Experts - 65

Nitin Pai - Mon, 2009-01-12 13:42
I've Application ver: CRM & Tools ver: 8.45.08 I'm using Sendmail function to send an email, through an application engine.But it is not working. When I run it in debug mode, the Sendmail function's return value is 3. Then... Nitin Pai

Ask the Experts - 63

Nitin Pai - Thu, 2009-01-08 11:22
Thanks for the prompt feedback, I'm using domodal as below(on a work field.fieldchange on primary page): DoModal(Page.SY_POLICY_LIST_PG, "Policies", - 1, - 1, 1, Record.SY_COMPANY_VW, CurrentRowNumber()); And on Secondary page activate i'm fetching through code as below: ScrollFlush(Record.SY_PLCY_MST_VW1); &rows = ScrollSelect(1,... Nitin Pai

Ask the Experts - 63

Nitin Pai - Wed, 2009-01-07 14:02
Hi, We are in the process of implementing the Journal upload using the Peoplesoft delivered excel spreadsheet. I went through the peoplesoft document and it gives the steps how to upload the spreadsheets. But I am looking for something how... Nitin Pai

Ask the Experts - 62

Nitin Pai - Tue, 2009-01-06 09:52
Hi, Is it possible to generate a PDF file from an App Engine? If so, is it possible to write HTML content into it (using file.writeline or any other way) Thanks,Rama Naidu. Thanks for posting your question! Here are the... Nitin Pai

Ask the Experts - 61

Nitin Pai - Tue, 2009-01-06 08:50
Hai, how to hire an employee using component interface and application engine, the employee details being given in a csv file Thanks for posting your question! Write an AE program in which you will use CI for JOB component. At... Nitin Pai

Ask the Experts - 60

Nitin Pai - Tue, 2009-01-06 08:44
Do we need to fetch data using code to populate the grid in a secondary page? Or can it be done by mapping keys from parent page to secondary page? What is the difference between using domodal and using the... Nitin Pai

Ask the Experts - 59

Nitin Pai - Mon, 2008-12-29 14:56
Hi,I have a security related issue. When the user run a (any type)process, process is showing success. But for some processes (All type of processes SQR, AE, Scheduled Jobs etc) process log displaying a message "You are not authorized to... Nitin Pai

Ask the Experts - 58

Nitin Pai - Mon, 2008-12-22 14:18
I am unable to view My Favorites in my portal sidebar. Also, this is not present in the PeopleTools > Portal > Structure and Content. Please help. Thanks for posting your question! In demo environments, Permission List PTPT1000 has access... Nitin Pai

Ask the Experts - 57

Nitin Pai - Thu, 2008-12-18 15:20
Hi, This is a very basic question, but I'm not 100% sure about it. Which code should be written in SavePreChange & which in SavePostChange event? I'm not able to fully differentiate between these two events. Thanks Thanks for posting... Nitin Pai

Ask the Experts - 56

Nitin Pai - Wed, 2008-12-17 11:59
thanks for replying to the writing rowset buffer to XML. I have Levl0,Level1 and Level2 records to be populated by this code. it populates but I have an issue with the following code. Local XmlDoc &inXMLDoc; Local Rowset &rs_Hdr, &rs_Dtl,... Nitin Pai

Ask the Experts - 55

Nitin Pai - Mon, 2008-12-15 11:00
What are the options provided by PeopleSoft for Item Security ? Is it possible to restrict a list of items to a group of users ? Example : Only IT dept users should be able to place a Requisition /... Nitin Pai