| Day# | Content | Duration |
| 1 | PeopleSoft Technical Overview Application Designer Overview What all we do in Application Designer | 2 Hours |
| 2 | Introduction to PeopleCode Application Packages, Classes, Methods and other PeopleCode Elements What are the common methods we use for business requiremnts | |
3 | Overview | 3 Hours |
| App classes Vs functional Library | ||
| Elements of App Classes and their uses | ||
| Creating an App Package and App Class | ||
| App Engine | Introduction Why do we prefer Application Engine over SQR Section, Step and Action Different types of Actions and how and when they should be used Execution priority and flow of Actions in a Step State Records and Temp Records when and how to use them File Layouts and and how to use them in Application Engine Developing your First Application Engine Program Creating Process Definition to run the Program | 2 Hours |
| App Engine | Developing an Inbound Interface using Application Engine Developing an Outbound Interface using Application Engine | 2 Hours |
| App Engine | Parallel Processing Overview For what business scenarios Parallel Processign to be used How to Implement Parallel Processing in Application Engine | 1. 5 Hours |
| App Engine | Set Processing Overview For what business scenarios Set Processing to be used How to Implement Set Processing in Application Engine | 1.5 Hours |
| Page Design | What are Pages What are Sub Pages and how and when they are used What are Secondary Pages and how and when they are used Designing a simple and complex page What are the Components How to add multiple pages in a Component Deferred and Interactive Processing What are the Menues What are the Menue Bars and BarItems Creating Menues Understanding record structure in a Page Creating a Business Transaction using Page, Component and Menue Registering a Component through Application Designer | 3 Hours |
| Component Buffer | Understanding Component Buffer How CB Works Read/Write data from/to Component Buffer Reading/Writing data from Records fields in CB at various levels RowSet Class and how we use it in CB | 1.46 Hours |
| PeopleCode Events | Introduction of PeopleCode Event Different Scopes of PeopleCode Events PeopleCode Events Flow How to View and Write PeopleCode Events at various levels What are all the events fired and how they effect the page when we open a page in PIA | 2 Hours |
| 11 | Detailed Discussion on follwoing PeopleCode Events: Activate Prebuild Postbuild SavePreChange SavePostChange SearchInit SearchSave Developing a page for a business scenario where all these events have been used | 3 - 4 Hours |
| 12 | Detailed Discussion on follwoing PeopleCode Events: FieldEdit FieldChange FieldDefault FieldFormula RowInit RowInsert RowDelete RowSelect Developing a page for a business scenario where all these events have been used | 3 - 4 Hours |
| 13 | Introduction to Component Interface Why the CI is extremely important in uploading the data How does CI works Properties and in Methods in CI When and how the CI should be used How many ways we can call the CI | 2 Hours |
| 14 | Developing an Upload Program using CI and App Engine | 4 Hours |
| Migration Overview and project life-cycle | ||
| Understand the objects and their types | ||
| Inserting objects into project | ||
| Creating file references | ||
| Understanding data migration | ||
| 15 | Understanding DMS scripts and how to create them | 3 Hours |
| Upgrade flags and how they work | ||
| Creating Change package | ||
| Comparing and migrating the project in target instance | ||
| Reviewing and updating upgrade flags | ||
| Copying the project in the target instance | ||
| Building the project | ||
| Importing the data through DMS | ||
Converting Classic to fluid | Converting Pages in fluid | 6 Hours |
| Working on Page Layout in fluid | ||
| Working on Scroll area in fluid | ||
| Working on other page controls | ||
| Create layout page | ||
| Working on search record for fluid | ||
| Creating Component | ||
| Creating pivot grid for search functionality | ||
Fluid Tiles | Tiles overview and Core Concepts | 2 Hours |
| Types of creating fluid tiles | ||
| Creating tiles through Tile Wizard | ||
| Creating tiles through Portal Registry | ||
| Adding Tiles to homepage and the security configuration |
- HCM Concepts
- HCM Training Videos
- PeopleSoft HCM Functional
- Core HR
- Tableset Control
- FTE
- POI
- Hiring in PeopleSoft
- Other Core Concepts
- Part Time/Full Time, Regular/Temporary and Contingent Workers in PeopleSoft
- Employee Class (EMPL_CLASS) Field in PeopleSoft
- Business Unit, Company and Regulatory Region in PeopleSoft
- Understanding PeopleSoft Group IDs
- How to enable Signon Tracing option in PeopleSoft
- Business Unit, Company and Regulatory Region in PeopleSoft
- PeopleSoft 9.1 Person Model
- How the Various Date Fields on Employement Data Page are Updated
- 'Override Position Data' and 'Use Position Data' Option in Job Data Page
- PeopleSoft Benefit Record Number Vs Employee Record Number
- Absence Management
- Time and Labor
- Global Payroll
- Most frequently queried tables in PeopleSoft Global Payroll
- How to unfinalize a calendar in PeopleSoft Global Payroll
- Prompt isn't fetching the elements in the Rule Package Definition in PeopleSoft Global Payroll
- Unable to stop retro processing for a payee in PeopleSoft Global Payroll
- Retro trigger not picked up when created through INSERT SQL in PeopleSoft Global Payroll
- Segmentation not created for a payee in PeopleSoft Global Payroll
- Fluid
- PeoleSoft Security
- Peoplesoft Row Level Security Search Records
- Unable to See Future Dated Employee Record in Job Data Component
- Simplified Way to Provide a Page Access in PeopleSoft
- How to Resolve a Row Level Security Issue in PeopleSoft
- How to find the List of Users Assigned to a Role
- Process Security in PeopleSoft
- Definition Security Error "You are not authorized to access the definition XXXXXXX"
- Why the dynamic role isn't getting assigned to intended users in PeopleSoft"
- You are not authorized to access this component. (40,20)
- Peoplesoft Row Level Security Search Records
- Core HR
- PeopleSoft Online Training
- PeopleSoft Technical
- PeopleSoft Installation
- PeopleSoft 9.1 with PeopleTools 8.52
- PeopleSoft Installation Made Extremely Easy
- PeopleSoft Installation Made Extremely Easy: Part 1
- PeopleSoft Installation made Extremely Easy: Part 2
- PeopleSoft Installation made Extremely Easy: Part 3
- PeopleSoft Installation Made Extremely Easy: Part 4
- PeopleSoft Installation Made Extremely Easy: Part 5
- How to Connect to a Database through SQL Developer in MS Window
- Connecting and Starting the Database through sqlplus Command Utility
- PeopleSoft 9.2 with PeopleTools 8.54
- PeopleSoft 9.1 with PeopleTools 8.52
- AWE
- Application Engine
- Integration Broker
- Other Technical Concepts
- Peoplesoft Row Level Security Search Records
- Understanding Component Interface in PeopleSoft
- How to use PeopleSoft ExceltoCI Utility
- Understanding Dynamic Prompts in PeopleSoft
- 4 Key advantages of Application Package over traditional Functional Libraries
- Prompt isn't fetching the elements in the Rule Package Definition in PeopleSoft Global Payroll
- Important SQL Queries
- Portal
- PeopleSoft Events
- PS Query
- PeopleSoft Installation
Showing posts with label Component Buffer. Show all posts
Showing posts with label Component Buffer. Show all posts
Thursday, July 9, 2020
Monday, January 22, 2018
PeopleSoft - Data Conflict Issues
“Come on!!! This is such a simple and straightforward component.. It’s not fair… Why am I running into this issue…”. Ever felt disheartened like this when you see these kind of error messages?
Chill out!! You are not alone.. Let’s set this right..
The prime cause of this issue is because of writing into a PS Record with duplicate key values. Basically, there exists a row with some key values and you are trying to add another row with same key combination, so look out for how did you end up with such duplicate rows.
I have itemized a few steps which needs validation when you encounter this error
Data being added conflicts with existing data(18,2
orChanges conflict with another data item. (18,5)
Chill out!! You are not alone.. Let’s set this right..
The prime cause of this issue is because of writing into a PS Record with duplicate key values. Basically, there exists a row with some key values and you are trying to add another row with same key combination, so look out for how did you end up with such duplicate rows.
I have itemized a few steps which needs validation when you encounter this error
Get the Basics Right – Record Level Structure
Remember your first lesson in creating multiple levels in PS? Yes.. Level 1 record must contain key fields from Level 0 Record and an additional key. Check out if your key structure is right, otherwise fix it now.
Stop Clashing with Component Processor – No Auto Select & No Auto Update Property
Either you do the selection of rows from tables or allow the component processor to do it for you. When you populate a grid or scroll area through peoplecode, you must check the ‘No Auto Select’ property. Likewise, when you have decided to take care of updating the backend records, better select the ‘No Auto Update’ option. When you ignore this, you end up updating the same row twice leading to this issue.
Thoroughly check all the grid and scroll area properties from your main and secondary pages and make sure you don’t clash with the component processor.
I would recommend allowing the component processor to do its job unless you have some business requirement that requires selection or updation through peoplecode. Atleast try avoiding SQLEXEC statements to insert or update records which are readily available in your component buffer. Why reinvent the wheel??
Weird Field Assignments
Let’s say you have a field named ‘COMPANY’ which is a key field in one of your records and a peoplecode in ‘PreBuild’ or ‘Rowinit’ event sets a default value to this field. If this field is editable and user enters some value and saves it, the next time when user opens the page again, the default value is displayed again and if you try to modify this key field and save again, you will encounter Data Inconsistency issue.
So always look for such weird field assignments/modifications,
Check out for Saveprechange or Savepostchange events, if some code is modifying your key values.
Did you overlook your record peoplecode? There are chances that the same record is being used in multiple components and the code written for some other purpose gets triggered for our business transaction resulting in data conflict issues.
Out of sync Sequence Numbers
When you use sequence numbers in your page that needs to be incremented and updated every time, better not to go with SQLEXEC Update statements, Instead use the delivered getNextNumberwithGapsCommit() function. This can help avoid data inconsistency issues.
Clear App Server Cache
For no reason, if most of the users receive data conflict issues, I would suggest to clear the app server cache. Believe me, it helps sometimes.
Subscribe to:
Posts (Atom)