Search Results put_credentials

Overview

FND_OAM_METALINK_CREDS is an Oracle Application Object Library PL/SQL package, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its sole business function is to manage the storage and retrieval of Oracle MetaLink (now My Oracle Support) account credentials associated with an Oracle E-Business Suite application user. The package persists a user's MetaLink user identifier, password, and e-mail address into a central repository table so that applications and diagnostic utilities can authenticate to MetaLink services on behalf of that user without re-prompting for credentials. The package is classified as an "OTHER" API, meaning it is a utility/support package rather than a public business API, and it is referenced by no other documented packages, which confirms its role as a standalone credential-management helper.

Key Procedures and Functions

• PUT_CREDENTIALS — The procedure most commonly sought via the search term "put_credentials". It stores the supplied MetaLink credentials for a given application user. If a row already exists for the specified applications user name, the procedure updates it; otherwise it inserts a new row. It accepts the applications user name, MetaLink user ID, MetaLink password, and e-mail address as input, and returns an error message and a return code (0 on success, non-zero on error) through OUT NOCOPY parameters.
• GET_CREDENTIALS — Retrieves the stored MetaLink credentials for a given applications user name. The user name is the only input; the MetaLink user ID, password, and e-mail address are returned as OUT NOCOPY parameters, along with the standard error message and return code.
• TEST — A parameterless procedure used to verify the operational status of the package, typically exercised during installation, patching, or diagnostic checks.

Tables Accessed

The package operates against three documented objects referenced through APPS synonyms:

• FND_OAM_METALINK_CRED — The primary credential repository. PUT_CREDENTIALS inserts or updates rows here, and GET_CREDENTIALS reads them back. This is the persistent store linking an FND_USER identity to a MetaLink account.
• FND_USER — The core EBS user table, used to validate or resolve the applications user name that owns the stored credentials.
• UTL_RAW — The Oracle-supplied raw-data utility package, referenced for binary conversion or low-level encoding/decoding operations, consistent with the handling of encrypted or obfuscated password data.

Usage Notes

FND_OAM_METALINK_CREDS is typically invoked from Oracle Applications Manager (OAM) diagnostic and configuration user interfaces where an administrator registers or updates MetaLink credentials for an EBS user, and from background utilities that require authenticated connectivity to MetaLink/My Oracle Support. Because PUT_CREDENTIALS performs an upsert (update-on-existence, otherwise insert), it is idempotent with respect to a given user name, making it safe for repeated invocation during setup or re-registration. Custom code should always inspect the p_retcode output (0 indicates success) and handle p_errmsg for diagnostics, since the procedures suppress exceptions and communicate failure through these OUT parameters. As an "OTHER"-classified internal package with no dependent packages, it should be treated as a support utility rather than a stable public interface; direct calls from customizations should be undertaken with awareness that signatures and behavior may change across patch levels.