Monday, 31 October 2016

Access level 1 field from level 0

/*Declaring Variables*/
Local Rowset &rowset;
Local Record &rec;
Local Field &field;

&rowset0=getlevel0();  /*Get level 0 rowset*/
&row=&rowset0.getrow(1)/*Get row 0 of level 0 rowset*/
&rowset1=&row0.getrowset(scroll.RECORD_NAME1);  /*Get rowset from row 0 using the scroll name(can also be the name of the primary record in the scroll)*/
&row1=&rowset1.getrow(1);  /*get row1 of level 1 rowset*/
&rec1=&row1.getrecord(record.RECORD_NAME2);  /*get record in the row1*/
&field1=&rec1.FIELD_NAME;  /*finallay access the field in the record*/ 


&rowset1 = getlevel0(1).getrowset(scroll.RECORD_NAME1);
&field = &rowset.getrecord(record.RECORD_NAME).FIELD_NAME;


Thursday, 13 October 2016

Trigger Peoplecode on selection of radio button.

When we are working with radio buttons, there is a problem say associated peoplecode does not trigger when we select radio button. Lets learn how associated peoplecode can be triggered on selecting radio button below.

Create a simple Peoplesoft page having radio buttons.

Now go to page properties and uncheck allow Defferred Processing.

Now you will see that associated peoplecode will trigger when you select a radio button. 



Sunday, 9 October 2016

What is an Applcation Designer?

Lets understand what is an Application Designer in PeopleSoft.

PeopleSoft Application Designer or App Designer – as it is commonly called, as the name suggests, is used to create and modify PeopleSoft applications. With App. Designer, you can create and modify most of the objects in PeopleSoft.
This is the Integrated Development Environment (IDE) that you can use to work with numerous PeopleSoft definitions like Fields, Records, Pages, Components, Menus, PeopleCode and more.Like any other standard IDE, Application Designer supports graphical user interface and drag and drop facility.



Here are some PeopleTools we can learn.

1. Application Designer
    We use it for creating Fields, Records, Pages, Component, Menu.

2. Application Engine 
    We use it to create background processes.

3. BI Publisher 
    It is a reporting tool, We use it for reporting.

4. nVision 
    It is a reporting tool.

5. Component Interface 
    It is used to expose a peoplesoft Component to third party applications like excel etc.

There are some more tools in peoplesoft but we will discuss them later.


Thursday, 6 October 2016

History of PeopleSoft ? What is PeopleSoft ?

Dave Duffield and Ken Morris founded PeopleSoft in 1987, when they engineered the company’s first human resources application. Built on a client-server architecture, their solution offered flexibility and ease-of-use to a class of users previously barred from simplified access to the information and capabilities centralized in mainframes.
By putting ease of functionality directly in the hands of users, PeopleSoft quickly assumed industry leadership status in human resources solutions.
This would be the first of many innovations that would transform the way enterprises do business on a global scale. In 2000, PeopleSoft introduced the Pure Internet Architecture®. Even today, it is the only pure-internet architecture with no code on the client.
It has enabled what PeopleSoft calls the Real-Time Enterprise. It allows organizations to connect people directly to business processes, eliminating intermediaries, inside and outside the enterprise. It creates unprecedented efficiency and lowers costs.
It provides businesses with an unmatched competitive advantage. The Real-Time Enterprise sets the standard for business performance in the 21st century, and PeopleSoft is at the forefront of enabling businesses to make this model a reality.
PeopleSoft was the world’s second largest provider of enterprise application software. PeopleSoft’s business solutions are built with the flexibility to fit your business today and the adaptability to change with your business over time.
A broad portfolio of applications with industry-specific functionality gives you unprecedented flexibility to optimize business operations and compete more effectively.
PeopleSoft is a worldwide leader in providing complete solutions for more than 24 industries—from industrial manufacturing and consumer goods to financial services, healthcare, and public sector organizations.
More than 12,200 organizations worldwide—from mid-sized manufacturing companies to the largest service enterprises in both the private and public sectors—are using PeopleSoft solutions to build stronger and more profitable businesses.
PeopleSoft applications are built on innovative and open technology, enabling easy integration with third-party applications and legacy systems. And PeopleSoft’s pioneering Total Ownership Experience initiative ensures the best overall user experience at the lowest cost of ownership.
Founded in 1987 and headquartered in Pleasanton, California, PeopleSoft has 12,000 employees and annual revenues of more than $2.3 billion.


Costed Flag in PS_TRANSACTION_INV table

COSTED_FLAG = Y or N If you are adding a row PS_TRANSACTION_INV, you have to decide if you want the row to be taken into account by the c...