Search Results startup_command

Overview

AS_WORD_PROCESSORS is a multi-org secured view in the Oracle E-Business Suite Sales Foundation (AS) module. It presents configuration data for word processors integrated with the Oracle Sales and Marketing letter generation and merge process. In releases 12.1.1 and 12.2.2 the view functions as the runtime-facing layer over the underlying AS_WORD_PROCESSORS_ALL table, applying the organization-level security predicate that restricts rows according to the organization context established in the user session.

The view exposes definitions for each registered word processor, including its identifier, display name, executable path, startup command, letter and merge-file storage locations, and the delimiters used to build merge data streams. It further indicates the delivery channels supported by each processor through the FAX_FLAG, EMAIL_FLAG, and PRINT_FLAG columns. Because word processor setup is organization-specific, the view plays a direct role in determining which merge engines, letter templates, and output mechanisms are available to a given operating unit during sales letter production and correspondence generation.

In the documented ETRM metadata the object is recorded as Not implemented in this database, and no referencing base objects are documented beyond the view definition itself. This status reflects a configuration state rather than a defect; the view remains part of the delivered AS schema and is populated only when word processor records exist.

Underlying Base Objects

The view is defined over AS_WORD_PROCESSORS_ALL, which stores all organization rows, including those with a null ORG_ID representing shared or global definitions. The view text applies the standard multi-org filter: it compares the ORG_ID on each row against the organization identifier derived from the USERENV('CLIENT_INFO') session value, substituting -99 for rows whose ORG_ID is null or whose client information is not set. This predicate mirrors the mechanism used throughout Sales Foundation multi-org views.

Because word processors are configuration entities rather than transactional records, the view is not decomposed further into foundation or transaction tables; it presents the _ALL table directly with row-level organization filtering applied.

Key Columns

• WORD_PROCESSOR_ID — Primary identifier for the word processor definition.
• NAME and WORD_PROCESSOR_NAME — User-facing and technical names of the processor.
• ENABLED_FLAG — Indicates whether the processor is active for selection.
• PATH and STARTUP_COMMAND — Filesystem location and invocation command for the executable.
• LETTER_LOCATION_PATH / SERVER_LETTER_LOC_PATH — Client and server paths for letter templates.
• MERGE_FILE_LOCATION_PATH / SERVER_MERGE_FILE_LOC_PATH — Client and server paths for generated merge files.
• FAX_FLAG, EMAIL_FLAG, PRINT_FLAG — Supported output channels.
• PRE_FIELD_DELIMITER, POST_FIELD_DELIMITER, FIELD_SEPARATOR, PRE_RECORD_DELIMITER, POST_RECORD_DELIMITER — Tokenization controls for merge data.
• ORG_ID — Owning organization; null denotes a shared row.
• ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — Descriptive flexfield storage.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard audit columns.

Common Use Cases and Queries

Typical usage includes verifying available merge engines for an operating unit, troubleshooting letter generation failures, and auditing output-channel configuration.

List enabled processors visible to the current organization:

SELECT word_processor_id, name, path, fax_flag, email_flag, print_flag
FROM   as_word_processors
WHERE  enabled_flag = 'Y';

Retrieve path and delimiter settings for a specific processor:

SELECT name, letter_location_path, server_letter_loc_path,
       merge_file_location_path, field_separator
FROM   as_word_processors
WHERE  word_processor_id = :p_id;

Identify shared versus organization-specific definitions:

SELECT name, org_id
FROM   as_word_processors
ORDER  BY org_id NULLS FIRST, name;