eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_AUTOREC_EXCEPTIONS

Object Details

Object Name:	AR_AUTOREC_EXCEPTIONS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_AUTOREC_EXCEPTIONS
Subobject Name:
Status:	VALID

The AR_AUTOREC_EXCEPTIONS table is a temporary table used to store exceptions found by Automatic Receipts and its related programs. These exceptions are part of the output of the Automatic Receipts program.
.
The primary keys for this table are BATCH_ID, REQUEST_ID, PAYMENT_SCHEDULE_ID, and EXCEPTION_CODE.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_AUTOREC_EXCEPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	REQUEST_ID BATCH_ID
AR_AUTOREC_EXCEPTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	BATCH_ID PAYMENT_SCHEDULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Unique identifier of the automatic receipt batch
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PAYMENT_SCHEDULE_ID	NUMBER	(15)		Unique identifier of the invoice's installment being rejected by the Automatic Receipt Creation program
PAYING_CUSTOMER_ID	NUMBER	(15)		The unique identifier of the customer for whom the automatic receipt should have been created
PAYING_SITE_USE_ID	NUMBER	(15)		This column is meaningless unless the payment methods number of receipts rule is Per Site, then this is the site of the automatic receipt
DUE_DATE	DATE			This column is meaningless unless the Number of Receipts Rule is Per Due Date, then this is the maturity date of the automatic receipt.
CUST_BANK_ACCT_ID	NUMBER	(15)		Unique identifier of the customer's bank account from which the money for the automatic receipt is taken
REMIT_BANK_ACCT_ID	NUMBER	(15)		The unique identifier of the remittance bank to which the automatic receipt will be deposited
CUST_MIN_REC_AMOUNT	NUMBER			This is the minimum receipt amount for creating a automatic receipt set at the customer level.
BANK_MIN_REC_AMOUNT	NUMBER			This is the minimum receipt amount for creating an automatic receipt at the remittance bank level.
EXCEPTION_CODE	VARCHAR2	(30)	Yes	This is the error message that tells you why this invoice installment was rejected by the Automatic Receipt Creation program.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ADDITIONAL_MESSAGE	VARCHAR2	(240)		Additional error message text
CASH_RECEIPT_ID	NUMBER	(15)		Identifier of the cash receipt
REMIT_BANK_ACCT_USE_ID	NUMBER	(15)		The unique identifier of the remittance bank account use id to which the automatic receipt will be deposited

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      REQUEST_ID
,      PAYMENT_SCHEDULE_ID
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      DUE_DATE
,      CUST_BANK_ACCT_ID
,      REMIT_BANK_ACCT_ID
,      CUST_MIN_REC_AMOUNT
,      BANK_MIN_REC_AMOUNT
,      EXCEPTION_CODE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATED_BY
,      ADDITIONAL_MESSAGE
,      CASH_RECEIPT_ID
,      REMIT_BANK_ACCT_USE_ID
FROM AR.AR_AUTOREC_EXCEPTIONS;

Dependencies

[top of page]

AR.AR_AUTOREC_EXCEPTIONS does not reference any database object

AR.AR_AUTOREC_EXCEPTIONS is referenced by following:

APPS: AR_AUTOREC_EXCEPTIONS