We have our functionals update this table as needed, we use to assign the passport based on the country but now we assign a Visa based on country USA, we enter...
We can turned-on audit on records. Can we turned-on audit on a Record View? Please advice ... Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from...
Hi Shoaib, Ours went pretty quickly. I did all the file deployments manually. Which step took you the longest time? If it is the file deployment, you should...
Dear All I need one small information regarding run control page ... 1. I have assigned two run control page attached with same component 2.First run cntrol...
Hi Peter, This is what I used to change the old dates back to the correct values: UPDATE PS_TL_DSTOFFSET SET DSTDTTM = '2005-04-03 02:00:00.000' WHERE DSTDTTM...
Hi people, I am trying to invoke a word Template file from an SQR. This is the procedure written for it. begin-procedure invoke_word let $winword='D:\Program...
Hi, I would like to ask for your expertise on how to improve search record performance: We have a totally new component, which only has one page. But, this ...
Here is a 'rough' macro in vba that will delete all zero value rows in the current column (this is used for removing rows from summaries of data), and there...
Hi, This can be done by writing a macro to insert page breaks whenever the value in a certain column changes, then calling the macro with the NvsInstanceHook. ...
Hi Mary, Thanks for the info on the DST T&L changes. I didn't know about the TL_DSTOFFSET table, so that was very helpful. I am trying to do the update in...
By any chance does anyone have users in a TimeZone that does not recognize DST? We have 1 in AZ. When the Time Changes, so do the displaying of their...
Hi Bob, Thanks for the info. I should probably have explained that I am not responsible for the general Tools DST updates, just the T&L ones. According to our...
Run a SQL trace to see what statements are taking too long. It might be an issue of specifying custom indicies, adding indicies, or updating table statistics. ...
Ah, RI. I believe PeopleBooks lists all of the Triggers for RI. An appendix, I believe. We just turned it off altogether. Our TL data goes back to 7.5 and ...
Mary - Thanks for the SQL. I found the fix you mentioned in your e-mail. It's Oracle solution 703978. It says in the heading: TL8.x: DST T&L Zone Changes...
Hi Peter, Yes, that's the one. I just found it yesterday too -- it's not listed on the PS "DST Page" like it should be. We downloaded it and had our tech...
Well, actually with the statement ADD_MONTHS(A.BIRTHDATE, 216) >= SYSDATE you get all 18 or UNDER 18 ... so throw a NOT in front of it scrapping the "=" sign...
Hi All, I have a question about GL configuration/processing for Commitment Accounting in 8.9 and forward. If the organization is Commitment Accounting for all...
I did a 2 step upgrade for one of the City Govt from 7 to 8.3 HRMS. If you want to go to 9.0 from 8.3, you need to do this. If oracle is your Database. and if...
We will soon be upgrading from HR 8.8 to HR 8.9. I want to completely redo our Security to make naming conventions more consistent and to consolidate some...
Thanks, Chris. That's exactly what our developer ends up doing. ... Hue Lam hlam@... 312-629-6560 [Non-text portions of this message have been removed]...
I have Query that uses an 'Exist' for a SubQuery. Everything works great; however, I want to pull 3 fields off of the SubQuery record and display them in my...
First, if your existing Perm Lists are working for you, I wouldn't recommend re-creating them unless there is some overwhelmingly compelling reason. As for...
... You would have to join the record into the main select of the query to see them, as the record in the sub-query is only visible to the sub-query at this...
I have always had to use the results of the subquery to allow me to know that it was 'OK' to join the main query to the record(s) called in the subquery. I...
In Query (8.8), I am trying to get the Last Row of a non-Effective Date Date field. For example, I want the row with a Max(Exam_DT)...; however, Last Eff Dt is...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
