tag:blogger.com,1999:blog-84580734634379593902024-03-13T14:08:15.804-07:00Peoplesoft*** This Blog is no longer actively managed ***Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.comBlogger113125tag:blogger.com,1999:blog-8458073463437959390.post-39179968798860737112013-10-02T08:22:00.001-07:002013-10-02T08:27:53.673-07:00How date format works on Activity based email notification<p>Below are the sequence of steps the activity checks for date format.</p> <ol> <li>Initially this looks for user defined date format in Regional Settings. <li>If above setting is not defined then this looks for the date format set for the browser language option settings. <li>if above 1 and 2 settings are blanks, then this takes the date format from system level defined settings.</li></ol> <p><strong><u>Details of each step with screenshots.</u></strong></p> <p>1. User can define date format in My personalizations.</p> <p><a href="http://lh5.ggpht.com/-g-Z9DBMyGAQ/Ukw6HNKQI2I/AAAAAAAABr0/7gcQjh1vjW0/s1600-h/ate1%25255B3%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="ate1" border="0" alt="ate1" src="http://lh3.ggpht.com/-NDJhAiJ9N7I/Ukw6IGWiFCI/AAAAAAAABr8/aWo8DTPXP6E/ate1_thumb%25255B1%25255D.png?imgmax=800" width="698" height="277"></a> </p> <p>2. Local default settings for browser language options.</p> <p><a href="http://lh5.ggpht.com/-LAcieSjWLqk/Ukw6JhBuJjI/AAAAAAAABsE/RE1Q3jnsXV8/s1600-h/date2%25255B3%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="date2" border="0" alt="date2" src="http://lh4.ggpht.com/-wabL2U6x2IM/Ukw6K7qMwxI/AAAAAAAABsM/_l1JZfnDSws/date2_thumb%25255B1%25255D.png?imgmax=800" width="794" height="730"></a> </p> <p></p> <p><b>“M stands for MM/DD/YYYY”</b> and “<b>D stands for DD/MM/YYYY”.</b></p> <p>Browser language option looks like below.</p> <p><a href="http://lh5.ggpht.com/-sQ1c-a4SPQs/Ukw6Lhdu9ZI/AAAAAAAABsU/qxlmSbl8fVg/s1600-h/date5%25255B3%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="date5" border="0" alt="date5" src="http://lh4.ggpht.com/-Pw145MY7260/Ukw6MVnaz1I/AAAAAAAABsc/qty5Qm1l6XM/date5_thumb%25255B1%25255D.png?imgmax=800" width="369" height="401"></a> </p> <p>3. System level default settings.</p> <p><a href="http://lh5.ggpht.com/-9--XHbaK1Dw/Ukw6Nj_iupI/AAAAAAAABs4/AqUQQCz8tNk/s1600-h/date4%25255B7%25255D.jpg"><img style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" title="date4" border="0" alt="date4" src="http://lh6.ggpht.com/-1rZMr22xKa8/Ukw6QBGJIdI/AAAAAAAABtA/WI73m2NdURo/date4_thumb%25255B5%25255D.jpg?imgmax=800" width="929" height="558"></a></p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com2tag:blogger.com,1999:blog-8458073463437959390.post-55528647663228279072013-05-21T08:42:00.001-07:002013-05-21T08:42:56.181-07:00Analytic Engine and Analytic Grid with simple Example<p>This example is to understand how to create and use Analytic Grid and Analytic Engine which is available in PeopleTools.</p> <p>This is a simple example to create Read Only Analytic Grid without any PeopleCode used. </p> <p>This can be more complex if Analytic Grid is used as Read/Write. (I will not cover Read/Write Analytic Grid in this example).</p> <p><strong>Example: To Create Analytic Grid for Location based Department based Head Count from Job record.</strong></p> <p><strong>Preview:</strong></p> <p> <a href="http://lh3.ggpht.com/-6pc7Sfes_Ok/UZuVewWgd6I/AAAAAAAABTg/OtV4WaeVqrE/s1600-h/image%25255B15%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; margin-left: 0px; border-left-width: 0px; margin-right: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-6c4o53htN0c/UZuVfkm7HhI/AAAAAAAABTo/fZkbPiDPVJs/image_thumb%25255B11%25255D.png?imgmax=800" width="666" height="347"></a> </p> <p>Below Steps are used to create Analytic Grid for above example:</p> <table border="0" cellspacing="0" cellpadding="2" width="679"> <tbody> <tr> <td valign="top" width="677"> <p>Note: Analytic Grid can be based on Physical Record or View. However if view is used then the Analytic Grid will be read-only. For read-write analytic grid physical record is required with the version record.</p> <p>As this example is to demonstrate only read-only I am using view for this example.</p></td></tr></tbody></table> <p><strong>Step 1:</strong> Create a view over Job record or Job effective date view with LOCATION, DEPTID, PM_COUNT fields. <strong>This is used for Analytic Grid Data Cube Collection</strong></p> <blockquote> <p>a) Create a view and insert the fields to the record LOCATION, DEPTID, PM_COUNT. PM_COUNT is a number field and <strong>LOCATION and DEPTID as Primary Key</strong>.</p> <p>b) Save the view as “PM_HEADCOUNT_VW”</p> <p>c) Provide the below SQL in the view.</p> <table border="0" cellspacing="0" cellpadding="2" width="277"> <tbody> <tr> <td valign="top" width="275"> <p>SELECT LOCATION <br>, DEPTID <br>, COUNT(*) AS PM_COUNT <br> FROM PS_PM_JOB_VW <br> GROUP BY LOCATION <br> ,DEPTID</p></td></tr></tbody></table></blockquote> <p><strong>Step 2:</strong> Create a work record which is used for <strong>Analytic Grid Presentation Cube Collection.</strong></p> <blockquote> <p>a) Create a work record with LOCATION, DEPTID, PM_COUNT fields.</p> <p>b) Save the work record as “PM_HDCOUNT_WRK”</p></blockquote> <p><strong>Step 3: Creating Analytic Model.</strong></p> <blockquote> <p>a) Create New Analytic Model from Application designer.</p> <p>b) Right click on the “<strong>Dimension</strong>” and create two dimensions as LOCATION and DEPTID as shown in the image.</p> <p><a href="http://lh5.ggpht.com/-67iqn82MwsM/UZuVgbfUsVI/AAAAAAAABTw/XSM9NVzaFEU/s1600-h/image%25255B19%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-qANe4Kt4X5E/UZuVgwnFuyI/AAAAAAAABT4/_a3h1d3feVo/image_thumb%25255B13%25255D.png?imgmax=800" width="628" height="133"></a> </p> <p>c) Save the Analytic Model as “PM_HEADCOUNT_AM”</p> <p>d) Right Click on the Cubes and Create “HEADCOUNT” cube and attach “LOCATION” and “DEPTID” dimensions to the cube as shown below.</p> <p><a href="http://lh3.ggpht.com/-tgGHXdRpXl8/UZuVhr2R2sI/AAAAAAAABUA/KQvIh5k934I/s1600-h/image%25255B23%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-55tU44fouEg/UZuVic567XI/AAAAAAAABUI/7LQvBWX6X6I/image_thumb%25255B15%25255D.png?imgmax=800" width="628" height="207"></a> </p> <p>e) Right Click on the Cube collection and create “DATACUBECOLLECTION” cube collection and associate “HEADCOUNT” cube to the Cube Collection and assign the created view “PM_HEADCOUNT_VW” in “Main Record” section of General Tab as shown below.</p> <p> <a href="http://lh6.ggpht.com/-hiGqx1JN-bc/UZuVi4B3NcI/AAAAAAAABUM/RnW8SMFFXVA/s1600-h/image%25255B27%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-mbUrZe8ty7c/UZuVji8ktrI/AAAAAAAABUY/tsP_tcHbY34/image_thumb%25255B17%25255D.png?imgmax=800" width="628" height="164"></a> </p> <p>f) Map the appropriate fields in “Field Map” Tab as shown.</p> <p><a href="http://lh3.ggpht.com/-ClnIfu1jlFs/UZuVkF2jVFI/AAAAAAAABUc/Bgx0jNpHJv4/s1600-h/image%25255B31%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-Rpfnlq90mEs/UZuVkpV9SrI/AAAAAAAABUo/Wi56pY-92Bs/image_thumb%25255B19%25255D.png?imgmax=800" width="628" height="192"></a> </p> <p>g) Right Click on the Cube collection and create “PRESENTATIONCUBECOLLECTION” cube collection as above and associate “HEADCOUNT” cube to the Cube Collection and assign the created work record “PM_HDCOUNT_WRK” in “Main Record” section of General Tab as done for “DATACUBECOLLECTION”. Map the appropriate fields in the “Field Map” Tab.</p> <p><a href="http://lh4.ggpht.com/-aDj9JAA6iow/UZuVlTsHQoI/AAAAAAAABUw/oaH-7xlKsp0/s1600-h/image%25255B36%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-qFlyWjYbC-8/UZuVmbgqHMI/AAAAAAAABU4/3K4fdy-FHBs/image_thumb%25255B22%25255D.png?imgmax=800" width="700" height="244"></a> </p> <p>h) Create “Explicit Dimension Set” to filter value based on Location or Department. To Create “Explicit Dimension Set” Click on “Explicit Dimension Set” shown in above example and right click to add “Add Dimension Set”. Add the dimension set as shown in the below Image.</p> <p><a href="http://lh6.ggpht.com/-2_NTGQ89ORg/UZuVm6ojSUI/AAAAAAAABU8/0dScRQVDkc0/s1600-h/image%25255B40%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-9QVJqzZGSm4/UZuVnlgrSVI/AAAAAAAABVI/DYLR-Hc8yZA/image_thumb%25255B24%25255D.png?imgmax=800" width="451" height="347"></a> </p> <p>i) Save the Analytic Model.</p></blockquote> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p><strong>Step 4: Creating Analytic Type.</strong></p> <blockquote> <p>a) Create new Analytic Type from application designer and associate the Analytic Model (PM_HEADCOUNT_AM) to this Analytic Type. To add Analytic Model click on “Model Tab” of Analytic Type and from Menu bar under Inset menu select “Analytic Model..”. Select the PM_HEADCOUNT_AM Analytic model and this will add into Analytic Type.</p> <p><a href="http://lh4.ggpht.com/-fJWavNHPMZA/UZuVoCCYUmI/AAAAAAAABVQ/3JyNhnHTrRw/s1600-h/image%25255B44%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-GF8apL1hcZY/UZuVoqnURpI/AAAAAAAABVY/yEfpKFMs1k0/image_thumb%25255B26%25255D.png?imgmax=800" width="463" height="92"></a> </p> <p>b) Save the Analytic Type as “PM_HEADCOUNT_AT”.</p></blockquote> <p><strong>Step 5: Creating Analytic Instance.</strong></p> <blockquote> <p>a) Navigate to the Main Menu > PeopleTools > Utilities > Administration > Analytic Inst. Create/Del/Copy in the PIA. <p>b) Select the Analytic Type (PM_HEADCOUNT_AT) and <strong>Provide the Analytic Instance name (PM_HEADCOUNT_IN)</strong>. Click on “<strong>Create Analytic Instance”</strong> button. <p><a href="http://lh5.ggpht.com/-bD2UGJtuqhQ/UZuVpeIMkUI/AAAAAAAABVg/NxasXeAs_MM/s1600-h/image%25255B48%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-wwlo8UrTwds/UZuVsAw-nLI/AAAAAAAABVo/q3YMCzuK3qU/image_thumb%25255B28%25255D.png?imgmax=800" width="541" height="370"></a> <p>c) This will create the Analytic Instance “PM_HEADCOUNT_IN”.</p></blockquote> <p><strong>Step 6: Load Analytic Instance.</strong> <blockquote> <p>a) Navigate to the Main Menu > PeopleTools > Utilities > Administration > Analytic Instance Load/Unload in the PIA. <p>b) Search for “PM_HEADCOUNT_IN” (i.e. Appropriate instance name according to you) <p><a href="http://lh6.ggpht.com/-0-v91MGeIVo/UZuVtbghLRI/AAAAAAAABVw/8RO7jh0Ga3g/s1600-h/image%25255B52%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-WkIk9vVLQ2A/UZuVuF2kqdI/AAAAAAAABV4/XMv09iDw3XY/image_thumb%25255B30%25255D.png?imgmax=800" width="628" height="261"></a> <p>c) Click on “Load Analytic Instance” button from the below Screen to load the Analytic Instance. <p><a href="http://lh3.ggpht.com/-S0-ze0MZ9Tw/UZuVzlsJU0I/AAAAAAAABWA/6kjtjEAQTm4/s1600-h/image%25255B60%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-CkWVBd8ywBY/UZuV0csvW5I/AAAAAAAABWI/v63jg1diBOg/image_thumb%25255B34%25255D.png?imgmax=800" width="628" height="298"></a> </p></blockquote> <p></p> <p></p> <p></p> <p><strong>Step 7: Verify Analytic Model using Analytic Model Viewer.</strong></p> <blockquote> <p>a) Navigate to the Main Menu > PeopleTools > Utilities > Administration > Analytic Model Viewer.</p> <p>b) Search the Analytic Instance “PM_HEADCOUNT_IN” and click on the instance link. <p>c) Select the “PRESENTATIONCUBECOLLECTION” to view the Analytic Model functioning. <p><a href="http://lh6.ggpht.com/-xF9Dwz9lHBM/UZuV1RMtANI/AAAAAAAABWQ/k-K7ZfhuZA8/s1600-h/image%25255B74%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-mRhS5WPR5kg/UZuV2C_09LI/AAAAAAAABWY/EM8RNEXs4Z4/image_thumb%25255B42%25255D.png?imgmax=800" width="632" height="302"></a> <p><a href="http://lh3.ggpht.com/-WNQ9NiRNl3g/UZuV3DkH_TI/AAAAAAAABWg/YKZbMOgyF6Y/s1600-h/image%25255B78%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-YGUpIwtZ6EM/UZuV30Fm3aI/AAAAAAAABWo/g36vtOzv-ug/image_thumb%25255B44%25255D.png?imgmax=800" width="647" height="313"></a> </p></blockquote> <p></p> <p><strong>Step 8: Create a Page with Analytic Grid to associate the Analytic Model to Analytic Grid.</strong></p> <blockquote> <p>a) Create a Page and Place an Analytic Grid control to the Page.</p> <p>b) Add the work record(PM_HDCOUNT_WRK) fields in the Analytic Grid which is as main record in “PRESENTATIONCUBECOLLETION” cube collection.</p> <p><a href="http://lh5.ggpht.com/-DirHC557BNE/UZuV7p4f1LI/AAAAAAAABWw/9wToLJdiwmY/s1600-h/image%25255B86%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-PVnefR7ePJA/UZuV8Pp--EI/AAAAAAAABW4/_2SJotwWIW4/image_thumb%25255B48%25255D.png?imgmax=800" width="569" height="210"></a> </p> <p>c) Set the properties of the Analytic grid as follows. <p><a href="http://lh5.ggpht.com/-tdF8TTWPHTI/UZuV8zEmWpI/AAAAAAAABXA/cOThaVAZfEI/s1600-h/image%25255B93%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-fYWb61jtQsY/UZuV9xSQwnI/AAAAAAAABXI/kuVjKZcLoio/image_thumb%25255B51%25255D.png?imgmax=800" width="628" height="543"></a> <p><strong>d) Analytics Instance in the Grid Properties shown above is the page field placed in the page and this field has the value of Analytic Instance which is created through online (PM_HEADCOUNT_IN). This value(Analytic Instance) is assigned in prebuild event of component. (Create a separate work record with a field to assign analytic instance on this. Analytic instance can be assigned as <Recod>.<Field>.Value = “<ANALYTIC_INSTANCE>” for this example PM_HEADCOUNT_WRK1.DESCR.Value = “PM_HEADCOUNT_IN”).</strong> <p>e) Save Page and Component. (INSTALLATION record can be used as search record to bypass search page). <p>f) Register the component and View the page online and see the Analytic Grid Functioning. <p><a href="http://lh3.ggpht.com/-0sL_XrYm57A/UZuV-ksp0gI/AAAAAAAABXQ/fuyL5H871RY/s1600-h/image%25255B97%25255D.png"><img style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-ny_DfLC47Iw/UZuV_Y4HbwI/AAAAAAAABXY/8nz8wtyi0gY/image_thumb%25255B53%25255D.png?imgmax=800" width="628" height="327"></a> </p></blockquote> <p><strong><font color="#ff8080">Note: Make sure “Analytic Server” is UP and running in “Application Server”.</font></strong> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com4tag:blogger.com,1999:blog-8458073463437959390.post-39077851086851884512013-04-11T02:36:00.001-07:002013-04-24T07:03:20.642-07:00PS Mobile/Tablet SolutionsDelivered:<br />
<ul>
<li>Mobile Company Directory - Doc ID 1494986.1 and 1494952.1</li>
<li>Mobile Approvals - Doc ID 1505021.1</li>
<li>Mobile Expense - Doc ID 1505021.1</li>
<li>Mobile eProcurement </li>
</ul>
Planned Solutions(In Future Releases):<br />
<ul>
<li>Time and Labor</li>
<li>Absence Management</li>
<li>Cash Position Management</li>
<li>HR Self-Service</li>
<li>Dash Boards</li>
</ul>
<ul></ul>
<ul></ul>
<ul></ul>
<ul></ul>
<ul></ul>
<ul></ul>
<ul></ul>
<ul></ul>
<ul></ul>
Some more details documented on document id: 1504427.1<br />
For video features: Document ID: 1362821.1Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-63717847338276619162013-03-30T10:24:00.001-07:002013-03-30T10:38:57.977-07:00One Stop Shop for all useful Queries<div dir="ltr" style="text-align: left;" trbidi="on">
I have created an <b>Excel Tool</b> to collect the Useful Queries in one place, i.e. One Stop Shop for all useful Queries. <br />
Use of this Tool: <br />
1. This can be used for One Stop Shop for all the queries used in Development And Support. <br />
2. This can be used for One Stop Shop for all your personal Queries.. (As local Copy) <br />
Download Link: <a href="https://www.box.com/s/nddblh0co85x94iyfruy">Excel Tool To store all Useful Queries</a><br />
<br />
<br />
<br />
</div>
Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com1tag:blogger.com,1999:blog-8458073463437959390.post-66375126462983804522013-03-05T10:37:00.001-08:002013-03-05T10:37:59.157-08:00PeopleTools 8.53 Improvements<p>Some important improvements got introduced in how customers deploy, scale, and update peoplesoft applications with features like virtualization and the PeopleSoft Update Manager (PUM). <p>Here are some of the major improvements in PeopleTools 8.53 release: <ul> <li>Oracle’s Secure Enterprise Search – Provides secure, free-text search within PeopleSoft applications across multiple objects and multiple applications for a more streamlined search-driven navigation approach. <li>Related Actions – Enables end users to take relevant actions on objects within the context of transactions rather than using lengthy traditional menu paths. <li>Activity Guides – Provides for the deployment of guided business processes, which facilitate a variety of activities from self-service to administration. <li>Pivot Grids – Offers self-service, real-time, multi-dimensional analytics embedded into PeopleSoft applications providing end users with the actionable information needed to make decisions. <li>WorkCenters – Consolidates user tasks, exceptions, alerts, links, reports, and queries into a single, secure, role based “command center” that can be personalized and configured by end users for increased productivity. <li>Cascading Style Sheets (CSS) – Improves use and support of CSS and enables customers to easily configure their PeopleSoft system to reflect organizational branding (e.g. color, graphics, etc.). <li>Oracle Private Cloud Deployments of PeopleSoft – Enables multiple PeopleSoft application instances to be consolidated on Oracle Exalogic, providing high capacity and performance, dynamic scaling and provisioning using Oracle Virtualization. This also dramatically improves system management, patching, and maintenance. All of this reduces total cost of ownership. <li>Secure by Default - As part of Oracle Secure by Default initiative, PeopleTools 8.53 will request passwords for delivered accounts necessary for system initialization and disabling other sample accounts. We will also be delivering a salted SHA-1 hash for PeopleSoft passwords. The salted SHA-1 hash enhancement will not affect upgrades. </li></ul> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com1tag:blogger.com,1999:blog-8458073463437959390.post-79383218376245865112013-01-22T09:02:00.001-08:002013-01-22T09:02:47.158-08:00Minimum RDMS Privileges of the PSADMIN Role<p> </p><pre class="csharpcode">|--------------------+------------------------------------+------------| <br />| | | | <br />| Privilege | Comments | Removable? | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| ALTER SESSION | This is done during some SQR | No | <br />| | processes and is also necessary to | | <br />| | enable SQL tracing during | | <br />| | performance tuning | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| ALTER TABLESPACE | PeopleSoft does not alter the | Yes | <br />| | tablespace itself, this is a job | | <br />| | for the DBA instead. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| ALTER ROLLBACK | The rollback segments should be | Yes | <br />| SEGMENT | completely maintained by the DBA. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE CLUSTER | PeopleTools cannot do this | Yes | <br />| | directly and is therefore not a | | <br />| | function of PeopleSoft, but could | | <br />| | be an option for performance | | <br />| | tuning that the DBA may wish to | | <br />| | take | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE DATABASE | Private database links are used | Yes | <br />| LINK | during the upgrade compare | | <br />| | process. Although, perhaps only | | <br />| | the DBA should be creating | | <br />| | database links. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE PUBLIC | Public database links are not used | Yes | <br />| DATABASE LINK | by PeopleSoft | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE PUBLIC | Public synonyms are created during | No | <br />| SYNONYM | the upgrade compare process | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE SEQUENCE | Sequences are not used by | Yes | <br />| | PeopleSoft | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE SNAPSHOT | PeopleSoft does not use snapshots | Yes | <br />| | by default, but they can be used | | <br />| | to maintain generated tables. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE SESSION | This allows connection to the | No | <br />| | database and is essential | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE SYNONYM | Private synonyms are created for | No | <br />| | PSOPRDEFN and PSLOCK for each user | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE TABLE | Data Designer created tables | No | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE VIEW | Data Designer creates views | No | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE PROCEDURE | Not used directly by PeopleSoft. | Yes | <br />| | Useful in conjunction with | | <br />| | triggers. Before Oracle 7.3 would | | <br />| | be needed in conjunction with | | <br />| | triggers as triggers are not | | <br />| | compiled, whereas packaged | | <br />| | procedures are. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE TRIGGER | PeopleSoft does not use triggers | Yes | <br />| | by default. However this is an | | <br />| | option for additional auditing. | | <br />| | In which case CREATE PROCEDURE | | <br />| | would be an advantage too. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE TABLESPACE | PeopleSoft does not alter the | Yes | <br />| | tablespace itself, this is a job | | <br />| | for the DBA instead. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE USER | A new database user is created | No | <br />| | when a new PeopleSoft user is | | <br />| | created | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| CREATE ROLLBACK | The rollback segments should be | Yes | <br />| SEGMENT | completely maintained by the DBA. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| DROP PUBLIC | Public database links are not used | Yes | <br />| DATABASE LINK | by PeopleSoft | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| DROP PUBLIC | Public synonyms may be dropped | No | <br />| SYNONYM | during the upgrade compare process | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| DROP ROLLBACK | The rollback segments should be | Yes | <br />| SEGMENT | completely maintained by the DBA. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| DROP TABLESPACE | PeopleSoft does not alter the | Yes | <br />| | tablespace itself, this is a job | | <br />| | for the DBA instead. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| DROP USER | A database user is dropped when a | No | <br />| | new PeopleSoft user is removed | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| MANAGE TABLESPACE | This allows tablespaces to be | Yes | <br />| | taken on and off line during a | | <br />| | backup. This is a job for the DBA | | <br />| | instead | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| RESOURCE | This is equivalent to CREATE | Yes | <br />| | CLUSTER, CREATE PROCEDURE, | | <br />| | CREATE_SEQUENCE, CREATE TABLE, and | | <br />| | CREATE TRIGGER that are all dealt | | <br />| | with explicitly elsewhere. It is | | <br />| | used for compatibility with | | <br />| | previous versions of Oracle7. | | <br />| | Thus is privilege is not required | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| EXP_FULL_DATABASE | Full exports could be performed by | Yes | <br />| | the DBA rather than the PeopleSoft | | <br />| | system administrator. This also | | <br />| | implies SELECT ANY TABLE. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| IMP_FULL_DATABASE | Full imports could be performed by | Yes | <br />| | the DBA rather than the PeopleSoft | | <br />| | system administrator This also | | <br />| | implies BECOME USER. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| GRANT ANY ROLE | This privilege is required in | Yes | <br />| | order to grant the PSUSER role to | | <br />| | the new database user when | | <br />| | creating a PeopleSoft user in | | <br />| | Operator Security. However, if | | <br />| | the PSUSER role is granted to | | <br />| | SYSADM with the ADMIN OPTION then | | <br />| | SYSADM can still grant PSUSER and | | <br />| | GRANT ANY ROLE is no longer | | <br />| | required. | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| ALTER USER | This allows the user, amongst | No | <br />| | other things, to change passwords. | | <br />| | It is therefore required | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br />| | | | <br />| BECOME USER | This is required by and implicit | Yes | <br />| | in IMP_FULL_USER, but is not | | <br />| | otherwise required by PeopleTools | | <br />| | | | <br />|--------------------+------------------------------------+------------| <br /></pre><pre class="csharpcode">Source: Oracle Doc ID: 1140413.1</pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com1tag:blogger.com,1999:blog-8458073463437959390.post-91132716370174196382013-01-08T08:55:00.000-08:002013-01-08T09:19:03.003-08:00Org Chart Viewer and Mobile Company Directory<div dir="ltr" style="text-align: left;" trbidi="on">
<iframe allowfullscreen="allowfullscreen" frameborder="0" height="356" marginheight="0" marginwidth="0" mozallowfullscreen="mozallowfullscreen" scrolling="no" src="http://www.slideshare.net/slideshow/embed_code/15906244" style="border-width: 1px 1px 0; border: 1px solid #CCC; margin-bottom: 5px;" webkitallowfullscreen="webkitallowfullscreen" width="427"> </iframe> <br />
<div style="margin-bottom: 5px;">
<b> <a href="http://www.slideshare.net/pawanhiworld/org-chart-viewer-and-mobile-company-directory" target="_blank" title="Org chart viewer and mobile company directory">Org chart viewer and mobile company directory</a> </b> from <b><a href="http://www.slideshare.net/pawanhiworld" target="_blank">Pawan Mundhra</a></b> </div>
</div>
Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-89719757395939152402012-12-19T08:36:00.000-08:002012-12-19T08:36:11.604-08:00PeopleSoft Interaction Hub<div dir="ltr" style="text-align: left;" trbidi="on">
<iframe allowfullscreen="" frameborder="0" height="270" src="http://www.youtube.com/embed/gIZ1WC5-LM0?fs=1" width="480"></iframe></div>
Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com1tag:blogger.com,1999:blog-8458073463437959390.post-71876595336418862322012-10-25T11:20:00.001-07:002012-10-25T11:20:50.889-07:00Steps to Implement Data Archive Manager<p><u>Step1:</u> Create Archive Object <p><a href="http://lh5.ggpht.com/-JMM6xNo_7BY/UImCzaZypHI/AAAAAAAABN0/fRF5wRZrba0/s1600-h/image%25255B3%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-wVjEV3EvkvA/UImC0j_qy7I/AAAAAAAABN4/xDLnBisWfGM/image_thumb%25255B1%25255D.png?imgmax=800" width="591" height="226"></a> <p>Archive Record: Record from data need to archive. <p>Base Record: The record is selected is the base record of this archive object. This is a check box and only one can be base record. <p>History Record: History Record to which transaction data is needed to archive. <p>History Record Structure (Example): <blockquote> <p>1. Save as HR_ACCTG_LINE record to HRACTLN_HST and don’t copy any peoplecode associated with record HR_ACCTG_LINE.</p></blockquote> <blockquote> <p>2. Insert Subrecord PSARCHIVE_SBR at top in the record as shown in below image.</p></blockquote> <p><a href="http://lh4.ggpht.com/-gP8BPquIjVo/UImC1iXcbzI/AAAAAAAABOA/O6nZsGyVahQ/s1600-h/clip_image002%25255B4%25255D.jpg"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="clip_image002" border="0" hspace="12" alt="clip_image002" src="http://lh3.ggpht.com/-G0t2uvYmrkc/UImC2wauykI/AAAAAAAABOI/lJe3nqOjFvw/clip_image002_thumb%25255B1%25255D.jpg?imgmax=800" width="555" height="113"></a></p> <blockquote> <p>3. Build the table.</p></blockquote> <p><u>Step2:</u> Create Archive Query <p><a href="http://lh6.ggpht.com/-5J7BlGq_jME/UImC4SwjIVI/AAAAAAAABOU/GTMdixU8JfE/s1600-h/image%25255B7%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-kt_5auM4Ymg/UImC53WQ5CI/AAAAAAAABOc/2aJGI3Z2uNA/image_thumb%25255B3%25255D.png?imgmax=800" width="614" height="226"></a> <p>Archive Query contain Archive record name and all field selected. <p><b><font color="#ff0000">Criteria: This is required to add criteria which filter the data for archiving.</font></b> <p><u>Step3:</u> Archive Template <p><a href="http://lh6.ggpht.com/-5s-BxSSMN_M/UImC7Z2XqBI/AAAAAAAABOg/5WDNavdP5H8/s1600-h/image%25255B11%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-BVq5s0-lhjY/UImC8vI09QI/AAAAAAAABOo/9d0aEDU1VTM/image_thumb%25255B5%25255D.png?imgmax=800" width="592" height="307"></a> <p><u>Step4:</u> Running Archive Process <p><a href="http://lh5.ggpht.com/-AwZsgiQvKZg/UImC-IGvSTI/AAAAAAAABOw/BYJ6TLOgk6A/s1600-h/image%25255B15%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-jnRMo73qHUU/UImC_i1A0aI/AAAAAAAABO8/AeHOxX6DyDQ/image_thumb%25255B7%25255D.png?imgmax=800" width="602" height="365"></a> <p><b><font color="#ff0000">Process Type:</font></b> <p><font color="#ff0000">1. <b>Selection:</b> Copy data from Archiving Record to History Record.</font> <p><font color="#ff0000"><b>2. </b><b>Delete: </b>Deleting data from Archiving Record.<b></b></font> <p><font color="#ff0000"><b>3. </b><b>Remove from History: </b>Deleting data from History Record.<b></b></font> <p><font color="#ff0000">4. <b>Rollback:</b> Copy data from History Record to Archiving record.</font> <p><font color="#ff0000">Note: Select the process type and run the process.</font></p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com1tag:blogger.com,1999:blog-8458073463437959390.post-28115028485334143132012-09-29T09:04:00.001-07:002012-09-29T09:04:29.707-07:00Absence Management White Papers to Assist with Implementations by Oracle<p>Oracle has recently provided Absence Management White Papers. Below are the documents can be find at Oracle support. You need login for these documents.</p> <p>1. <strong>Absence Management Entitlement and Take Setup:</strong></p> <p><strong>Document ID 1493866.1</strong>: This document (Document ID 1493866.1) provides an overview of how to set up the main components of Absence Management, such as Absence Entitlement and Take elements, as well as other supporting elements relevant to your Absence Management implementation.</p> <p>2. <strong>Absence Management System Elements:</strong></p> <p><strong>Document ID 1493879.1</strong>: This document (Document ID 1493879.1) provides an overview of the system elements related to Absence Management. System elements are building blocks used during the design and construction of your Absence Rules. Knowing how they work and when to use them should help you expedite the implementation of your Absence Policy rules in your company </p> <p>3. <strong>Absence Management Self Service Setup :</strong></p> <p><strong>Document ID 1493867.1</strong>: This document (Document ID 1493867.1) provides an overview and guidance on some of the important areas when setting up Absence Self Service. Throughout this document we are providing examples of different configurations supported in Self Service. </p> <p>Source: Oracle Support centre.</p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-8151453811834467672012-09-27T11:31:00.001-07:002012-09-27T11:31:11.800-07:00External People(non–employee / Applicant) Access for PeopleSoft Pages<p>Below steps helps to give access to components for external people.</p> <p>This is required for many scenarios. Some Examples are: </p> <p>1. Forgot password – Helps employee to retrieve login password.</p> <p>2. External Candidate – Helps to apply job for the company.</p> <p>3. External candidate to register course – Helps external candidates to apply course. etc..</p> <p>Steps to to give access for external people:</p> <p><strong>Step 1:</strong> Create a user id as EXTERNAL and set a password(PS) for it.Assign "External Applicant" & "Recruitment User"(optional) roles to this user-id. Save it.</p> <p><font color="#ff0000">Important : Do not attach any other Role to this user id.</font></p> <p><a href="http://lh3.ggpht.com/-mutPZ5Idqv8/UGSbQGrqskI/AAAAAAAABMU/5EQ_y7y9BG0/s1600-h/image%25255B9%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-aVGlTRtOmkY/UGSbRrRCMbI/AAAAAAAABMc/nE92B8-65O4/image_thumb%25255B11%25255D.png?imgmax=800" width="606" height="217"></a></p> <p>Screens of roles</p> <p><a href="http://lh4.ggpht.com/-fHMHvXav2yA/UGSbTPyj1KI/AAAAAAAABMk/4hlekDC7OgA/s1600-h/image%25255B13%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-bOPP0X41c6k/UGSbUP_ZApI/AAAAAAAABMs/ULh0h-jpl4A/image_thumb%25255B13%25255D.png?imgmax=800" width="612" height="224"></a></p> <p><a href="http://lh6.ggpht.com/-Smpo9_w9AQI/UGSbVOBtMqI/AAAAAAAABM0/aUI7DTxKrdI/s1600-h/image%25255B17%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-84fAU7WEOo4/UGSbWYI21cI/AAAAAAAABM8/c5yLIL5x6Zg/image_thumb%25255B15%25255D.png?imgmax=800" width="606" height="226"></a></p> <p><strong>Step2:</strong> go to PeopleTools --> Webprofile --> Webprofile Configuration.</p> <p>Then choose the profile (E.g. DEV)</p> <p>Navigate to the "Security" tab and check "<strong><u>allow public access</u></strong>" and give the userid "EXTERNAL" and password "PS" and save it.</p> <p><a href="http://lh6.ggpht.com/-hO1fXpFOc7I/UGSbXoyvGPI/AAAAAAAABNE/QEffvn9NbWc/s1600-h/image%25255B21%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-QZrABEerVCs/UGSbY2Wr1kI/AAAAAAAABNM/RxsrSEks2w8/image_thumb%25255B17%25255D.png?imgmax=800" width="614" height="310"></a></p> <p><a href="http://lh5.ggpht.com/-Oc73RMfbJtg/UGSbZ8uVm0I/AAAAAAAABNU/YCVSBE5p09I/s1600-h/image%25255B25%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-lZwTju9b6vE/UGSbbH9cO6I/AAAAAAAABNc/0wrBZm4dlvo/image_thumb%25255B19%25255D.png?imgmax=800" width="537" height="117"></a></p> <p><strong>Step3:</strong> To access page use the below format.</p> <p><strong>"http://Your IP:Port/psc/ps/EMPLOYEE/HRMS/c/ComponentName.Market"</strong></p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com4tag:blogger.com,1999:blog-8458073463437959390.post-71754036020307057422012-09-16T06:25:00.001-07:002012-09-16T06:25:28.801-07:00In Scroll Area, Clicking from "View All" to "View 1" Creates Empty Space<p>Problem Description:</p> <p>In some scroll areas, when clicking from "View All" to "View 1" link, the page doesn't remove the extra space that was used from "View All" mode.</p> <p>Solution:</p> <p>For PeopleTools 8.50: This bug has been fixed on Patch 8.50.03 and higher.</p> <p>For PeopleTools 8.52: This bug has been fixed on Patch 8.52.10 and higher. In normal case, we have tested for this issue on patch 10 and its working good for View all and View 1 action but some scenarios this is broken. </p> <p> </p> <p>Reference document from oracle support: [Doc ID 1062053.1]</p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-44860634370241095122012-08-25T13:07:00.001-07:002012-08-25T13:07:34.040-07:00Release Value Proposition: PeopleTools 8.53 feature analysis<p>Oracle has planned to enhance/add below features in PeopleTools 8.53.</p> <p>1. User Interface<br>2. PeopleSoft Search Framework<br>3. Lifecycle Management<br>4. Server Administration and Infrastructure<br>5. Security Administration<br>6. Integration Technology<br>7. Reporting and Analysis Tools<br>8. Development Tools</p> <p align="center"><strong><u>1. User Interface</u></strong></p> <p><strong>a) Dramatic New Look and Feel:</strong> New style sheet for good look and feel. These changes also lay the groundwork for future user interface changes.</p> <p><strong>b) Related Actions/Related Content: </strong>PeopleTools 8.53 brings Related Actions to Pivot Grids, allowing users to take actions directly on data displayed in a pivot grid.</p> <p> A new Related Actions widget can be used to display the Related Actions menu. This feature eliminates the need for a developer to write code for displaying the optional menu and for defining HTML areas on pages to display Related Actions.</p> <p> Related Services can be configured in groups, which make it simpler to configure the same services that appear in multiple places.</p> <p><strong>c) WorkCentres and Dashboards:</strong> Application developers and designers can deploy dashboard-like pagelets within WorkCenters to provide better decision support for WorkCenter transactions. This capability combines some of the features and benefits of Dashboards with WorkCenters.</p> <p> Applications can now consume remote pagelets in WorkCenters, Homepages, and Dashboards.</p> <p><strong>d) Activity Guide:</strong> In 8.53, the Activity Guide enables application developers to define a list of action items tied to transactional, collaborative, or manual tasks. The action item represents a task that can be tracked for assignment and completion, and is secured by roles and user lists. Activity Guides also enable a hierarchical list of action items.</p> <p> A new Activity Guide WorkCenter template is available for use with building and configuring Activity Guides. This template provides a frame with the navigation controls used to traverse an Activity Guide. The WorkCenter template also provides the following features:</p> <ul> <ul> <li>A status bar to indicate the progress of the Activity Guide, and the Active Action item is highlighted. <li>Ability to do pre-processing and post-processing for an action item. <li>Ability to assign an action item to a role or a user. <li>Ability to create dependency rules for action items.</li></ul></ul> <p align="center"><strong><u>2. PeopleSoft Search Framework</u></strong></p> <p align="left">PeopleSoft Application Search framework features include:</p> <ul> <ul> <li> <div align="left">A search experience that functions similarly to the internet, providing a look and feel that users will find both familiar and intuitive.</div> <li> <div align="left">An Application Search that is available at any point in an application and can be configured to span multiple PeopleSoft applications. It enables users to initiate transactions or navigate to key information without using the PeopleSoft application menu or returning to the homepage to do so.</div> <li> <div align="left">The ability to use filters and facets to narrow result sets, further enabling users to identify and navigate to specific application content.</div> <li> <div align="left">Search results that display in prioritized order by relevance based on the provided search terms.</div> <li> <div align="left">Related Action menus that are embedded directly in the search results, allowing users to navigate straight to specific related transactions, which are prepopulated with the selected search results data.</div> <li> <div align="left">A Component Search function that enables users to search by keyword, thereby extending the versatility of virtually all existing search pages.</div></li></ul></ul> <p>Key PeopleSoft Search Framework Enhancements:</p> <ul> <ul> <li>Performance <li>New source types <li>Oracle SES instance sharing <li>Multiple FTP credential support <li>Monitoring and diagnostics <li>Duplicate search results <li>Increased operator support</li></ul></ul> <p align="center"><strong><u>3. Lifecycle Management</u></strong></p> <p><strong>a) PeopleSoft Update Manager</strong></p> <p><strong>b) Configuration Management with the Data Migration Workbench(A brand new tool):</strong> The Data Migration Workbench is a new tool that helps users manage the process of moving configuration data from one system to another.</p> <p><strong>c) PeopleSoft Test Framework: </strong>Enhanced to support a number of new PeopleTools features and capabilities.</p> <p><strong>d) Three-Way Merge Support</strong></p> <p align="center"><strong><u>4. Server Administration and Infrastructure</u></strong></p> <p align="left">a) Platform Components</p> <p align="left">b) Extending 64-bit Support to the Windows Server Platform: The application server uses 64-bit binaries on the Windows Server platform. The 32-bit Windows code for the application server will no longer be available.</p> <p align="left">c) A New Home for Customizations - PS_CUST_HOME : This change is optional; customers may continue to use a traditional PS_HOME if desired.</p> <p align="left">d) PeopleSoft Application Management Pack for Oracle Enterprise Manager 12c</p> <p align="left">e) Offload PS/nVision Workloads with Active Data Guard and Golden Gate</p> <p align="left">f) Support for Firefox Extended Support Releases: Firefox 17 is the anticipated minimum ESR to be certified with PeopleTools 8.53.</p> <p align="center"><strong><u>5. Security Administration</u></strong></p> <p align="left">a) Secure by Default Initiative: </p> <ul> <ul> <li> <div align="left">Deliver all UserIDs with a password that must be set during Installation. </div> <li> <div align="left">Salt-enabled user Passwords.</div></li></ul></ul> <p align="center"><strong><u>6. Integration Technology</u></strong></p> <p align="left">a) JavaScript Object Notation (JSON) from Documents</p> <p align="left">b) REST Web Services</p> <p align="left">c) Integration Network Enhancements</p> <ul> <ul> <li> <div align="left">Automated Network Status and Real-Time Notification of Errors</div> <li> <div align="left">Improved Life Cycle Utilities</div> <li> <div align="left">Bulk Update of Permission for Service Operations</div></li></ul></ul> <p align="center"><strong><u>7. Reporting and Analysis Tools</u></strong></p> <p align="left"><strong>a) Reporting Console Enhancements:</strong></p> <ul> <ul> <li> <div align="left">Drag-and-drop of folders and Process Bookmark as a sibling.</div> <li> <div align="left">Drag-and-drop of folders and Process Bookmark as a child of an existing folder.</div> <li> <div align="left">Rename of folders.</div> <li> <div align="left">Import folders and Process Bookmark of existing user.</div> <li> <div align="left">Dynamic Context Menu option on folder and Process Bookmark row for add, edit, rename, delete options.</div></li></ul></ul> <p align="left"><strong>b) New My Reports Pagelet:</strong></p> <ul> <ul> <li> <div align="left">Display list of different systems/databases containing the reports and providing functionality for filtering reports based on a particular database.</div> <li> <div align="left">Opening of the actual report directly instead of a page to display a list of files.</div> <li> <div align="left">Grouping of multiple instances of the same report.</div></li></ul></ul> <p align="left"><strong>c) Chart Enhancements: </strong>PeopleTools 8.53 introduces a number of Chart Enhancements, including making use HTML, CSS3, and JavaScript instead of the server-based chart engine. The new charts incorporate improvements in scrolling and display and more closely match the overall PeopleTools look and feel.</p> <p align="left"><strong>d) Pivot Grid Enhancements:</strong></p> <ul> <ul> <li> <div align="left">Multi Select Filters that provide the ability to filter data on multiple values instead of a single value.</div> <li> <div align="left">Progressive Filtering that shows only valid values for the current filter selection when a filter value is modified.</div> <li> <div align="left">Dynamic passing of prompt values into the Pivot Grid being displayed in a Related Content frame or in Related Actions.</div> <li> <div align="left">Chart-only view allows users to change layout using grid.</div> <li> <div align="left">Enabling of Pivot Grid pagelets to interact with each other and with transaction pages. Prompt and filter value changes can be published and subscribed to in real-time.</div> <li> <div align="left">Enhancements to the user interface.</div> <li> <div align="left">Pivot Grid Administration Component provides module to clone and delete Pivot Grid Models and personalization.</div> <li> <div align="left">Enhancements to the Pivot Grid Wizard.</div></li></ul></ul> <p align="center"><strong><u>8. Development Tools</u></strong></p> <p align="left">PeopleTools 8.53 introduces a new feature in Application Designer that allows developers to define the field label alignment for new or modified pages. A configuration property can be set that defines whether new field labels should be right or left aligned. This feature greatly streamlines the otherwise manual process of field label alignment. Once a field is placed on a page, the developer retains the ability to change the label alignment where necessary.</p> <p align="left"> </p> <p align="left"><strong><u>Key PeopleTools 8.53 features Executive Summary:</u></strong></p> <p align="left">PeopleSoft Styles and User Interaction Model </p> <ul> <ul> <ul> <li>New styles for a contemporary appearance. <li>More flexibility in WorkCenters and Dashboards. <li>Improvements to the Related Content Framework, Related Actions, and Activity Guides. </li></ul></ul></ul> <p>PeopleSoft Data Migration Workbench </p> <p>PeopleSoft Update Manager (NEW) </p> <ul> <ul> <ul> <li> <p>The customer does not have to be current on maintenance.</p> <li> <p>The customer can select a single fix and find out if requisite fixes are available that must be applied with it.</p> <li> <p>Dependencies are calculated by area of system affected rather than time, so fewer dependencies are required.</p></li></ul></ul></ul> <p>PeopleSoft Secure by Default Initiative </p> <ul> <ul> <ul> <li> <p>Safeguards for ensuring that passwords for default user accounts are set during installation.</p> <li> <p>Additional mitigation for brute force and denial-of-service attempts.</p> <li> <p>Additional security for file attachments and the Report Repository.</p></li></ul></ul></ul> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-68643430783564665512012-08-13T11:00:00.001-07:002012-08-13T11:00:08.125-07:00Round Pie Chart Slice Labels<p>Slice the labels of pie chart to required(example 1) decimal place.</p><pre class="csharpcode"><SliceLabel><br /><br /><ViewFormat decimalDigit=<span class="str">"1"</span> decimalSeparator=<span class="str">"."</span> decimalDigitUsed=<span class="str">"true"</span> decimalSeparatorUsed=<span class="str">"true"</span> /><br /><br /></SliceLabel></pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-8470902968543471112012-08-02T10:36:00.001-07:002012-08-02T10:36:52.525-07:00Related content link in Dropdown<p>As shown in Image to create related content link in Dropdown we need to follow below steps.</p> <p><a href="http://lh5.ggpht.com/-OEoKTPGm0-Q/UBq6nfxRHWI/AAAAAAAABJo/MsBP4PvRUiU/s1600-h/image001%25255B3%25255D.jpg"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image001" border="0" alt="image001" src="http://lh4.ggpht.com/-45qfYBSV0_Y/UBq6oMlZ28I/AAAAAAAABJw/EuM0FqpU3FA/image001_thumb%25255B1%25255D.jpg?imgmax=800" width="533" height="102"></a></p> <p><strong>Assumption:</strong> Component is created and Related content setup is done.</p> <p>Below steps need to be done to use Related content in drop down.</p> <p><strong>Step1: Adding HTML Area to page.</strong></p> <p>Place a HTML area in the page to the created component. <p><a href="http://lh3.ggpht.com/-PKhLnoOuj-c/UBq6otaeaeI/AAAAAAAABJ4/lA2GeCOVqVA/s1600-h/1%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="1" border="0" alt="1" src="http://lh4.ggpht.com/-xF034Q7D7nY/UBq6pIJRNSI/AAAAAAAABKA/m7fI600Hkyw/1_thumb%25255B7%25255D.png?imgmax=800" width="622" height="228"></a> <p>Here “N_RELATED_ACTNS” is a custom Long char field. <p><font style="background-color: #ffff00">In General Tab provide “RELATEDACTIONS” as page field name as shown in the image</font> <p><a href="http://lh3.ggpht.com/-Iqt5LtnwL1c/UBq6puNWVlI/AAAAAAAABKI/wQEsfYFdvxc/s1600-h/2%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="2" border="0" alt="2" src="http://lh5.ggpht.com/-1U9JiNFUHvU/UBq6qWStnmI/AAAAAAAABKQ/BK7jWuBMn6Y/2_thumb%25255B1%25255D.png?imgmax=800" width="599" height="169"></a> <p><strong>Step 2: Hiding the Related Action Page field and making it modified by JavaScript.</strong> <p>Here People ID is the Related action Field defied in Related action setup page. <p><a href="http://lh5.ggpht.com/-uqGBDpaYjxc/UBq6q-XPYHI/AAAAAAAABKY/Fk-aVfjeEVg/s1600-h/image%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-yPDTqINP77s/UBq6rvFR4QI/AAAAAAAABKg/4FdLpvC-IdE/image_thumb%25255B1%25255D.png?imgmax=800" width="628" height="260"></a> <p>Make this field is hidden and set the page field property as below Image. <p><font style="background-color: #ffff00">Note: Modified by JavaScript should be enabled.</font> <p><a href="http://lh5.ggpht.com/-bxtu3CXmlFg/UBq6sCpWXrI/AAAAAAAABKo/-neV-ASfVvM/s1600-h/image%25255B7%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-nqYZWxUvbyQ/UBq6szCZbCI/AAAAAAAABKw/SrcuVALhbSQ/image_thumb%25255B3%25255D.png?imgmax=800" width="628" height="229"></a> <p><strong>Step 3: Code to set Related action to HTML area.</strong><pre class="csharpcode"><span class="rem">/*****************Start - Related Actions*************************/</span><br />For &i = 1 To &rs_var.ActiveRowCount<br /> &sActionShortLabel = &rs_var(&i).N_HR_EE_DB_WRK.N_RELATED_ACTNS.GetShortLabel(<span class="str">"RELATED_ACTION"</span>);<br /> &sPopUpMenuJavaScript = GetHTMLText(HTML.N_GET_POPUPMENU);<br /> &rs_var(&i).N_HR_EE_DB_WRK.N_RELATED_ACTNS.Value = &sPopUpMenuJavaScript | GetHTMLText(HTML.N_REL_ACTIONS, <font style="background-color: #ffff00" color="#ff0000">String(&i - 1)</font>, <span class="str">"N_PEOPLE_ID_DR"</span>, <span class="str">"%Image(PT_BTN_ARROW)"</span>, &rs_var(&i).N_MSSACTION_EMP.N_PEOPLE_ID.Value, &rs_var(&i).N_MSSACTION_EMP.N_PEOPLE_ID.Value);<br /> <br />End-For;<br /><span class="rem">/*****************End - Related Actions*************************/</span><br /></pre><br /><p><strong><u>Note:</u></strong> “ <b><font color="#ff0000">String(&i - 1)</font>” is required if this is used in grid/scroll else this can be eliminated.</b> <br /><p><b>Custom HTML object Definitions used in above code:</b> <br /><p><b>1. N_GET_POPUPMENU - (Object Type is HTML</b><b>)</b> <br /><blockquote><pre class="csharpcode"><script language=<span class="str">"JavaScript"</span>><br /><span class="kwrd">function</span> ShowPopUpMenu(sFieldName,nRow, sActionFieldName)<br />{<br /> CreateContextMenu(sFieldName,nRow, 3,<span class="str">""</span>, 0, 0,<span class="str">""</span>,<span class="str">"%FormName"</span>,sActionFieldName);<br /> <span class="kwrd">return</span> ;<br />}<br /></script></pre></blockquote><pre class="csharpcode"> </pre><pre class="csharpcode"><font face="Arial"><strong>2.</strong> <b>N_GET_POPUPMENU - (Object Type is HTML</b><b>)</b></font></pre><br /><blockquote><pre class="csharpcode"><a id=<span class="str">"relatedActionsRow$%BIND(:1)"</span> <span class="kwrd">class</span>=<span class="str">"PSHYPERLINKNOUL"</span> href=<span class="str">"javascript:ShowPopUpMenu('%BIND(:2)','%BIND(:1)','relatedActionsRow$%BIND(:1)');"</span> title=<span class="str">"%BIND(:5)"</span> ac=<span class="str">"1"</span> <span class="kwrd">class</span>=<span class="str">"PTSESRSLTRLTDINFO"</span>><br /><br /><img border=<span class="str">"0"</span> src=<span class="str">"%BIND(:3)"</span> style=<span class="str">"width: 12px; height: 8px; cursor: pointer; vertical-align:middle: text-bottom;"</span> ac=<span class="str">"1"</span> noc=<span class="str">"1"</span>>%BIND(:4)</a></pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style><br /></blockquote><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style><br /><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-51926705552642604392012-07-23T08:22:00.001-07:002012-07-23T08:22:41.472-07:00Analysing “PSQRYCRITERIA” Table<p> </p> <p>CONDTYPE and EXPRTYPE stores below code in PSQRYCRITERIA Table.</p> <table border="1" cellspacing="0" cellpadding="0"> <tbody> <tr> <td valign="top" width="250"> <p><b>Field: Condition Type (<font color="#ff0000">CONDTYPE</font>)</b></p></td></tr> <tr> <td valign="top" width="92"> <p align="center">Code</p></td> <td valign="top" width="217"> <p align="center">Description</p></td> <td valign="top" width="170"> <p align="center">Return Code</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">2</p></td> <td valign="top" width="217"> <p align="center">equal to</p></td> <td valign="top" width="170"> <p align="center">EQU</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">3</p></td> <td valign="top" width="217"> <p align="center">not equal to</p></td> <td valign="top" width="170"> <p align="center">EQU-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">4</p></td> <td valign="top" width="217"> <p align="center">greater than</p></td> <td valign="top" width="170"> <p align="center">GRE</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">5</p></td> <td valign="top" width="217"> <p align="center">not greater than</p></td> <td valign="top" width="170"> <p align="center">GRE-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">6</p></td> <td valign="top" width="217"> <p align="center">less than</p></td> <td valign="top" width="170"> <p align="center">LES</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">7</p></td> <td valign="top" width="217"> <p align="center">not less than</p></td> <td valign="top" width="170"> <p align="center">LES-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">8</p></td> <td valign="top" width="217"> <p align="center">in list</p></td> <td valign="top" width="170"> <p align="center">LIS</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">9</p></td> <td valign="top" width="217"> <p align="center">not in list</p></td> <td valign="top" width="170"> <p align="center">LIS-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">10</p></td> <td valign="top" width="217"> <p align="center">Between</p></td> <td valign="top" width="170"> <p align="center">BET</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">11</p></td> <td valign="top" width="217"> <p align="center">not between</p></td> <td valign="top" width="170"> <p align="center">BET-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">12</p></td> <td valign="top" width="217"> <p align="center">Exists</p></td> <td valign="top" width="170"> <p align="center">EXI</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">13</p></td> <td valign="top" width="217"> <p align="center">does not exist</p></td> <td valign="top" width="170"> <p align="center">EXI-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">14</p></td> <td valign="top" width="217"> <p align="center">Like</p></td> <td valign="top" width="170"> <p align="center">LIK</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">15</p></td> <td valign="top" width="217"> <p align="center">not like</p></td> <td valign="top" width="170"> <p align="center">LIK-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">16</p></td> <td valign="top" width="217"> <p align="center">is null</p></td> <td valign="top" width="170"> <p align="center">NUL</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">17</p></td> <td valign="top" width="217"> <p align="center">is not null</p></td> <td valign="top" width="170"> <p align="center">NUL-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">18</p></td> <td valign="top" width="217"> <p align="center">in tree</p></td> <td valign="top" width="170"> <p align="center">TRE</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">19</p></td> <td valign="top" width="217"> <p align="center">not in tree</p></td> <td valign="top" width="170"> <p align="center">TRE-</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">20</p></td> <td valign="top" width="217"> <p align="center">eff dt <=</p></td> <td valign="top" width="170"> <p align="center">EDLE</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">21</p></td> <td valign="top" width="217"> <p align="center">eff dt >=</p></td> <td valign="top" width="170"> <p align="center">EDGE</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">22</p></td> <td valign="top" width="217"> <p align="center">eff dt <</p></td> <td valign="top" width="170"> <p align="center">EDLT</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">23</p></td> <td valign="top" width="217"> <p align="center">eff dt ></p></td> <td valign="top" width="170"> <p align="center">EDGT</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">24</p></td> <td valign="top" width="217"> <p align="center">first eff dt</p></td> <td valign="top" width="170"> <p align="center">EDFS</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">25</p></td> <td valign="top" width="217"> <p align="center">last eff dt</p></td> <td valign="top" width="170"> <p align="center">EDLS</p></td></tr></tbody></table> <p> </p> <table border="1" cellspacing="0" cellpadding="0"> <tbody> <tr> <td valign="top" width="250"> <p><b>Field: Expression Type (<font color="#ff0000">EXPRTYPE</font>)</b></p></td></tr> <tr> <td valign="top" width="92"> <p align="center">Code</p></td> <td valign="top" width="217"> <p align="center">Description</p></td> <td valign="top" width="170"> <p align="center">Return Code</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">0</p></td> <td valign="top" width="217"> <p align="center">effective sequence</p></td> <td valign="top" width="170"> <p align="center">ES</p></td></tr> <tr> <td valign="top" width="92"> <p align="center"><b><font style="background-color: #ffff00">1</font></b></p></td> <td valign="top" width="217"> <p align="center"><b><font style="background-color: #ffff00">constant</font></b></p></td> <td valign="top" width="170"> <p align="center"><b><font style="background-color: #ffff00">CN</font></b></p></td></tr> <tr> <td valign="top" width="92"> <p align="center">2</p></td> <td valign="top" width="217"> <p align="center">field</p></td> <td valign="top" width="170"> <p align="center">FD</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">3</p></td> <td valign="top" width="217"> <p align="center">Expression</p></td> <td valign="top" width="170"> <p align="center">EX</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">4</p></td> <td valign="top" width="217"> <p align="center">Subquery</p></td> <td valign="top" width="170"> <p align="center">SQ</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">5</p></td> <td valign="top" width="217"> <p align="center">list</p></td> <td valign="top" width="170"> <p align="center">LS</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">6</p></td> <td valign="top" width="217"> <p align="center">current date</p></td> <td valign="top" width="170"> <p align="center">CD</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">7</p></td> <td valign="top" width="217"> <p align="center">tree</p></td> <td valign="top" width="170"> <p align="center">TR</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">8</p></td> <td valign="top" width="217"> <p align="center">Prompt</p></td> <td valign="top" width="170"> <p align="center">PR</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">9</p></td> <td valign="top" width="217"> <p align="center">between const-const</p></td> <td valign="top" width="170"> <p align="center">CC</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">10</p></td> <td valign="top" width="217"> <p align="center">between const-field</p></td> <td valign="top" width="170"> <p align="center">CF</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">11</p></td> <td valign="top" width="217"> <p align="center">between const-expr</p></td> <td valign="top" width="170"> <p align="center">CE</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">12</p></td> <td valign="top" width="217"> <p align="center">between field-const</p></td> <td valign="top" width="170"> <p align="center">FC</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">13</p></td> <td valign="top" width="217"> <p align="center">between field-field</p></td> <td valign="top" width="170"> <p align="center">FF</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">14</p></td> <td valign="top" width="217"> <p align="center">between field-expr</p></td> <td valign="top" width="170"> <p align="center">FE</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">15</p></td> <td valign="top" width="217"> <p align="center">between expr-const</p></td> <td valign="top" width="170"> <p align="center">EC</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">16</p></td> <td valign="top" width="217"> <p align="center">between expr-field</p></td> <td valign="top" width="170"> <p align="center">EF</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">17</p></td> <td valign="top" width="217"> <p align="center">between expr-expr</p></td> <td valign="top" width="170"> <p align="center">EE</p></td></tr> <tr> <td valign="top" width="92"> <p align="center">18</p></td> <td valign="top" width="217"> <p align="center">Tree prompt</p></td> <td valign="top" width="170"> <p align="center">TP</p></td></tr></tbody></table> <p>Detailed Information: <p>Record Field Name: QRYFUNCTIONS - QRYTRANSFUNCS</p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com2tag:blogger.com,1999:blog-8458073463437959390.post-76009310514462782032012-07-22T05:05:00.001-07:002012-07-22T05:06:04.047-07:00PeopleTools iPad Certification<div dir="ltr" style="text-align: left;" trbidi="on">
<iframe allowfullscreen="" frameborder="0" height="270" src="http://www.youtube.com/embed/RauGtEBmnjA?fs=1" width="480"></iframe></div>Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-91553815978684670722012-07-06T03:33:00.001-07:002012-07-06T03:33:33.762-07:00Error on Javascript in PeopleTools 8.52: "hAction_win0 is not defined"Below code may not work from PeopleTools 8.52. But this will work on below version of tools release (i.e. 8.50, 8.51). <pre class="csharpcode">hAction_win0(document.win0,pageFldName,0,0,inlabel,<span class="kwrd">false</span>,<span class="kwrd">true</span>); </pre><br /><p><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style><br /><strong>Reason: </strong></p><br /><p>"hAction_win0" is no longer used in PeopleTools 8.52. </p><br /><p><strong>Solution: </strong></p><br /><p>"<strong><font color="#ff0000">hAction_win0</font></strong>" can be replaced with "<strong><font color="#008000">submitAction_win0</font></strong>" for 8.52 PeopleTools. </p><br /><p><strong>Sample code: </strong></p><pre class="csharpcode">submitAction_win0(document.%FormName,pageFldName,0,0,inlabel,<span class="kwrd">false</span>,<span class="kwrd">true</span>); </pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com13tag:blogger.com,1999:blog-8458073463437959390.post-71710219288040856922012-06-22T04:36:00.001-07:002012-06-22T04:36:57.340-07:00Rowset FILL Method with JOIN / UNION Keyword<p>FILL method helps to fill stand alone rowset from database directly.</p> <p>But sometimes it is required to fill rowset Using JOIN / UNION Keyword.</p> <p>1. Using JOIN Keyword.</p><pre class="csharpcode">Local Rowset &rs = Createrowset(Record.TL_RPTD_TIME);<br /><br />&rs.Fill(<span class="str">"INNER JOIN PS_TL_RPTD_TIME TM ON TM.EMPLID = FILL.EMPLID WHERE FILL.PUNCH_TYPE = '0' AND FILL.EMPLID = :1"</span>, &emplid);</pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style><br /><br /><p>2. Using UNION Keyword.</p><pre class="csharpcode">Local Rowset &rs = Createrowset(Record.PERSON);<br /><br />&rs.Fill(<span class="str">"WHERE 1=0 UNION SELECT EMPLID, %DateOut(BIRTHDATE),BIRTHPLACE,BIRTHCOUNTRY,BIRTHSTATE,%DateOut(DT_OF_DEATH),%DateTimeOut(LAST_CHILD_UPDDTM) FROM PS_PERSON WHERE EMPLID = :1"</span>, &emplid);</pre><br /><p><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style></p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com1tag:blogger.com,1999:blog-8458073463437959390.post-68782394392868600122012-06-05T10:57:00.001-07:002012-06-05T10:59:11.998-07:00Configuring Report Manager<p> </p> <p>Steps to configure and get Reports in Report manager. <p>1. Enable getting Reports in Report Manager. <p>2. Add New Folders. <p>3. Get new files to Process Monitor. <p>4. Assign/Create required Permission Lists/Roles to Users. <p>5. Configure the process. <p>6. Create a new run control id. <p>7. Run it. <p>8. Verify it. <p> <p>For any reports to be visible to other people in Report Manager we need to do the following: <p>1. Activate the following Service Operations <p><a href="http://lh3.ggpht.com/-gTnGT0HbwI8/T85Hx1c9i9I/AAAAAAAABDc/7aItndkf1vA/s1600-h/pic1%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic1" border="0" alt="pic1" src="http://lh6.ggpht.com/-dKqGj0_brYk/T85H09xcO2I/AAAAAAAABDk/CcEtKQZ9IEI/pic1_thumb%25255B2%25255D.png?imgmax=800" width="610" height="334"></a> <ul> <li>· Check Active (in Default Service Operation Version)</li></ul> <p><a href="http://lh4.ggpht.com/-L88IkqXjmok/T85H30GSi6I/AAAAAAAABDs/o2T27lNGKIE/s1600-h/pic2%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic2" border="0" alt="pic2" src="http://lh6.ggpht.com/-QIeVLxYF78I/T85H4kRtOSI/AAAAAAAABD0/1xWwOoLK3Bo/pic2_thumb%25255B2%25255D.png?imgmax=800" width="621" height="595"></a></p> <p>2. To Add New Folders, add them here. This is just to group by folders and has no security tied to it.</p> <p><a href="http://lh4.ggpht.com/-X9M791JkH3g/T85H5gZvciI/AAAAAAAABD8/kL-2fmvgOpw/s1600-h/pic3%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic3" border="0" alt="pic3" src="http://lh6.ggpht.com/-8NHZpeQ7g5k/T85H7zsc0LI/AAAAAAAABEA/rGcFflNERUE/pic3_thumb%25255B2%25255D.png?imgmax=800" width="621" height="258"></a></p> <ul> <li> Verify they come up</li></ul> <p><a href="http://lh3.ggpht.com/--gMgqMfJu58/T85H8iSuZlI/AAAAAAAABEM/wGeeGCm2EmM/s1600-h/pic4%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic4" border="0" alt="pic4" src="http://lh6.ggpht.com/-L9TEBhi9Ov4/T85H9lJ18_I/AAAAAAAABEU/G-_rJY_LwIk/pic4_thumb%25255B2%25255D.png?imgmax=800" width="616" height="215"></a></p> <p>3. To get new files to Process Monitor</p> <p>· Add PRL in System Settings –> Distribution File Options –> Add PRL & Description <p><a href="http://lh3.ggpht.com/-A1I21EMRc3I/T85IAUkL_NI/AAAAAAAABEc/M9HEaPTF0V0/s1600-h/pic5%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic5" border="0" alt="pic5" src="http://lh3.ggpht.com/-fcz_85SWVUk/T85IBfjzYRI/AAAAAAAABEk/osiwVCQneRc/pic5_thumb%25255B2%25255D.png?imgmax=800" width="615" height="215"></a> <ul> <li>Bounce the Process Scheduler <li>After running the report verify that the file is pulled up</li></ul> <p><a href="http://lh3.ggpht.com/-QgQL5UXVNz4/T85IC8DhIhI/AAAAAAAABEs/635SqMZgjGA/s1600-h/pic6%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic6" border="0" alt="pic6" src="http://lh4.ggpht.com/-DzFYkyfbDE4/T85IEHkZZVI/AAAAAAAABE0/W5KEXys8QXE/pic6_thumb%25255B2%25255D.png?imgmax=800" width="618" height="406"></a></p> <p>4. Create new permission list</p> <p><a href="http://lh5.ggpht.com/-kBGNDC2YCeA/T85IExFPBhI/AAAAAAAABE8/UfX54nDnZEg/s1600-h/pic7%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic7" border="0" alt="pic7" src="http://lh6.ggpht.com/-SoHeJ2uBF7Q/T85IGNIv_RI/AAAAAAAABFE/ey40sXtQC2g/pic7_thumb%25255B1%25255D.png?imgmax=800" width="611" height="255"></a></p> <ul> <li>Add Report Manager access and Report Viewer access.</li></ul> <p><a href="http://lh6.ggpht.com/-Fwq02PUpOG8/T85IG3CkkmI/AAAAAAAABFI/Nquv9RHGG0M/s1600-h/pic8%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic8" border="0" alt="pic8" src="http://lh6.ggpht.com/-p-h6BbA0KXQ/T85IH1ygJTI/AAAAAAAABFU/ipA-X6_tMvw/pic8_thumb%25255B2%25255D.png?imgmax=800" width="612" height="271"></a></p> <ul> <li>·Click Select All to give the Report Viewer Page access.</li></ul> <p><a href="http://lh3.ggpht.com/-AoA6Lc9jrgY/T85II5f5RoI/AAAAAAAABFY/mBkSe59LBIY/s1600-h/pic9%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic9" border="0" alt="pic9" src="http://lh3.ggpht.com/-DqPyV4vochw/T85IJwiBhmI/AAAAAAAABFk/bOiNFPOQpwI/pic9_thumb%25255B2%25255D.png?imgmax=800" width="613" height="271"></a></p> <ul> <li>Add other Reports access. This gives the option to run the reports. If the users don’t want/need to run the reports this may be skipped.</li></ul> <p><a href="http://lh3.ggpht.com/-crEZe200e7g/T85IK-phrkI/AAAAAAAABFo/amVoL8KuUO8/s1600-h/pic10%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic10" border="0" alt="pic10" src="http://lh5.ggpht.com/-vEkqrnwS62U/T85ILj64UXI/AAAAAAAABF0/2_ACcBRtASQ/pic10_thumb%25255B2%25255D.png?imgmax=800" width="610" height="271"></a></p> <p>5. Add new Role</p> <p><a href="http://lh3.ggpht.com/--cKpFawZ-GU/T85IOJ1cZhI/AAAAAAAABF4/6PSmKjCv5Aw/s1600-h/pic11%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic11" border="0" alt="pic11" src="http://lh3.ggpht.com/-xKPqHET2dms/T85IOyCxX6I/AAAAAAAABGE/GP6DRrGxc1Y/pic11_thumb%25255B1%25255D.png?imgmax=800" width="636" height="168"></a></p> <ul> <li>Add this role to users</li></ul> <p><a href="http://lh4.ggpht.com/-24qqBQz86U4/T85IQNedRJI/AAAAAAAABGI/TrWVhEXZ2Vg/s1600-h/pic12%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic12" border="0" alt="pic12" src="http://lh4.ggpht.com/-rr_xUDeM0WM/T85IREaBqyI/AAAAAAAABGU/NSsKyeTgims/pic12_thumb%25255B2%25255D.png?imgmax=800" width="618" height="221"></a></p> <ul> <li>Verify required users got the Role</li></ul> <p><a href="http://lh5.ggpht.com/-icaDSIXD_y8/T85IR_vjyDI/AAAAAAAABGY/ebObN-QtNEE/s1600-h/pic13%25255B9%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic13" border="0" alt="pic13" src="http://lh6.ggpht.com/-_JStElwpppA/T85ISxDI1OI/AAAAAAAABGk/P-Fx2Zh62V0/pic13_thumb%25255B5%25255D.png?imgmax=800" width="617" height="306"></a></p> <p>6. Change the Process Destination, set the Destination Source, Folder Name and Distribute To.</p> <p><a href="http://lh6.ggpht.com/-lALIQ8sJAEg/T85ITu5RbbI/AAAAAAAABGs/OANWXyF8ppA/s1600-h/pic14%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic14" border="0" alt="pic14" src="http://lh4.ggpht.com/-Eqbe7FswhpM/T85IWEzltOI/AAAAAAAABG0/3TBntrQww-A/pic14_thumb%25255B2%25255D.png?imgmax=800" width="619" height="316"></a></p> <p>7. Run the process</p> <ul> <li>Create a new run control id</li></ul> <p><a href="http://lh3.ggpht.com/-hVfUxloku_E/T85IXzPVucI/AAAAAAAABG8/hSqjZtq0JZ0/s1600-h/pic15%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic15" border="0" alt="pic15" src="http://lh5.ggpht.com/-nf7mHbYE2kI/T85IY3ln0KI/AAAAAAAABHA/s9ZCD-AYHIo/pic15_thumb%25255B1%25255D.png?imgmax=800" width="636" height="168"></a></p> <ul> <li>Chose the process</li></ul> <p><a href="http://lh6.ggpht.com/-_tcUCpukl9Q/T85IZyAIRXI/AAAAAAAABHM/husEUgXrpnA/s1600-h/pic16%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic16" border="0" alt="pic16" src="http://lh6.ggpht.com/-gZp1_mctrVU/T85IbE5b0AI/AAAAAAAABHU/pDbAwGRwJDw/pic16_thumb%25255B2%25255D.png?imgmax=800" width="621" height="221"></a></p> <ul> <li>To ensure everything is correct, Click on the Job (Description)</li></ul> <p><a href="http://lh5.ggpht.com/-vdKbaPEID9Y/T85IciocpcI/AAAAAAAABHY/MMuggxnvaEk/s1600-h/pic17%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic17" border="0" alt="pic17" src="http://lh3.ggpht.com/-KLDoyRV3FmE/T85IdflzlJI/AAAAAAAABHg/39cFNQDo-AA/pic17_thumb%25255B2%25255D.png?imgmax=800" width="617" height="184"></a></p> <ul> <li>Click on Distribution of required Process, we must be able to see the given Folder Name and the Role.</li></ul> <p><a href="http://lh5.ggpht.com/-6xc7UDFjKg8/T85IeTMhv-I/AAAAAAAABHs/PSdvUjBEUfg/s1600-h/pic18%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic18" border="0" alt="pic18" src="http://lh6.ggpht.com/-deDy7-bg6lA/T85IfpWRr8I/AAAAAAAABHw/OO44hHEU9NM/pic18_thumb%25255B2%25255D.png?imgmax=800" width="621" height="192"></a></p> <p>8. Verify the distribution by going to Report Manager –> List</p> <p><a href="http://lh4.ggpht.com/--j9JVvD-Ubs/T85Igd0oo2I/AAAAAAAABH4/4S4MWjFTYS4/s1600-h/pic19%25255B4%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="pic19" border="0" alt="pic19" src="http://lh4.ggpht.com/-oKJgSlSEkwg/T85IhWqA9eI/AAAAAAAABIE/-36nKPBS4Sc/pic19_thumb%25255B2%25255D.png?imgmax=800" width="620" height="220"></a></p> <p> </p> <p><strong>Thanks a lot to my friend Ranjan Patro (<a href="http://in.linkedin.com/in/ranjanpatro" name="webProfileURL">http://in.linkedin.com/in/ranjanpatro</a>) for creating this document.</strong></p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com1tag:blogger.com,1999:blog-8458073463437959390.post-48781945718946328092012-05-29T10:21:00.001-07:002012-05-29T10:21:59.689-07:00An error has occurred that has stopped this transaction from continuing<p><u><strong>Reason 1:</strong></u></p> <p>This message appears due to <strong>0 rows</strong> in <strong>PS_INSTALLATION</strong> Table.</p> <p><u>Solution:</u> </p> <p>Insert a row in <strong>PS_INSTALLATION</strong> table and <strong>restart the appservers.</strong></p> <p><strong><u>Reason 2:</u></strong></p> <p>some error code in the events PreBuild, Activate, PostBuild or any FieldDefault<strong><u>.</u></strong></p> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com4tag:blogger.com,1999:blog-8458073463437959390.post-24182530116262649162012-05-22T09:48:00.001-07:002012-05-22T09:48:01.509-07:00Sending Multiple attachment using MCF Send mail method.<p>Below is the sample code to send multiple attachment in mail using MCF Send() mail method.</p><pre class="csharpcode">Local any &FromURL = <span class="str">"record://PV_ATT_DB_SRV/"</span>;<br />Local <span class="kwrd">string</span> &FILENAME;<br />Local Rowset &rwln1 = CreateRowset(Record.PV_ATTACHMENTS);<br />Local SQL &Sql1 = CreateSQL(<span class="str">"select attachsysfilename from PS_PV_ATTACHMENTS a,ps_SPF_RESUME_ATT b where a.scm_attach_id=b.scm_attach_id and b.person_id=:1"</span>, <span class="str">"000000000000025"</span>, &FILENAME);<br /><br /><strong>While &Sql1.Fetch(&FILENAME)<br /> &attach = create PT_MCF_MAIL:MCFBodyPart();<br /> Local <span class="kwrd">string</span> &ToFile = <span class="str">"C:/user/"</span> | &FILENAME;<br /> Local any &errorCode = GetAttachment(&FromURL, &FILENAME, &ToFile);<br /><br /> If &i = 1 Then<br /> &multiattach = CreateArray(&attach);<br /> &multiattach [&i] = &attach;<br /> Else<br /> &multiattach [&i] = &attach;<br /> End-If;<br /> &multiattach [&i].SetAttachmentContent(&ToFile, %FilePath_Absolute, &FILENAME, <span class="str">" "</span>, <span class="str">""</span>, <span class="str">""</span>);<br /> &mp.AddBodyPart(&multiattach [&i]);<br />End-While;<br /><br /></strong>Local PT_MCF_MAIL:MCFBodyPart &test1 = create PT_MCF_MAIL:MCFBodyPart();<br />Local PT_MCF_MAIL:MCFBodyPart &eMail1 = create PT_MCF_MAIL:MCFBodyPart();<br /><br />&eMail1.Text = &Message;<br />&mp.AddBodyPart(&eMail1);<br />&eMail.MultiPart = &mp;<br />&res = &eMail.Send();<br /><br />Local boolean &done;<br /><br />Evaluate &res<br />When %ObEmail_Delivered<br /> <span class="rem">/* every thing ok */</span><br /> &done = True;<br /> MessageBox(0, <span class="str">""</span>, 0, 0, <span class="str">"Email Sent Successfully"</span>);<br /> Break;<br />When %ObEmail_NotDelivered<br /> <span class="rem">/* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! */</span><br /> <span class="rem">/* Check &email.InvalidAddresses, &email.ValidSentAddresses */</span><br /> <span class="rem">/* and &email.ValidUnsentAddresses */</span><br /> <span class="rem">/* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! */</span><br /> &done = False;<br /> MessageBox(0, <span class="str">""</span>, 0, 0, <span class="str">"Email Not delivered"</span> | &eMail.InvalidAddresses | &eMail.ValidSentAddresses | &eMail.ValidUnsentAddresses);<br /> Break;<br />When %ObEmail_PartiallyDelivered<br /> <span class="rem">/* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! */</span><br /> <span class="rem">/* Check &email.InvalidAddresses, &email.ValidSentAddresses */</span><br /> <span class="rem">/* and &email.ValidUnsentAddresses */</span><br /> <span class="rem">/* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! */</span><br /> &done = True;<br /> MessageBox(0, <span class="str">""</span>, 0, 0, <span class="str">"Email Partially delivered"</span> | &eMail.InvalidAddresses | &eMail.ValidSentAddresses | &eMail.ValidUnsentAddresses);<br /> Break;<br />When %ObEmail_FailedBeforeSending<br /> <span class="rem">/* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! */</span><br /> <span class="rem">/* Get the Message Set Number, message number; */</span><br /> <span class="rem">/* Or just get the formatted messages from */</span><br /> <span class="rem">/* &email.ErrorDescription, email.ErrorDetails; */</span><br /> <span class="rem">/* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! */</span><br /> &done = False;<br /> MessageBox(0, <span class="str">""</span>, 0, 0, <span class="str">"Email Failed Before Sending"</span> | &eMail.ErrorDescription | &eMail.ErrorDetails);<br /> Break;<br />End-Evaluate;<br /><br />If &done = True Then<br /> While &Sql1.Fetch(&FILENAME)<br /> Local <span class="kwrd">string</span> &deleteFile = <span class="str">"C:/user/"</span> | &FILENAME;<br /> Local JavaObject &f = CreateJavaObject(<span class="str">"java.io.File"</span>, &deleteFile);<br /> &f.delete();<br /> End-While;<br />End-If;</pre><pre class="csharpcode"> </pre><pre class="csharpcode"><font face="Arial"><u>Note:</u> This is sample code. This required to include necessary application package and to declare objects.</font></pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-8399485691457534472012-05-05T10:20:00.001-07:002012-05-05T10:20:05.102-07:00Move and Delete files using PeopleCode<p>We can use the below java object and code to move or deleting files from some location.</p> <p><strong>Moving file:</strong> <p><pre class="csharpcode">Local JavaObject &source = CreateJavaObject(<span class="str">"java.io.File"</span>, <span class="str">"/source/file.txt"</span>);<br />Local JavaObject &target = CreateJavaObject(<span class="str">"java.io.File"</span>, <span class="str">"/target/file.txt"</span>);<br /><br />&source.renameTo(&target); <br /></pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style><br /><br /><p><strong>Deleting file:</strong><pre class="csharpcode">Local JavaObject &DelLoc = CreateJavaObject(<span class="str">"java.io.File"</span>, <span class="str">"/source/file.txt"</span>);</pre><pre class="csharpcode">&DelLoc.delete(); <br /></pre><pre class="csharpcode"><font face="Arial">Alternate code for deleting file:</font></pre><pre class="csharpcode">&tmpfile = GetFile(“c:\temp\file.txt”, “W”, “A”, %FilePath_Absolute);<br />&tmpfile.Delete();</pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style><br /><pre class="csharpcode"> </pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com3tag:blogger.com,1999:blog-8458073463437959390.post-26016014479993671572012-04-27T06:03:00.001-07:002012-04-27T06:04:34.436-07:00Add duration(number value) to Time field.<p>People Code to add duration to time field. <p><strong><u>Example:</u></strong> <p><font color="#1c3a6c">Here START_TIME, END_TIME is time field and DURATION is number field.</font> <p><font color="#0b2d7d"><strong>InPut:</strong> StartTime(START_TIME ) = 8:00AM and Duration(DURATION ) = 12</font> <p><font color="#0b2d7d"><strong>OutPut:</strong> EndTime(END_TIME) = 8:00PM</font> <p><strong><u>Sample Code:</u></strong><pre class="csharpcode">Declare Function Return_DateTime_value PeopleCode TIME_TBL.START_TIME FieldFormula;<br />Declare Function Return_Hour_Min_Part PeopleCode TIME_TBL.START_TIME FieldFormula;<br /><br />Local datetime &TIME_VALUE;<br />Local integer &MINUTES;<br /><br />&DUR_VALUE = TIME_TBL.DURATION.Value;<br />&StartTime = TIME_TBL.START_TIME.Value;<br /><br />Return_DateTime_value(&StartTime, &DUR_VALUE, &TIME_VALUE);<br />Return_Hour_Min_Part(&DUR_VALUE, &HOUR_PART, &MINUTES);<br /><br /><strong>TIME_TBL.END_TIME.Value = TimePart(AddToDateTime(&TIME_VALUE, 0, 0, 0, &HOUR_PART, &MINUTES, 0));</strong></pre><br /><p><u>Defining Functions:</u><pre class="csharpcode">Function Return_DateTime_value(&StartTime, &DUR_VALUE, &TIME_VALUE As datetime);<br /> Local date &RefDate;<br /> &RefDate = Date3(2000, 1, 1);<br /> &TIME_VALUE = &RefDate + &StartTime;<br />End-Function;<br /><br />Function Return_Hour_Min_Part(&DUR_VALUE, &iHour, &iMinutes As integer)<br /> &temp = String(&DUR_VALUE);<br /> &iHour = Value(Substring(&temp, 1, 2));<br /> &iPos = (Find(<span class="str">"."</span>, &temp));<br /> If &iPos > 0 Then<br /> &sMinutes = Substring(&temp, &iPos + 1, 2);<br /> If Substring(&sMinutes, 1, 1) = <span class="str">"0"</span> Or<br /> Len(&sMinutes) > 1 Then<br /> &iMinutes = Value(&sMinutes);<br /> &iMinutes = ((&iMinutes / 100) * 60)<br /> Else<br /> &iMinutes = Value(&sMinutes);<br /> &iMinutes = ((&iMinutes / 10) * 60)<br /> End-If;<br /> Else<br /> &iMinutes = 0;<br /> End-If;<br />End-Function;</pre><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style><br /><br /><style type="text/css">.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br />.csharpcode pre { margin: 0em; }<br />.csharpcode .rem { color: #008000; }<br />.csharpcode .kwrd { color: #0000ff; }<br />.csharpcode .str { color: #006080; }<br />.csharpcode .op { color: #0000c0; }<br />.csharpcode .preproc { color: #cc6633; }<br />.csharpcode .asp { background-color: #ffff00; }<br />.csharpcode .html { color: #800000; }<br />.csharpcode .attr { color: #ff0000; }<br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br />.csharpcode .lnum { color: #606060; }<br /></style> Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0tag:blogger.com,1999:blog-8458073463437959390.post-48443238884644601382012-04-27T05:39:00.001-07:002012-04-27T05:57:07.426-07:00XSL function to convert number to word<div dir="ltr" style="text-align: left;" trbidi="on">
Below code is used to convert Word from number in XSL.<br />
<br />
<span style="color: #01337e;">Sample Code: <i><b><?xdoxslt:toWordsAmt(12345.98)?></b></i></span><br />
<br />
<span style="color: #01337e;">Output: “<i>Twelve Thousand Three Hundred Fourty Five and paise Ninety Eight”.</i></span><br />
<br />
The code can be used in xml publisher document to convert number to word.</div>Pawan Mundhrahttp://www.blogger.com/profile/17661394389094461151noreply@blogger.com0