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: EC.ECE_ADVO_DETAILS

Object Details

Object Name:	ECE_ADVO_DETAILS
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_ADVO_DETAILS
Subobject Name:
Status:	VALID

ECE_ADVO_DETAILS is used with ECE_ADVO_HEADERS to store transaction
status data reported by Oracle Payables and Oracle Purchasing for the
following inbound EDI transactions: Invoice (810/INVOIC), Ship Notice/
Manifest (856/DESADV), and Shipment and Billing Notice (857).

Included in this table is data regarding the status of an inbound
transaction, the date the error was reported, the error message code,
and the corresponding error message text. This table is designed to
support EDI transactions in future product releases.

For Release 11i, ECE_ADVO_DETAILS is populated by the following
application open interfaces:
{{"bul:1"}}Payables Open Interface Import in Oracle Payables for
all inbound Invoice (810/INVOIC) errors
{{"bul:1"}}Receiving Open Interface in Oracle Purchasing for all
inbound Ship Notice/Manifest (856/DESADV) errors
{{"bul:1"}}Receiving Open Interface in Oracle Purchasing for all
inbound Shipment and Billing Notice (857) errors.
{{"bodytext"}}ADVICE_DETAIL_ID is the unique system-generated primary
key that is invisible to the user. ADVICE_HEADER_ID is the foreign
key to ECE_ADVO_HEADERS.

Each ECE_ADVO_DETAILS row is associated with one row in
ECE_ADVO_HEADERS.

There is a one to many relationship between ECE_ADVO_HEADERS and
ECE_ADVO_DETAILS.

EXTERNAL_REFERENCE (1-6) and INTERNAL_REFERENCE (1-6) each represents
up to six key values to uniquely identify the EDI document.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_ADVO_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADVICE_DETAIL_ID
ECE_ADVO_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADVICE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ADVICE_DETAIL_ID	NUMBER		Yes	Advice Detail ID
ADVICE_HEADER_ID	NUMBER			Advice Header ID
ADVO_DATE_TIME	DATE			Advice Date/Time
ADVO_STATUS_CODE	VARCHAR2	(30)		Advice Status
EXTERNAL_REFERENCE1	VARCHAR2	(80)		Advice External Reference 1
EXTERNAL_REFERENCE2	VARCHAR2	(80)		Advice External Reference 2
EXTERNAL_REFERENCE3	VARCHAR2	(80)		Advice External Reference 3
EXTERNAL_REFERENCE4	VARCHAR2	(80)		Advice External Reference 4
EXTERNAL_REFERENCE5	VARCHAR2	(80)		Advice External Reference 5
EXTERNAL_REFERENCE6	VARCHAR2	(80)		Advice External Reference 6
INTERNAL_REFERENCE1	VARCHAR2	(80)		Advice Internal Reference 1
INTERNAL_REFERENCE2	VARCHAR2	(80)		Advice Internal Reference 2
INTERNAL_REFERENCE3	VARCHAR2	(80)		Advice Internal Reference 3
INTERNAL_REFERENCE4	VARCHAR2	(80)		Advice Internal Reference 4
INTERNAL_REFERENCE5	VARCHAR2	(80)		Advice Internal Reference 5
INTERNAL_REFERENCE6	VARCHAR2	(80)		Advice Internal Reference 6
ADVO_MESSAGE_CODE	VARCHAR2	(30)		Advice Message Code
ADVO_MESSAGE_DESC	VARCHAR2	(240)		Advice Message Description
ADVO_DATA_BAD	VARCHAR2	(240)		Advice Data - Bad
ADVO_DATA_GOOD	VARCHAR2	(240)		Advice Data - Good
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
SECURITY_GROUP_ID	NUMBER

Query Text

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


SELECT ADVICE_DETAIL_ID
,      ADVICE_HEADER_ID
,      ADVO_DATE_TIME
,      ADVO_STATUS_CODE
,      EXTERNAL_REFERENCE1
,      EXTERNAL_REFERENCE2
,      EXTERNAL_REFERENCE3
,      EXTERNAL_REFERENCE4
,      EXTERNAL_REFERENCE5
,      EXTERNAL_REFERENCE6
,      INTERNAL_REFERENCE1
,      INTERNAL_REFERENCE2
,      INTERNAL_REFERENCE3
,      INTERNAL_REFERENCE4
,      INTERNAL_REFERENCE5
,      INTERNAL_REFERENCE6
,      ADVO_MESSAGE_CODE
,      ADVO_MESSAGE_DESC
,      ADVO_DATA_BAD
,      ADVO_DATA_GOOD
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM EC.ECE_ADVO_DETAILS;

Dependencies

[top of page]

EC.ECE_ADVO_DETAILS does not reference any database object

EC.ECE_ADVO_DETAILS is referenced by following:

APPS: ECE_ADVO_DETAILS