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_CREATE_RECEIPTS_ERROR

Object Details

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

Used to store error details during receipt creation

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
BATCH_ID	NUMBER		Unique identifer for the batch
REQUEST_ID	NUMBER		Request id for the concurrent program
CASH_RECEIPT_ID	NUMBER		Cash receipt id of the receipt
RECEIPT_NUMBER	VARCHAR2	(30)	Receipt number of the receipt
RECEIPT_DATE	DATE		Receipt date of the receipt
CUSTOMER_TRX_ID	NUMBER		Customer trx id of the invoice
TRXN_NUMBER	VARCHAR2	(30)	Trx number of the invoice
PAYMENT_SCHEDULE_ID	NUMBER		Payment schedule id of the receipt
APPLIED_PAYMENT_SCHEDULE_ID	NUMBER		Payment schedule id of the invoice
PAYING_CUSTOMER_ID	NUMBER		Paying customer id
PAYING_SITE_USE_ID	NUMBER		Paying site use id
EXCEPTION_CODE	VARCHAR2	(30)	Exception code of the error
ADDITIONAL_MESSAGE	VARCHAR2	(2000)	Additional message
REMIT_BANK_ACCT_USE_ID	NUMBER		Remit bank account use id
LAST_UPDATE_DATE	DATE		Last update date
CREATION_DATE	DATE		Date receipt is created
CREATED_BY	NUMBER		User id who created the receipt
LAST_UPDATE_LOGIN	NUMBER		Date updated lately
PROGRAM_APPLICATION_ID	NUMBER		Program application id
PROGRAM_ID	NUMBER		Program id
PROGRAM_UPDATE_DATE	DATE		Program update date
LAST_UPDATED_BY	NUMBER		User id who updated lately

Query Text

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


SELECT BATCH_ID
,      REQUEST_ID
,      CASH_RECEIPT_ID
,      RECEIPT_NUMBER
,      RECEIPT_DATE
,      CUSTOMER_TRX_ID
,      TRXN_NUMBER
,      PAYMENT_SCHEDULE_ID
,      APPLIED_PAYMENT_SCHEDULE_ID
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      EXCEPTION_CODE
,      ADDITIONAL_MESSAGE
,      REMIT_BANK_ACCT_USE_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATED_BY
FROM AR.AR_CREATE_RECEIPTS_ERROR;

Dependencies

[top of page]

AR.AR_CREATE_RECEIPTS_ERROR does not reference any database object

AR.AR_CREATE_RECEIPTS_ERROR is referenced by following:

AR: AR_CREATE_RECEIPTS_ERROR#