Openbravo Issue Tracking System - Retail Modules
View Issue Details
0056956Retail ModulesAxisC3public2024-11-04 11:292024-11-12 08:27
wicherr 
adrianromero 
urgentmajoralways
closedfixed 
5
 
 
No
0056956: AXIS C3 : Credit card number absent in the data base + BO
As seen during the meeting Adrian,
The credit card number is not present in the database neither in the BO although it is present in the JSON from the payment. (We used the simulator C3 to do that payment).
This happens in NOZ environment.

The modules we use are :
org.openbravo.retail.axisc3 (V = 1.0.244000)
org.openbravo.retail.asyncpayprovider ( V = 1.0.244000)
org.openbravo.retail.posterminal ( V = 1.2.244001)


Here is the line in the DB :
UPDATE public.fin_payment SET ad_client_id='E2515B70FCCA4709A33B0DCB1A241F13', ad_org_id='8C68E6EDA1B749D991DE5DA998F3C573', created='2024-08-21 11:40:47.046', createdby='FB3A7E62309B4232A0E9AB1418274987', updated='2024-08-21 11:40:47.099', updatedby='FB3A7E62309B4232A0E9AB1418274987', isactive='Y', isreceipt='Y', c_bpartner_id='FA98B97C5D044241ACC55647AF4B9534', paymentdate='2024-08-21 00:00:00.000', c_currency_id='102', amount=12.99, writeoffamt=0, fin_paymentmethod_id='59F1CC0D9C104F0B83B79D3D9BFB370B', documentno='1000105', referenceno=NULL, status='RDNC', processed='Y', processing='N', posted='N', description='Commande N°: P999C05/0000007
', fin_financial_account_id='6BE7774E12644F35B7B6888BC69BEB11', c_doctype_id='C6CA228DFC7B4B0EB5A82FAD920FB5D9', c_project_id=NULL, c_campaign_id=NULL, c_activity_id=NULL, user1_id=NULL, user2_id=NULL, generated_credit=0, used_credit=0, createdbyalgorithm='N', finacc_txn_convert_rate=1.0, finacc_txn_amount=12.99, fin_rev_payment_id=NULL, c_costcenter_id=NULL, em_aprm_process_payment='RE', em_aprm_reconcile_payment='N', em_aprm_add_scheduledpayments='N', em_aprm_executepayment='N', em_aprm_reversepayment='N', em_obpos_paymentdata='{"provider":{"_identifier":"Carte Bancaire","_entityName":"OBPOS_PAYMENTGROUP","$ref":"OBPOS_PAYMENTGROUP\/78E5168A52194D0BA2F47E971DEEEA40","id":"78E5168A52194D0BA2F47E971DEEEA40","client":"E2515B70FCCA4709A33B0DCB1A241F13","client$_identifier":"NOZ","organization":"348DEE82EDF44807B17D3D62542B49AD","organization$_identifier":"NOZ France","active":true,"creationDate":"2024-04-08T09:30:39+02:00","createdBy":"B47FCF1DF720472CA32B114ED0B38B81","createdBy$_identifier":"Raphael Wicher","updated":"2024-04-08T09:30:39+02:00","updatedBy":"B47FCF1DF720472CA32B114ED0B38B81","updatedBy$_identifier":"Raphael Wicher","provider":"AC3_CardProvider","name":"Carte Bancaire","description":null,"obpos2ApplicationModes":null,"recordTime":1724233208280,"applicationModes":[]},"properties":{"cardlogo":"EMV.ONLINE","cardmasked":"497010******9548","cardNumber":"497010******9548","paymentInstrument":" ","paymentInstrumentData":{"paymentBrand":"EMV.ONLINE","cardmasked":"497010******9548","paymentInstrumentType":" ","cardNumber":"497010******9548","getcAxisEnum":"C3_ONLINEMODE_AXIS_PRIMARY","getcCardTypeEnum":"EMV","getCardType":"T","getcOptionChoisie":" ","getcOptionLibelle":" ","numContexte":" ","numDossier":"000004138529","signatureDemande":"0","caiEmetteur":" ","entryMode":"C3_ENTRYMODE_CHIP","voidproperties":{}},"processedAmount":12.99,"timeStamp":"210824","messages":{},"prints":[{"messageType":"PRINT","documentQualifier":"CustomerReceipt","messages":["------------------------"," SPECIMEN SIMULATION ","------------------------"," CARTE BANCAIRE ","*** INGENICO ***","*** Beyond Payment ***","A0000000421010 ","CB ","le 21\/08\/24 a 11:40:44 ","INGENICO "," 75015 Paris ","1999391 ","************9548","9327FFF126A7AB17 ","002 006 000907 ","C @ ","MONTANT= 12,99EUR ","DEBIT ","CARTE DE TEST "," TICKET CLIENT "," A CONSERVER ","*** CB5.2 ***","* Paiement proximite *"]}]},"nonmergeable":[],"subtotalid":[],"transaction":"4244","authorization":"A 187207","processedAmount":12.99,"cardlogo":"EMV.ONLINE","informationValues":[{"name":"ac3Transactionid","value":"D4C6D85E28A4581CDF2F6426C5E6F524"},{"name":"ac3Checkcmc7"},{"name":"ac3Bincode","value":"497010"}]}', em_obpos_app_cashup_id='D98E50C12B860C511E0D634FF526689E', em_obpos_applications_id='5FDB9CD47FD742E6815A78EE6BDA5B3C', em_obpos_rounded_payment_id=NULL, em_obpos_txtransaction='4244', em_obpos_txauthorization='A 187207', em_obpos_txcreditcardnummasked='', em_ac3_checkcmc7='', em_ac3_transactionid='D4C6D85E28A4581CDF2F6426C5E6F524', em_ac3_bincode='497010', em_obpos2_txoptioncode=NULL, em_obpos2_txserialdata=NULL WHERE fin_payment_id='7292ABEB93D9B06808478AC185AF50B3';
Do a payment with the AXIS C3 module, by credit card
NOZ
Issue History
2024-11-04 11:29wicherrNew Issue
2024-11-04 11:29wicherrAssigned To => adrianromero
2024-11-04 11:29wicherrTriggers an Emergency Pack => No
2024-11-04 12:00wicherrTag Attached: NOZ
2024-11-04 12:39hgbotNote Added: 0171286
2024-11-04 12:40adrianromeroStatusnew => scheduled
2024-11-07 16:17hgbotNote Added: 0171650
2024-11-12 08:27adrianromeroStatusscheduled => resolved
2024-11-12 08:27adrianromeroResolutionopen => fixed
2024-11-12 08:27adrianromeroNote Added: 0171786
2024-11-12 08:27adrianromeroStatusresolved => closed

Notes
(0171286)
hgbot   
2024-11-04 12:39   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.asyncpayprovider/-/merge_requests/40 [^]
(0171650)
hgbot   
2024-11-07 16:17   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.asyncpayprovider/-/merge_requests/40 [^]
(0171786)
adrianromero   
2024-11-12 08:27   
Fixed in https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.asyncpayprovider/-/commit/2f9f24faa3d5e1d835d71fdff6ecc00bf137661c [^]