Bank Statement Reconciliation Exceptions

The Bank Statement Reconciliation Exceptions view object contains information related to reconciliation exceptions, such as exception type, transaction source, reconciliation matching rule, bank statement, or system transaction that originated the exception, and so on.

Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.ReconExceptionExtractionPVO

Primary Keys : ReconExceptionReconExceptionId

Initial Extract Date : ReconExceptionCreationDate

Incremental Extract Date : ReconExceptionLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ReconExceptionCreatedBy	The user who created the reconciliation exception.
ReconExceptionCreationDate	The date and time when the reconciliation exception was created.
ReconExceptionExceptionType	The type of the exception. A list of accepted values is defined in the lookup type CE_RECON_EXCEPTION_TYPE.
ReconExceptionLastUpdateDate	The date and time when the reconciliation exception was last updated.
ReconExceptionLastUpdateLogin	The session login associated with the user who last updated the reconciliation exception.
ReconExceptionLastUpdatedBy	The user who last updated the reconciliation exception.
ReconExceptionObjectVersionNumber	The number of times the reconciliation exception row has been updated.
ReconExceptionReconExceptionId	The unique identifier of the reconciliation exception. This is the primary key of the Bank Statement Reconciliation Exceptions view object.
ReconExceptionReconMatchingRuleId	The identifier of the bank statement reconciliation matching rule. This is a foreign key to the CE_RECON_MATCHING_RULES table.
ReconExceptionReconToleranceRuleId	The identifier of the bank statement reconciliation tolerance rule. This is a foreign key to the CE_RECON_TOLERANCE_RULES table.
ReconExceptionStatementHeaderId	The identifier of the bank statement to which the statement line belongs. This is a foreign key to the CE_STATEMENT_HEADERS table.
ReconExceptionStatementLineId	The identifier of the bank statement line of the possible match pair. This is a foreign key to the CE_STATEMENT_LINES table.
ReconExceptionTransactionId	The identifier of the system transaction. This is a foreign key to the CE_AVAILABLE_TRANSACTIONS_V view.
ReconExceptionTransactionSource	The source of the transaction in the possible match pair. A list of accepted values is defined in the lookup type CE_RECON_SOURCE
ReconExceptionTrxLineId	The supplementary identifier of the system transaction from a source like Oracle Fusion General Ledger that uses composite keys. This is a composite key to the CE_AVAILABLE_TRANSACTIONS_V view.