On Call Report 15/02/2019 13.00

===================
ISSUES
===================
Failed Assigned Payment Report 14/02/2019

ERROR: canceling statement due to conflict with recovery
Still failed with same error after several retries

Failed to generate report Coupon Report 14/02/2019

ERROR: canceling statement due to conflict with recovery
https://tvlk.slack.com/archives/CCMDQ0QB0/p1550198238034300

Failed Refund From Provider Report 11/02/2019

Missing totalSellingPrice or totalSellingPriceCurrency in PD item for BID 419747520 (Airport Transport)
Insurance inserted to PD but not handled in RFP
need decision how to fix from insurance team

Issue in Flight Ancillaries Report by Non Refundable Date - wrong record shown in report

Ticket : https://29022131.atlassian.net/browse/CNF-190
Status : IN TESTING by Mikhail
Phabricator: https://phabricator.noc.tvlk.cloud/D102973

Register ERP Hotel Commission Date - Issued Date - Original Currency on ERP Scheduler

Ticket : https://29022131.atlassian.net/browse/ESD-2650
Status : IN PROGRESS
need TV-SQL review https://phabricator.noc.tvlk.cloud/D102947
need to update diff (beginTime, endTime, lastTakenDate) each day

Please help to re-generate hotel commission dated 08-10 February 19

Ticket : https://29022131.atlassian.net/projects/ESD/queues/issue/ESD-2658
Status : RESOLUTION SUGGESTED

Regenerate ERP Package Hotel Invoice 01-02-2019 - 12-02-2019

Ticket : https://29022131.atlassian.net/servicedesk/customer/portal/30/ESD-2663
Status : CLOSED

Regenerate ERP Hotel Intercompany Invoice 01-02-2019 - 05-02-2019

Ticket : https://29022131.atlassian.net/servicedesk/customer/portal/30/ESD-2664
Status : CLOSED

Regenerate ERP Hotel Reschedule Refund to Customer 01-02-2019 - 12-02-2019

Ticket : https://29022131.atlassian.net/servicedesk/customer/portal/30/ESD-2665
Status : CLOSED

Change Parameter Hotel Package Non-refundable Invoice at Scheduler

Ticket : https://29022131.atlassian.net/projects/ESD/queues/issue/ESD-2666
Status : OPEN
Checked script in tv-sql, the scheduler should be already using allocation by commission
Investigating requirement (see ticket comment)

=================
OTHER ISSUES
=================
For other issues, see here https://29022131.atlassian.net/issues/?filter=20878

======================
IMPROVEMENT
======================
[sqitch] add retry_count column in job.task and function to inc counter

Ticket : https://29022131.atlassian.net/browse/NFP-54
Status : CODE REVIEW
Diff : https://phabricator.noc.tvlk.cloud/D103119

[tbiwp-prod-booking infinite retry] CURRENT PROGRESS

docs hanging task error log (this doc is our current progress investigate the hanging task of booking ids): https://docs.google.com/document/d/1Vwh6W5eB2jEpB1sCdRnfLWltH2E32k8qaxN26Qpx3vc/edit

[Option 1][Spec 1]Develop BP API to get by booking ID (for Sales document)

Ticket : https://29022131.atlassian.net/browse/NFP-24
Status : IN PROGRESS
Purchase Delivery: https://phabricator.noc.tvlk.cloud/D102639 Landed
Sales Delivery: https://phabricator.noc.tvlk.cloud/D102661 Landed
Sales Invoice: https://phabricator.noc.tvlk.cloud/D102666 Landed
Purchase Delivery, Sales Invoice, Sales Delivery BP API: https://phabricator.noc.tvlk.cloud/D102793. jar already released by ican, currently trying to restart the build, please help check the the api in staging

Handled by Mullia

[Option 1][Spec 1] Develop FinTools Front-End

Ticket: https://29022131.atlassian.net/browse/NFP-23
Status: In Review
Some BAs are reviewing the UI. We are still gathering feedbacks, can be accessed in https://entapar.test.tvlk.cloud/sales-documents-retrieval/retrieval-by-bid. Will proceed to review process next week.

Add CommissionInvoiceCreationScheduler to Check Delayed Scheduler monitoring

Ticket: https://29022131.atlassian.net/browse/NFP-28
Status: IN PROGRESS
Already do changes on playbook, on progress testing on local first.

For other improvements, see here https://29022131.atlassian.net/secure/RapidBoard.jspa?rapidView=839