Skip navigation.

Feed aggregator

Ask the Experts - 83

Nitin Pai - Fri, 2009-02-13 09:36
Hi, I have a Field "Country" on a page, actually on a subpage. Main Table: A, Subrecord: CM_ADDRESS_SBR, Subrecord: ADDRESS_SBR -> A contains CM_ADDRESS_SBR-> CM_ADDRESS_SBR contains ADDRESS_SBR It has COUNTRY_TBL as the prompt table in the subrecord. It gives the... Nitin Pai

Ask the Experts - 82

Nitin Pai - Fri, 2009-02-13 09:26
Hi, Can we create a View in App Designer, which accesses tables from another link server?eg:select EMPLID from [psserv6].[HRUAT].dbo.PS_JOB Also I have an uppercase problem with the following View. %NoUppercase SELECT EMPLID , GRADE FROM [HRSTAG].dbo.PS_JOB the owner "dbo" should... Nitin Pai

Ask the Experts - 81

Nitin Pai - Mon, 2009-02-09 15:28
I need some help from anyone who has faced/resolve the issue: We had an AE (EPM 8.9)which runs in DEV & UAT in less than 30 min. But we ran the same AE in PROD it gets hanged forever. Its... Nitin Pai

Ask the Experts - 80

Nitin Pai - Mon, 2009-02-09 15:19
If we have a client who is multi-companies and each company have different standard hours, how can we achieve this since 1 user profile can only be tied to only 1 Primary permission list? (in Peoplesoft HCM 9.0 & Tools... Nitin Pai

Ask the Experts - 79

Nitin Pai - Fri, 2009-02-06 09:05
I would like to know if there's a kind of functionality in PSGL where we can run allocation ONLY if the balance of the pool is negative. If the balance of the pool is positive, then no additional journals will... Nitin Pai

Ask the Experts - 78

Nitin Pai - Thu, 2009-02-05 12:59
Hi PeopleSoft Teams,To let us know the feasibility of invoking a CI present in X instance from another instance Y either with or without any links. Also how to pass the parameters for the same. Thanks for posting your question!... Nitin Pai

Ask the Experts - 77

Nitin Pai - Wed, 2009-02-04 13:29
We have a PRD1 PS enviroment and PRD2(copy of PRD1) PS environment.PRD2 gets refreshed every month from PRD1. I would like to create a userid(like PS) in PRD1 with Display Only access to everything and when the PRD2 gets refreshed... Nitin Pai

Ask the Experts - 76

Nitin Pai - Wed, 2009-02-04 12:53
Hi,We are implementing CRM for a Bank. For that we are importing all the Customers, account details and different relationships between them through various AE's. The AE programs are required to be executed in following sequence;1. Import Personal Customer Details.2.... Nitin Pai

Ask the Experts - 75

Nitin Pai - Mon, 2009-02-02 15:26
Hi, I'm having trouble with my PS Process Scheduler in Version 7.5. Sometimes it starts without any problems but sometimes it goes a little something like this: STARTTING PROCESS SCHEDULER PSNT ON DATABASE XXXXXXX. PROCESS SCHEDULER WILL BE RESTARTED UP... Nitin Pai

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