Search Results get_oid_users

Overview

DOM_SECURITY_PVT is a private PL/SQL package in the APPS schema that provides APIs for resolving document security mappings based on Oracle E-Business Suite foundation (FND) data security. The package belongs to the Document Management (DOM) product family and is classified as a PVT object in the ETRM repository, meaning it is intended for internal invocation by other Oracle EBS components rather than as a public integration interface. Its core responsibility is to translate EBS user names into the corresponding OID (Oracle Internet Directory) identity values, allowing document security rules to be applied consistently across the EBS and OID layers.

The package header carries a revision marker dated 2006, confirming that it predates and remains stable through the 12.1.1 and 12.2.2 releases. It exposes exactly two documented entry points: the function GET_OID_USER and the procedure GET_OID_USERS.

Key Procedures and Functions

• GET_OID_USER — A function that accepts an FND user name and returns the corresponding OID user value. It is the single-user resolution path used when document security must be evaluated for one specific user name.
• GET_OID_USERS — A procedure that performs bulk resolution of user names into OID user names. It takes the incoming list of user names and returns the mapped OID user name list through an output parameter, using a NOCOPY hint for efficiency. This entry point suits set-based processing where many users must be resolved in one call rather than iterating over GET_OID_USER.

No other public subprograms are documented for this package. Parameter names and types for GET_OID_USERS follow the DOM_USER_NAMES_ARRAY collection type defined within the DOM product.

Tables Accessed

The package accesses the following tables through APPS synonyms:

• FND_USER — Read to obtain the base EBS user records whose names are supplied as input and to associate those names with the security identifier used in downstream mapping logic.
• PLITBLM — The FND/PL/SQL index-by table storage used to hold the working collections during processing, in particular the user name arrays passed into and returned from GET_OID_USERS.

These accesses are read-oriented. The package does not create or maintain persistent security mappings of its own; it derives OID identities from the existing FND data security configuration.

Usage Notes

Because the package is classified PVT and the ETRM metadata shows zero packages referencing it, DOM_SECURITY_PVT is not a supported extension point. It is invoked internally by Document Management security processing to align document access rules with FND data security assignments and OID user identities.

Typical invocation occurs when document security is evaluated — for example, when a user opens or queries a document and the system must confirm which OID user maps to the authenticated EBS user. The single-value GET_OID_USER is used for individual lookups, while GET_OID_USERS is used when a batch of users must be resolved at once, such as when building a security list for a set of documents.

Custom code should not call this package directly. Developers requiring user-to-OID resolution in a supported manner should use the public Document Management or FND security APIs, since the signature and behavior of a PVT package may change between releases without notice. Any dependency on DOM_SECURITY_PVT should be treated as unsupported and subject to breakage during patching or upgrade.