Skip navigation.

Feed aggregator

Ask the Experts - 52

Nitin Pai - Wed, 2008-12-03 10:27
Hi, The SQR Reports that have Chart Data fail to run in the Process Scheduler. The reason is shows is that " a creating function called in 'GRAFCAP' doesn't exist. The same report when run on a Win System using... Nitin Pai

Ask the Experts - 51

Nitin Pai - Tue, 2008-12-02 15:39
Hi, I am writing an interface SQR to connect 2 databases. We have created ODBC connection, and using the -db connection string variable for select/sql statements. The program runs correctly with SQRW. While running in Porcess Scheduler, I am getting... Nitin Pai

Ask the Experts - 50

Nitin Pai - Tue, 2008-12-02 14:47
I am trying Derived Work Record's Field value change at the end of one application engine program. Is it possible? Thanks in advance Thanks for posting your question! This is possible only if you are activating and using the component... Nitin Pai

Ask the Experts - 49

Nitin Pai - Mon, 2008-11-24 11:12
I have to set Advance Search as the default search option for a look up field/prompt table. When I set the default search option in the component property, all the look up field/prompt tables used in the component follows the... Nitin Pai

Ask the Experts - 48

Nitin Pai - Fri, 2008-11-21 09:52
Hi, I wanted to know how can one give 'display only' permission list to Administer workforce module. Thanks in Advance. - Asha Thanks for posting your question! You can do it by following below steps. 1. Create a new permission... Nitin Pai

Ask the Experts - 47

Nitin Pai - Thu, 2008-11-20 13:29
Hi, This is related to data conversion. I want to convert a string to a number. The string contains zero at the first position. while conversion, other values get converted except the zero. During print, we can print the zero... Nitin Pai

Ask the Experts - 46

Nitin Pai - Thu, 2008-11-20 12:52
HiCan we call Unix commands through peoplecode? Thanks Thanks for posting your question! Exec is a cross-platform function that executes an external program on either UNIX or Windows. This function has two parameter conventions in order to maintain upward compatibility... Nitin Pai

Ask the Experts - 45

Nitin Pai - Thu, 2008-11-20 09:54
Hello I want to know if I can add a benefit "Plan type". If so how do I do that? and I want to know which PeopleSoft contains Plan type information including description etc. Also, can u explain what is... Nitin Pai

Ask the Experts - 44

Nitin Pai - Wed, 2008-11-19 15:20
What are best business practices for auditing transaction data within PS? What type of reports are typically used to accomplish this? Thanks for posting your question! I will categorize this response into following sections. - Technology - Data Classification Technology... Nitin Pai

Ask the Experts - 43

Nitin Pai - Thu, 2008-11-13 15:25
Hi, I need a help for SQR Charts. I would like to replicate a Chart which is of type xy-scatter in Microsoft Excel. SQR also supports the same type. But, my X-axis data is Date type. xy-scatter-plot in SQR accepts... Nitin Pai

Ask the Experts - 42

Nitin Pai - Tue, 2008-11-11 09:56
Hi Experts, I just want a clarification regarding the ROWSELECT peoplecode event. What i believe is ROWSELECT event is used to filter the rows in search page,but it is not working like that. i have two field in a record(emp_rec)... Nitin Pai

Ask the Experts - 41

Nitin Pai - Mon, 2008-11-10 12:45
Hi While using my test system mistakenly i deleted the Time and Labour link from the Structure and content page , (navigation: Main menu > peopletools > portal > structure and content ) is there any way to restore the... Nitin Pai

Ask the Experts - 40

Nitin Pai - Fri, 2008-11-07 15:14
Hi, How to proactively monitor peoplesoft environments before the process goes down? Thanks & Regards,Ravi Thanks for posting your question! Below are excerpts from my previous posts on the blog site. How to monitor PeopleSoft process scheduler for availability? There... Nitin Pai

Ask the Experts - 39

Nitin Pai - Wed, 2008-11-05 09:26
Hi Experts, iam working on CRM 90 and PT848,when ia trying to add a page(RD_PERSON) to a permission list,my session expires . However iam able to another page of Add Company to the same permission list. Suggest me what could... Nitin Pai

Ask the Experts - 38

Nitin Pai - Mon, 2008-11-03 13:30
Hi.I am currently working on the peopletools version 8.22 and application version 8.43.489. I have one requirement for the prompt on the Bankcode field. Currently, the bank code field is prompted based on the company of the employee. It needs... Nitin Pai

Ask the Experts - 37

Nitin Pai - Mon, 2008-11-03 11:37
Hi,I am working on quick invoice extract in SCM 8.9.The condition is I am extracting the values from VCHR_HDR_QV,VCHR_LINE_QV,VCHR_DIST_QV.After this extraction I am running the voucher build process,according to peoplebooks the VCHR_MSCH_QV and VCHR_MSCL_QV(MIscellaneous header and line) tables have to... Nitin Pai

Ask the Experts - 36

Nitin Pai - Fri, 2008-10-31 13:25
What is the best way of identifying UNUSED panels /Pages in the Application / Database. Currently , Present scenario at my end I am filtering the pages which are created But Not used in Components . Still is there best... Nitin Pai

Helping young Europeans to start their own IT businesses

Sergio Giacoletto - Tue, 2008-08-19 15:44
If you are a young European IT entrepreneur with a good idea for a business, then maybe we can help you . . . Last month on the 9th July it was my privilege to speak at an Oracle event...

Farewell Big O, Hello Big G

Brian Duff - Thu, 2008-08-14 11:00
Tomorrow is my last day at Oracle. I was one of the early wave of employee bloggers at Oracle. I wrote my first entry five years ago, and was pretty productive on the blogging front for a while. Set up... Brian Duff

Another change to thecheapdba.com and jameskoopmann.com

Cheap DBA - Sun, 2008-05-18 12:01

Sorry for the inconvenience but I have made a drastic move to merge the individual websites I maintain into one. Over the next couple of weeks, hopefully sooner, Everything, websites & blogs will be merged into a single website: www.jameskoopmann.com. This will enable me to communicate via a single website and hopefully make it easier on you and myself. You will quickly notice that I have taken a huge leap of faith and am using a blogging interface for this. So come stop by, take a look around, and let me know what you think. Just remember I am just now begging the transition so be a bit patience. But I DO want your comments.

Please change bookmarks, RSS, etc. as thecheapdba.com, blog.thecheapdba.com, and blog.jameskoopmann.com will be going away soon.

Thanks,
James