Subject: | FMIS Integration to Payroll failing using CAAF customization |
Summary: | Issue: Unable to successfully complete FMIS Payroll integration using Client CAAF Customization. The error as per figure 1.1 below was displayed in the event log and process SYS009: Perform all integration tasks. This includes General Ledger Journal, Sales Order and Creditor Invoice had a status as failed. Steps to replicate: - Created a pay in Client database.
- Updated this pay and verified the progress in FMIS Integration view in ESS-Web.
- Status was in progress.
- Verified if Integration process was running. It had a status as Failed.
- Reviewed event log. Error message as per figure 1.1 was displayed.
QA Environment - OS version: Window Server 2012 R2 Standard
- Application version:9240.000Beta
- Database (Demo/New/Client): Client
- Server: LINKQA4
- Database: CLIENT-CAAF-LINKSOFT
- Web Hosted on: 10.0.0.14\ESS-CAAF
Figure 1.1 |
Audit Notes: | |
23 Feb 2018 | 02:42PM Comment 1 by Alvis (Link Technologies) Case 9130 added to project 8.3 |
23 Feb 2018 | 02:45PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-02-2018 02:45 PM Time Taken: 1.00 |
| The following were done: - Changed customization scripts for CAAF to resolve this error.
- Applied updated customization script to CAAF database and tested payroll integration. Journals were successfully created.
Please UAT in beta5. regards Alvis |
|
26 Feb 2018 | 01:33PM Comment 3 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-02-2018 01:33 PM Time Taken: 2.00 |
| Hi Guys I have tested this case on a copy of CAAF database after upgrading it to Beta 925. The below task was performed: - For active pay number 19, performed pay verification.
- Generated the GL integration report. (Successful)
- Updated Pay.
- Compared the Creditor Purchase and Journal set with the Creditor Purchase and Journal of the prior version. Both reconciled with each other.
The below setup was used to test this case:
QA Environment - OS version: Window Server 2012 R2 Standard
- Application version:9250.000Beta
- Database (Demo/New/Client): Client
- Server: LINKQA4
- Database: CLIENT-CAAF-LINKSOFT
- Web Hosted on: 10.0.0.14\ESS-CAAF
This issue has been resolved. Please review and proceed to closing this case. Regards Vineet Ram |
|
26 Feb 2018 | 02:07PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-02-2018 02:07 PM |
| Thanks Vineet. |
|
09 Oct 2019 | 08:14AM Comment 5 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |