# JPMC-PDP Documentation from https://developer.payments.jpmorgan.com # Exception Details report This report provides a summary of successful and unsuccessful transactions and details of unsuccessful transactions (Declined/Rejected/Cancelled/On-Hold). **Exception details report information** | Report type | Supported entity types | Supported file formats | | --- | --- | --- | | Transaction details | - PE - Processing Entity - TD - Transaction Division - BU - Business Unit - FTI - Fund Transfer Instruction - CO - Company - RG - Reporting Group - PI - Platform Identifier | - Comma Separated Values (CSV) - Gzip or GNU Zip (GZ) - Portable Document Format (PDF) - MS Excel Workbook (.xlsx) | ## Use cases - View transactions summary for a submission date, with classification of number of transactions declined, rejected, cancelled, on-hold or successful, and total transaction amount in each category. - View exception details and rejection reason for unsuccessful transactions. ## Granularity - Summary section: Combination of Presentment Currency Code, Settlement Currency Code, Merchant Presenter Identifier, Submission Identifier, and Submission Date. - Details section: Merchant Order Number ## Fields ### Summary The following table shows the summary section field details. **Summary section field details** | Field name | Definition | | --- | --- | | Record Type | The section of the report. For the summary section, record type value is Transaction Summary. | | Presentment Currency Code | The three-character abbreviation for the currency in which the cardholder transaction occurred. | | Settlement Currency Code | The three-character abbreviation for the currency in which the merchant is being funded. | | Merchant Presenter Identifier | The merchant presenter identifier. | | Merchant Presenter Short Name | The merchant presenter's short name. | | Submission Identifier | The unique identification number for the submission. | | Submission Status | The status of the submission in which this transaction was included. | | Submission Date | The date on which the submission was fully received at J.P. Morgan. | | Transaction Count | The count of transactions for the summarized record. | | Authorization Count | The count of authorizations for the summarized record. | | Declined Deposit Count | The count of deposits declined for the summarized record. | | Declined Deposit Amount | The total Deposit Amount declined for the summarized record. | | Rejected Transaction Count | The count of rejected transactions for the summarized record. | | Rejected Transaction Amount | The total transaction amount rejected for the summarized record. | | Cancelled/On-Hold Deposit Count | The count of deposits cancelled on-hold for the summarized record. | | Cancelled/On-Hold Net Deposit Amount | The total deposit amount cancelled/on-hold for the summarized record. | | Successful Deposit Count | The count of successful transactions for the summarized record. | | Successful Net Deposit Amount | The total successful transaction amount for the summarized record. | | Entity Name | The name associated with the Commerce platform assigned entity identifier. | | Transaction Division External Identifier | The identifier of the external transaction division. | | Transaction Processing Entity Identifier | The identifier of the transaction processing entity. | | Platform Identifier | The identifier of the platform used to facilitate the transaction request. | | Platform Name | The name of the platform used to facilitate the transaction request. | | Business Unit Identifier | The identifier of the business unit associated with the record. | | Business Unit Name | The name associated with the Commerce platform assigned business unit number. | | Company External Identifier | The identifier of the external company. | | Company Name | The name associated with the Commerce platform assigned CO number. | ### Details The following table shows the details section field details. **Detail section field details** | Field name | Definition | | --- | --- | | Record Type | The section of the report. For the details section, record type value is Exception Details. | | Transaction Division External Identifier | The identifier of the external transaction division. | | Presentment Currency Code | The three-character abbreviation for the currency in which the cardholder transaction occurred. | | Settlement Currency Code | The three-character abbreviation for the currency in which the merchant is being funded. | | Submission Identifier | The unique identification number for the submission. | | Record Number | The sequential number of a transaction within a submission file. | | Merchant Order Number | The order number submitted by the merchant with the original sale. | | Exception Description | The type of exception being reported in this data record. | | Amount | The transaction amount. | | Payment Method Code | The code that identifies the method of payment (MOP) for the transaction. | | Account Number | The cardholder's account number. | | Credit Card Expiration Year Month Number | The credit card account expiration date (month and year) as submitted by the merchant with this transaction. | | Merchant Action Code Text | The type of transaction action conducted. Valid values are: - AUTHORIZATIONS - DEPOSITS | | Authorization Date | The date and time in UTC time zone on which the authorization was performed for the transaction. | | Authorization Code | The six-character code related to a positive response from the endpoint. | | Auth Response Code | The authorization response code indicating Approval, Decline or Rejection. | | Country Of Issuance | The standard alpha ISO country code that identifies the card's issuing country. May be blank for transactions on unsupported methods of payment. | | Merchant Category Code | The code that is used to classify a merchant's product or service. | | Reject Code | The code that is used to classify the reason for rejecting a transaction. | | Card Usage Type | Identifies whether the transaction is a Signature Debit transaction (1), PIN Debit transaction (2), or a Credit Card transaction (3). | | Entity Identifier | The associated CO, BU, TD, or PE identification number. | | Entity Type Code | The level at which the reported event occurred. Valid values are: - BU - Business Unit - CO - Company - TD - Transaction Division - PE - Processing Entity | | Platform Identifier | The identifier of the platform used to facilitate the transaction request. | | Platform Name | The name of the platform used to facilitate the transaction request. | | Transaction Processing Entity Identifier | The identifier of the transaction processing entity. | | Entity Name | The name associated with the Commerce platform assigned entity identifier. | | Business Unit Identifier | The identifier of the business unit associated with the record. | | Business Unit Name | The name associated with the Commerce platform assigned business unit number. | | Company External Identifier | The identifier of the external company. | | Company Name | The name associated with the Commerce platform assigned CO number. | ## Sample report configurations The following samples help you get an idea of how to configure exception reports. ### CO/BU/TD/PE The following request code block shows how to configure an exception report for `entityType` = CO/BU/TD/PE. ```json { "entityType": "CO", "entityIds": [ "1234567" ], "reportSections": [ { "sectionTitle": "Transaction Summary", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Transaction Summary" }, { "reportAttributeName": "Entity Identifier", }, { "reportAttributeName": "Entity Type Code", }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Merchant Presenter Identifier" }, { "reportAttributeName": "Merchant Presenter Short Name" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Submission Status" }, { "reportAttributeName": "Submission Date" }, { "alias": "Transaction Count", "reportAttributeName": "Merchant Order Number", "aggregateOperationText": "count" }, { "reportAttributeName": "Merchant Order Number", "alias": "Authorization Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Merchant Action Code Text", "aggregateConditionText": "= 'AUTHORIZATIONS'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Declined Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Declined Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Rejected Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Rejected Transaction Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Cancelled/On-Hold Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Cancelled/On-Hold Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Successful Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Successful Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Presenter Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Merchant Action Code Text", "filterAttributeCode": "NOT IN (\"EXCLUDE FROM REPORTING\")" }, { "reportAttributeName": "Online Submission Indicator", "filterAttributeCode": "IN (\"N\")" }, { "reportAttributeName": "Latest Authorization Indicator", "filterAttributeCode": "=\"TRUE\"" } ] }, { "sectionTitle": "Exception Details", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Exception Details" }, { "reportAttributeName": "Entity Identifier" }, { "reportAttributeName": "Entity Type Code" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Record Number" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "Exception Description" }, { "alias": "Amount", "reportAttributeName": "Presentment Amount" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Account Number" }, { "reportAttributeName": "Credit Card Expiration Year Month Number" }, { "reportAttributeName": "Action Code Text" }, { "reportAttributeName": "Authorization Date" }, { "reportAttributeName": "Authorization Code" }, { "alias": "Auth Response Code", "reportAttributeName": "PTI Authorization Response Code" }, { "reportAttributeName": "Country Of Issuance" }, { "reportAttributeName": "Merchant Category Code" }, { "reportAttributeName": "Reject Code" }, { "reportAttributeName": "Card Usage Type" } ], "sectionSortOrderList": [ { "reportAttributeName": "Entity Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Order Number", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Exception Description", "filterAttributeCode": "IN(\"rejected transaction\",\"declined deposit\",\"cancels/onhold\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Exception Details Report", "reportFileName": "Exception Details Report....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Transaction Summary & Exception Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2026-03-24 02:00:00", "reportingPeriodEndTimestamp": "2026-03-25 01:59:59" } } ``` ### PI The following request code block shows how to configure an exception report for `entityType` = PI. ```json { "entityType": "PI", "entityIds": [ "6019581085" ], "reportSections": [ { "sectionTitle": "Transaction Summary", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Transaction Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Platform Identifier" }, { "reportAttributeName": "Platform Name" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Merchant Presenter Identifier" }, { "reportAttributeName": "Merchant Presenter Short Name" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Submission Status" }, { "reportAttributeName": "Submission Date" }, { "alias": "Transaction Count", "reportAttributeName": "Merchant Order Number", "aggregateOperationText": "count" }, { "reportAttributeName": "Merchant Order Number", "alias": "Authorization Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Merchant Action Code Text", "aggregateConditionText": "= 'AUTHORIZATIONS'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Declined Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Declined Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Rejected Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Rejected Transaction Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Cancelled/On-Hold Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Cancelled/On-Hold Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Successful Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Successful Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Presenter Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Merchant Action Code Text", "filterAttributeCode": "NOT IN (\"EXCLUDE FROM REPORTING\")" }, { "reportAttributeName": "Online Submission Indicator", "filterAttributeCode": "IN (\"N\")" }, { "reportAttributeName": "Latest Authorization Indicator", "filterAttributeCode": "=\"TRUE\"" } ] }, { "sectionTitle": "Exception Details", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Exception Details" }, { "reportAttributeName": "Transaction Processing Entity Identifier" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Record Number" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "Exception Description" }, { "alias": "Amount", "reportAttributeName": "Presentment Amount" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Account Number" }, { "reportAttributeName": "Credit Card Expiration Year Month Number" }, { "reportAttributeName": "Action Code Text" }, { "reportAttributeName": "Authorization Date" }, { "reportAttributeName": "Authorization Code" }, { "alias": "Auth Response Code", "reportAttributeName": "PTI Authorization Response Code" }, { "reportAttributeName": "Country Of Issuance" }, { "reportAttributeName": "Merchant Category Code" }, { "reportAttributeName": "Reject Code" }, { "reportAttributeName": "Card Usage Type" } ], "sectionSortOrderList": [ { "reportAttributeName": "Transaction Processing Entity Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Order Number", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Exception Description", "filterAttributeCode": "IN(\"rejected transaction\",\"declined deposit\",\"cancels/onhold\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Exception Details Report", "reportFileName": "Exception Details Report....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Transaction Summary & Exception Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-05-06 11:30:00", "reportingPeriodEndTimestamp": "2024-05-07 02:00:00" } } ``` ## Download sample report - [English sample report](/system/downloads/commerce/reporting/Exception_Details_Preset_Report.csv?type=stream) - [French sample report](/system/downloads/commerce/reporting/Details_de_lexception.csv?type=stream) ## Related [Scheduled and ad hoc report configurations](/docs/commerce/optimization-protection/capabilities/reporting/report-configurations/scheduled-adhoc)