Thursday, April 9, 2015

Detail Page,Disable saving Page in Component Properties

Detail Page
Select a Component,navigate to the use tab in properties,you will find the Detail page tab.I was wondering what does this function do. I  did a lot of R & D which i am sharing with you folks.

The detail page relates back to the search record. It's used to give the user more information about the item being selected before it's selected. For example, assume that your search page returns two employees with the same name but different EmplIDs. The detail page could be used to show more information about the employee (department, job title, manager, etc.) so the user makes sure they choose the right one. 
The Detail Page option exists on the component properties, it has been dropped by Oracle. Please go through  8.9 PeopleBooks:: 'No longer used in PeopleSoft applications. This option appears for upgrade purposes only.'



Disable saving Page
Navigate to component Properties Use tab, we have the Disable saving Page option.This function is used to disable the saving option from your page.
Peoplebooks Explanation:Select when you want to hide the Save button in the toolbar and disable the Alt+1 (Save) hot key. Selecting this option prevents users from being prompted to save when exiting a page. However, it does not prevent using PeopleCode to save a page with the DoSave() or DoSaveNow() functions. This functionality can be helpful for applications in which the user is not making database changes and does not need to be prompted to save.


After enabling the Disable Saving Page Option
So if we want back the save option , go back to the component properties and uncheck the Disable Saving Option.Then navigate to the internet tab in component properties,then check the save option.once you are done save the properties.check the page you will have the save option.













ORA-01791: not a SELECTed expression

ORA-01791:not a SELECTed expression
Cause:There is an incorrect ORDER BY item. The query is a SELECT DISTINCT query with an ORDER BY clause. In this context, all ORDER BY items must be constants, SELECT list expressions, or expressions whose operands are constants or SELECT list expressions.
Action:Remove the inappropriate ORDER BY item from the SELECT list and retry the statement.

Once we remove the ORDER By clause the sql should work without any error.

Wednesday, April 8, 2015

Prompt not working in Peoplesoft

I tried to create a new page,added Emplid field and made it as the key and search key.
Then for this field Emplid,prompted the job table,but the value was not getting populated.
I searched many areas to figure it out but for my bad i was unable to resolve it.
then i found out that even though i have prompted the job table to Emplid field,it was fetching value from some other table.I checked the Job table ,Emplid field then i realized that Emplid field in job table was prompted to Person table.
The other option to solve this issue is to create a view of Job table,but i wanted to resolve it without creating a view,then i changed the Emplid field prompt from Job table to the Person table and hence i was able to populate the values correctly.



PeopleSoft Fluid User Interface

Hi Readers,you might have heard about PeopleSoft Fluid User Interface,Well this has been one good revolution that took place in PeopleSoft.Let's go ahead and see what is PeopleSoft Fluid Interface.
                                                              PeopleSoft UI is much more than a mobile Platform.The design consist of device independent design for mobiles,Tablets and desktops,offering the advanced users experience utilizing the latest rendering technologies including HTML 5 and CSS3.
PeopleSoft Fluid User Interface offers all users a rich and easily understood means with PeopleSoft.
Power and casual Users with the traditional Classic Desktop View and the new Users from the executive range with the fluid Interface.



PeopleSoft Fluid User Interface enables mobility in any device and it is truly responsive.It recognize the device form factor that you  are using to access PS and renders the layout that's optimized for it.

For example,the PeopleSoft Interface behaves responsively to a landscape and portrait modes in a tablet


Landscape Mode


Portrait Mode


Hidden Menu
Designed as a significant improvement over the PeopleSoft “classic” user interface, the PeopleSoft Fluid User Interface moves away from pixel-perfect page layout and provides greater flexibility with the enhanced use of cascading style sheets (CSS3), HTML5, and JavaScript. PeopleSoft application fluid pages scale gracefully from large screen devices, such as laptops and desktops, to the reduced viewing space of tablets and smartphones. Many commercial websites use a similar design model whereby the presentation and layout of information is adjusted dynamically to conform to the dimensions of the user’s device. The Fluid User Interface design approach gives developers just this type of control over the user experience. When a larger screen size (a screen with more “real estate”) is detected, the application content will adjust and conform accordingly to fill the space effectively. Similarly, if a smaller screen size is detected, non-essential information can be removed and the presentation of content will adjust to flow in a usable way. Like PeopleSoft “classic” pages, fluid page definitions are maintained within PeopleSoft Application Designer, and the application developer will have the ability to define and apply conditional formatting appropriate to smartphone, tablet, or large-screen devices. At runtime, PeopleTools will apply the corresponding formatting according to the device in use. An end user can interact with fluid pages using a conventional mouse and keyboard or using a touch interface, which is common on tablets and smartphones. These new pages are device-independent and will operate on any certified device browser