Task #15870
closedTask #15811: Billing Fix - Discrepancy Found - May 2025
Billing - To fix PKG_WAREHOUSE.SP_GET_TRANSHIPMENT_WAREHOUSE
Description
Issue lies in source retrieval of data in Oracle. Need to fetch distinct integration rules info for both export and import voyages in query MainInfoTBD cursor.
Error is thrown in SQL: [SP_INSERT_OCEAN_IMP_TSH_BILLING_XML]. The error is: Violation of PRIMARY KEY constraint 'PK_MainTBDInfo'. Cannot insert duplicate key in object 'dbo.MainTBDInfo'. The duplicate key value is (928998a2-e63c-40f0-9a65-47a1adb349fd, ATP24005482, CNTAO, ATP24005550).
Refer to:
select top 100 * from [OceanImp_Integration_Exception] where JobNumber = 'TSP202406211542093973';
Note: Will need to reprocess all cases where above error has occured once the original SP has been fixed! To create a procedure which will find out the records whereby this issue has occured, loop it, call the billing save into warehousing pocedure for each record.
GitLab Sync Log
[{"id": "23393", "author": "Al-Shad Isaac", "hours": 16.0, "created": "2025-05-19T11:02:08.303Z", "log_date": "2025-05-19", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-05-19T11:02:08.303Z: 2d-(16.0)h spend at: 2025-05-19", "status": "active", "deleted_by": "", "redmine_entry_id": 7681}]
Updated by Redmine Admin 7 months ago
- Parent task changed from #15825 to #15811
- gitlab project trace changed from Billing Fix Lot 1 to Billing Fix - Discrepancy Found - May 2025