Monday, February 28, 2011

Difference between flush() and flushrow() methods in rowset

when i am working in PeopleTools tables for the specific requirement,
I've used flush() function to clear the rowset & saved the component. I though data might be deleted from the database but its dint.

Then used flushrow() to delete the row from the buffer & saved the component. Then the row got deleted from DB.

So the diff between these two is:

1. Flush will delete the rowset in buffer context & 'll not saved to the database(eventhough saved entire component).

2. Flushrow delete the row buffer, when you save the component the row got deleted from db too.


Using Flush more advantageous then Flushrow. Flush is not data Destructive.
:-)

Sunday, February 20, 2011

News: Peoplesoft HRMS 9.1 Feature Packs

Oracle started delivering feature packs yearly once by combing Bundles and maintainance packs.

More information available in Oracle Support : [ID 1268076.1]

The Current feature pack release in Dec 2010 & available in edelivery.

PeopleSoft 9.2 release planned for 2012.


Source:
Oracle Support



Thursday, February 17, 2011

News: Global Payroll for US country extn released


Global Payroll for US country extn released in 9.1 Feature Pack - December 2010.

To install these feature you must be using PeopleTools 8.51.02 & HR 9.1

Source
Oracle.

Wednesday, February 2, 2011

Thursday, January 27, 2011

BI Publisher Desktop Problem after Upgrading Office 2007 to 2010

I've recently upgraded Microsoft office 2007 to 2010 & BI publisher stopped working by saying the below error.

"The macro cannot be found or has been disabled because of your macro security settings and Object library invalid or contains references to object definitions that could not be found".


I googled  for the solution, to fix this followed the below steps:

1.Open Regedit
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Security\Trusted Locations :

follow the video:-  (http://www.youtube.com/watch?v=mWN9_L8tt54)



Wednesday, January 19, 2011

HCM 9.1 :Bulk Insert into long fields (CLOB)

when you have enable the rich text editor for long fields you can format the text in different styles & font.

If it is bulk data,

Use SQL insert statments to load and append the html tags (related to formatting) for the long text.


It works!!

:-)

Wednesday, December 29, 2010

AppEngine:%bind()_Dynamic Where Clause :Single Quote Problem

I've requirement to prepare dynamic where cluses based on setup.

In Setup: PLAN_TYPE values are stored like this as string : '10','11','15'.

This string  needs to inserted into AET ; In SQL Action, passed value using %bind().
eg: In AET
SR_TEST_AET.DESCR = '10','11','15'

SQL Action:
Select * from PS_SR_TEST_REC where plan_type in (%bind(DESC)).

Internally this sql is expanding differently as below : 


Select * from PS_SR_TEST_REC where plan_type in (''''10'',''11'',''15'''') -  due to this i faced lot of problem.

Solution: to insert dynamic clasue:                                                                                                                 

Select * from PS_SR_TEST_REC where plan_type in (%bind(DESC),NOQUOTES);
 it solves my problem & it expands as required

Select * from PS_SR_TEST_REC where plan_type in ( '10','11','15').


^_^

Monday, December 27, 2010

Peopletool 8.51: Peoplesoft Test Framework

with release of  8.51 peoplesoft comes with PS test framework (PTF) with record & playback.

PTF is located under /setup/PsTestFramework/setup.exe.

learn more follow the links:


 
 :-)