Found 617 results.
Run every mile at Kovai MarathON to support the cause of promising young students’ education through our Kovaion Kalvi!
Learn how PeopleTools 8.61 enhances Application Engine with plug-ins, offering seamless customization, improved performance, and database optimization.
PeopleTools 8.61 has introduced several features and updates for Application Engine, including plugins that improve its functionality, enhance performance and expand integration capabilities.
Navigation: PeopleTools > Application Engine > AE Action plug-ins
Fig: 1 Search for Application Engine
Fig: 2 Select Step and Action
Fig: 3 Select Application Engine Plug-ins
In the Application engine pug-ins three types of mode exist.
Fig: 4 Application Engine Mode
Application Engine Enhancements in People Tools 8.61
Application Engine Plug-ins:
Fig: 5 AE Plug-ins Action and Steps
Meta SQL functions in AE Plug-ins:
The meta-SQL is the PeopleSoft-specific feature used for the placeholder or function which is embedded in SQL definition. It is useful for enabling PeopleSoft database platform independence.
This enhancement includes the following meta-SQL functions which can be used in Application Engine Plug-ins.
%GetNextSeqValue:
This meta-SQL function will increase the given database sequence and return its next value developer can create a new sequence or migrate GetNextNumberWithGapsCommit(). It is commonly used to fetch the next value from the SQL objects.
Syntax
%GetNextSeqValue(sequence_name)
Example usage in Application Engine
SQLExec(“SELECT %GetNextSeqValue(PS_ORDER_NUMBER) FROM %SelectDummyTable”, &order_number);
INSERT INTO PS_MY_TABLE (ID, NAME, CREATED_DT) VALUES (%GetNextSeqValue(MY_SEQ), ‘John Doe’, %CurrentDateIn );
%UpdateStats:
This meta-SQL function will be helpful in the Application Engine Plug-ins to update database statistics for the specific table, used for the query optimization by maintaining accurate statistics, it helps the Application engine performance in the most efficient way.
Use this constructor when we try to insert a large amount of data in the temporary tables that will be deleted before the end of the program run. It will save you from having dummy seed data for the temporary tables.
Syntax:
%UpdateStats(record name,[HIGH/LOW])
Example usage in Application Engine
%UpdateStats(PO_WRK1)
INSERT INTO PS_SALES_DATA (SALES_ID, AMOUNT, REGION) SELECT SALES_ID, AMOUNT, REGION FROM PS_SALES_STG;
%UpdateStats(PS_SALES_DATA);
Uses of %UpdateStats:
If we %UpdateStats in the Application Engine Plug-ins it will maintain efficient database performance.
It can be used after performing bulk insert, update, or delete
It will be helpful in tuning the performance of complex queries.
%DeleteStats:
It is used to delete the meta-SQL in Oracle database
used to remove the outdated statistics from the table and immediately rebuild the fresh statistics using %UpdateStats
Using %DeleteStats and %UpdateStats in the Application Engine Plug-ins we can maintain the performance and reliability of the database queries
Syntax:
%DeleteStats(table_name)
Example usage in Application Engine:
%DeleteStats(PS_EMPLOYEE_TMP);
%UpdateStats(PS_EMPLOYEE_TMP);
Use of Meta-SQL function in AE Plug-ins:
It will be helpful to optimize the performance for bulk operations like insert or update, and simplify the SQL maintenance and SQL code can be reused.
Key Features of Application Engine Plug-ins in PeopleTools 8.61:
It allows developers to add specific functionality without modifying the core AE program. This ensures that each AE program remains easy to manage and maintain.
Once a plug-in is developed, it can be reused across different AE programs. This reduces duplication of effort and helps maintain consistency in functionality.
Plug-ins can be used to improve the performance of AE programs by introducing efficient algorithms or by using specialized processes like caching, logging, or batch processing.
Developers can write custom logic as part of the plug-ins to handle specific business rules or unique process requirements.
Plug-ins can help improve error handling and logging mechanisms within AE programs. For example, a plug-in can be designed to capture detailed error information or send notifications upon failure.
Author
Name: Saravana Kumar
Designation: Associate Consultant
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
