Search Results fnd_applications

Overview

The APPS.BIS_CUSTOM_RELATED_LINKS_MLS package is a private PL/SQL package within the Oracle EBS Business Intelligence System (BIS) product family. Its primary business function is to maintain the multilingual (MLS) seed data and translations associated with the BIS_CUSTOM_RELATED_LINKS_TL table, which stores the descriptive text for custom related links presented to users in Oracle EBS dashboards and related-links regions. The package header comment explicitly states that the module is private and intended for populating BIS_CUSTOM_RELATED_LINKS_TL and for managing the relationship between that translation table and the FND_APPLICATIONS table.

The _MLS suffix denotes that this is a multilingual seed package, a standard Oracle Applications design pattern used to register translated seed data across installed languages. The package was created on 24-NOV-2004 by Seema Rao and carries the source control header BISPCRLS.pls 120.0, reflecting a long-standing, stable component that has remained largely unchanged across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The documented package exposes a single public procedure:

• Add_Language — This procedure drives the multilingual data seeding process. Its purpose is to populate or refresh the language-specific rows in BIS_CUSTOM_RELATED_LINKS_TL when a new language is installed or activated in the EBS instance. It is the standard entry point used by the Oracle Applications language installation and patching utilities to synchronize the seeded translation content so that custom related links appear correctly in the user's installed language. No parameter list is documented in the ETRM metadata; the procedure operates on the ambient language context established by the calling framework.

No other procedures or functions are documented for this package. The package is intentionally minimal, exposing only the seeding interface required by the multilingual data management infrastructure.

Tables Accessed

• BIS_CUSTOM_RELATED_LINKS_TL — The primary target of the package. This translation table stores the language-specific display names and descriptions for each custom related link defined in the base table. Add_Language inserts or updates rows here for the language being installed.
• BIS_CUSTOM_RELATED_LINKS — The base (language-independent) table holding the link definitions. The translation rows in _TL reference this base table, and the package reads it to determine which link records require translated entries.
• FND_LANGUAGES — The Oracle Applications installed-languages table. The package consults FND_LANGUAGES to identify active languages and to enforce the documented relationship with FND_APPLICATIONS, ensuring translations are seeded only for languages enabled in the instance.

The ETRM metadata notes these tables are accessed via APPS synonyms, consistent with standard EBS coding conventions.

Usage Notes

This package is not intended for direct invocation by end users, forms, or concurrent programs. It is a private MLS seed package executed by the Oracle Applications language installation and patching utilities — specifically the standard seed-data loader framework that processes _MLS packages when a language is added or when translation seed data is refreshed. Because the header is marked "Private," custom code should not depend on Add_Language; Oracle reserves the right to modify its behavior.

The package is referenced by zero other packages per the ETRM metadata, confirming its role as a leaf-level seeding utility rather than a reusable API. Administrators encountering issues with missing or incorrect related-link translations in a non-English language typically address them by re-running the language installation utility that invokes this package, rather than by calling it directly. Given its stability across 12.1.1 and 12.2.2, it remains a low-risk component in upgrade and patching scenarios.