Search Results notify_on_pp_error

Overview

FND_CONC_PP_TEMPLATES_VL is a multilingual (VL) reporting view in the APPS schema belonging to the FND — Application Object Library product. It exposes the header-level definition of Oracle E-Business Suite concurrent program print/post-processing templates, combining the language-independent template attributes with their translated name and description. The view is documented as retrofitted, meaning it was introduced or aligned as part of the ETRM documentation effort rather than being a newly designed object in a specific release. It is valid and shipped identically in Oracle EBS 12.1.1 and 12.2.2, with the same ownership (APPS) and the same referenced base synonyms.

The view is the recommended access point for reporting and integration queries that need both the technical definition of a print template and its user-facing, language-specific labels. Because it filters translations on the session language, it returns exactly one row per template for the current user environment, which makes it suitable for concurrent processing and BI Publisher style extracts.

Underlying Base Objects

The view text joins two documented base objects, reached through APPS synonyms:

• FND_CONC_PP_TEMPLATES — the language-independent (base) table holding the template definition, including the NOTIFY_ON_PP_ERROR flag and the standard WHO audit columns.
• FND_CONC_PP_TEMPLATES_TL — the translation table holding USER_TEMPLATE_NAME and DESCRIPTION per language.

The join predicate is B.TEMPLATE_ID = T.TEMPLATE_ID AND T.LANGUAGE = USERENV('LANG'), so the view always presents the current session language translation joined to the base row. Columns are drawn from both objects, with the base table aliased B and the translation table aliased T.

Key Columns

• ROW_ID — the ROWID of the base table row, exposed for tools that require a row identifier.
• TEMPLATE_ID — the primary key linking the base and translation records.
• TEMPLATE_NAME — the internal, language-independent template name.
• NOTIFY_ON_PP_ERROR — the flag controlling whether the concurrent manager notifies the request submitter when a post-processing (print) error occurs. This is the column most often sought under the term "notify_on_pp_error".
• USER_TEMPLATE_NAME — the translated, user-facing template name.
• DESCRIPTION — the translated description of the template.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns inherited from the base table.

Common Use Cases and Queries

Typical uses include auditing which templates will trigger error notifications, populating reports that display template names in the user's language, and troubleshooting post-processing failures where no notification was raised. A representative query listing all templates with their notification setting follows:

• SELECT template_id, template_name, user_template_name, notify_on_pp_error, description FROM fnd_conc_pp_templates_vl ORDER BY user_template_name;

To isolate only templates that notify on post-processing error:

• SELECT template_name, user_template_name FROM fnd_conc_pp_templates_vl WHERE notify_on_pp_error = 'Y';

Because the view enforces USERENV('LANG'), callers should set the session language (NLS_LANG or FND_GLOBAL) before querying to guarantee the desired translation is returned.