Search Results external_reference6




Overview
Explore in AI Chat

Overview

ECE_ADVO_DETAILS_V is a private, active database view owned by the APPS schema within the Oracle E-Business Suite e-Commerce Gateway (EC) product. The ETRM registry lists its display name as "Application Advice Details View" and categorizes it under the business entity EC_APPLICATION. Its stated purpose, drawn directly from the repository metadata, is to extract advice details for the outbound Application Advice (824/APERAK) transaction.

In EDI terms, the Application Advice transaction (X12 824 or EDIFACT APERAK) communicates the acceptance, rejection, or processing status of a previously received business document back to the trading partner that sent it. ECE_ADVO_DETAILS_V exposes the line-level detail records that accompany each advice header, giving integrators and reporting developers a stable, read-oriented projection of the underlying advice detail data. Because the view is scoped private, it is intended for internal use by e-Commerce Gateway concurrent programs, extract logic, and downstream reporting rather than as a general-purpose public interface.

Underlying Base Objects

The view is defined over a single documented base object: the synonym ECE_ADVO_DETAILS, which resolves to the advice details table in the same EC schema family. The view statement is a direct column projection with no joins, filters, or aggregations:

Because the definition performs no transformation, the view behaves as a thin, read-only layer over the base table. Row cardinality and column semantics are therefore identical to ECE_ADVO_DETAILS. Clients should expect a one-to-many relationship between the advice header and this detail view, with ADVICE_HEADER_ID acting as the foreign key linking each detail row back to its parent header record.

Key Columns

  • ADVICE_DETAIL_ID — Primary key of the detail row; uniquely identifies each advice line.
  • ADVICE_HEADER_ID — Foreign key to the parent application advice header, joining detail rows to the transaction at large.
  • ADVO_DATE_TIME — Date and time associated with the advice detail, typically reflecting when the acknowledgement status was recorded.
  • ADVO_STATUS_CODE — The advice status conveyed for that line, such as acceptance or rejection.
  • EXTERNAL_REFERENCE1-6 / INTERNAL_REFERENCE1-6 — Twelve generic reference attributes used to carry identifiers from the source document and the internal system respectively.
  • ADVO_MESSAGE_CODE / ADVO_MESSAGE_DESC — Coded and descriptive message text explaining the advice outcome.
  • ADVO_DATA_BAD / ADVO_DATA_GOOD — Flags or payload fields indicating which portion of the incoming data failed validation and which passed.

Common Use Cases and Queries

Typical scenarios include auditing outbound 824/APERAK generation, troubleshooting rejected interface data, and building operational reports over advice history. Because the view is a straight projection, queries are straightforward. To retrieve all detail lines for a given header:

SELECT ADVICE_DETAIL_ID, ADVO_STATUS_CODE, ADVO_MESSAGE_CODE, ADVO_MESSAGE_DESC FROM APPS.ECE_ADVO_DETAILS_V WHERE ADVICE_HEADER_ID = :p_header_id ORDER BY ADVICE_DETAIL_ID;

To identify failed advice lines within a date window:

SELECT ADVICE_DETAIL_ID, ADVICE_HEADER_ID, ADVO_DATE_TIME, ADVO_DATA_BAD FROM APPS.ECE_ADVO_DETAILS_V WHERE ADVO_STATUS_CODE = 'ERROR' AND ADVO_DATE_TIME >= :p_from_date AND ADVO_DATE_TIME < :p_to_date;

To inspect reference identifiers captured from the trading partner document:

SELECT ADVICE_HEADER_ID, EXTERNAL_REFERENCE1, INTERNAL_REFERENCE1, ADVO_MESSAGE_DESC FROM APPS.ECE_ADVO_DETAILS_V WHERE EXTERNAL_REFERENCE1 = :p_po_number;

Given the private scope, consumers should treat the view as read-only and reference it only from supported reporting or gateway integration code.

  • View: ECE_ADVO_DETAILS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_ADVO_DETAILS_V,  object_name:ECE_ADVO_DETAILS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts advice detailsfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Details View@rep:category BUSINESS_ENTITY EC_APPLICATION ,  implementation_dba_data: APPS.ECE_ADVO_DETAILS_V , 

  • View: ECE_ADVO_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_ADVO_DETAILS_V,  object_name:ECE_ADVO_DETAILS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts advice detailsfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Details View@rep:category BUSINESS_ENTITY EC_APPLICATION ,  implementation_dba_data: APPS.ECE_ADVO_DETAILS_V , 

  • View: ECE_ADVO_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_ADVO_HEADERS_V,  object_name:ECE_ADVO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A ,  implementation_dba_data: APPS.ECE_ADVO_HEADERS_V , 

  • View: ECE_ADVO_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:EC.ECE_ADVO_HEADERS_V,  object_name:ECE_ADVO_HEADERS_V,  status:VALID,  product: EC - e-Commerce Gateway ,  description: This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A ,  implementation_dba_data: APPS.ECE_ADVO_HEADERS_V ,