Optimization Protection

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.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
    "reportHeader": "EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
    "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<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.