Project

General

Profile

Actions
Copy link

Task #15870

closed

Task #15811: Billing Fix - Discrepancy Found - May 2025

Billing - To fix PKG_WAREHOUSE.SP_GET_TRANSHIPMENT_WAREHOUSE

Added by Redmine Admin 7 months ago. Updated about 3 hours ago.

Status:
Closed
Priority:
High
Assignee:
-
Start date:
03/12/2025
Due date:
03/14/2025
% Done:

100%

Estimated time:
16:00 h
Spent time:
16:00 h
GitLab ID:
2206
GitLab Milestone:
GitLab Ticket Number:
461
GitLab Time Logged:
57600
Lock Timeline Date:
No
gitlab project trace:
Billing Fix - Discrepancy Found - May 2025

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}]

Actions
Copy link

Also available in: Atom PDF