Support #13432
[SCP ID :##6603##] : Transaction Data Constraints that cannot entered in the DB Portal
Status: | Pending Customer Feedback | Start date: | March 03, 2023 | ||
---|---|---|---|---|---|
Priority: | High | Due date: | |||
Assignee: | Bramantyo Pujo Wiyono | % Done: | 90% | ||
Category: | - | Spent time: | - | ||
Target version: | - |
Description
Hi,
Kindly attend below request:-
As request by BI to create ticket for this issue below.
Please help to analyze the anomaly of some transactions on March 2, 2023. We have tried to re-offload, but the transaction data cannot enter the DB Portal. As additional information, these problem transactions are captured in the file in error_trnx, both during normal transaction processing and when the process is offloaded again.
note : please provide a query for insert data so that it can be re-calculated
History
#1 Updated by Bramantyo Pujo Wiyono over 1 year ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- % Done changed from 0 to 90
The RPP_TRNX_LOG_DATA that failed offload the data from IPF_TRAN_LOG is because the mapping for this mapping max length are 35:
RPP_TRNX_LOG_DATA.RFI_CODE
Source: IPF_TRANS_LOG.PAYMENT_DATA >> $.payment.Dbtr.Nm
I already give them manual insert query for the failed transaction data that failed to offload to portal.
#2 Updated by Rayvandy Gabbytian about 1 year ago
13/09/2023: As per today's meeting with PTAP. They will only look into items that is Pending for PROD deployment. We have informed rest of issues to PTAP via this spreadsheet: https://docs.google.com/spreadsheets/d/1JnU6U0qy8CZ_rkydCq_2xdGOJ9ctc8da2vI47pNv5gI/edit#gid=0
Awaiting for PTAP's decision: