Search Results resp_synch

Overview

FND_RESPONSIBILITY_PKG is the public table-handler package for the FND_RESPONSIBILITY entity in Oracle E-Business Suite. Its header comment identifies it as the "Table Handler to insert or update data in FND_RESPONSIBILITY table," with a public scope, ownership under the FND product, and an active lifecycle. Because responsibilities define the combination of an application, menu, request group, and data group that a user is granted, this package sits at the center of EBS function security and access provisioning. It is classified as an OTHER API within the ETRM documentation, meaning it is not a full business-object API but rather a set of multipurpose DML and propagation utilities that other packages and setup tools rely upon.

Key Procedures and Functions

The package exposes eleven documented procedures. INSERT_ROW, UPDATE_ROW, and DELETE_ROW provide the core create, modify, and remove operations against the responsibility definition, maintaining the Who columns and row locking semantics expected of a table handler. LOCK_ROW supports optimistic concurrency by verifying that a responsibility row has not been changed since it was queried. TRANSLATE_ROW and ADD_LANGUAGE handle the multilingual dimension of responsibility names and descriptions stored in the translation table. LOAD_ROW is the standard loader used when moving responsibility definitions between environments, supporting the upload of a complete row from a seed or migration source. RESP_SYNCH is the procedure most directly associated with the "resp_synch" search term; it synchronizes responsibility-related data, ensuring that dependent or denormalized structures remain consistent with the master responsibility record. Together these procedures cover definition, translation, migration, and synchronization of responsibilities.

Tables Accessed

The package operates on the FND_RESPONSIBILITY base table and its translated counterpart FND_RESPONSIBILITY_TL, and reads the secure views FND_RESPONSIBILITY_S. It references FND_APPLICATION to resolve the owning application and the data group and request group application identifiers. Data group membership is validated through FND_DATA_GROUPS and FND_DATA_GROUP_UNITS, while request group assignments are validated against FND_REQUEST_GROUPS and FND_REQUEST_GROUPS_S. Language handling relies on FND_LANGUAGES. WF_PARAMETER_LIST_T is referenced in connection with workflow parameter list validation, and DUAL is used for single-row lookups and defaults. These references explain why RESP_SYNCH has broad dependencies: a responsibility is only valid when its application, menu, data group, and request group all resolve correctly.

Usage Notes

FND_RESPONSIBILITY_PKG is typically invoked indirectly. The System Administrator responsibility form, the user and responsibility definition screens, and the standard loader utilities call these procedures rather than end users calling them directly. LOAD_ROW and ADD_LANGUAGE are commonly used during environment cloning and multilingual setup. RESP_SYNCH is invoked when responsibility definitions must be re-aligned, for example after data group or request group changes. Because the package is documented as a public table handler and is referenced by two other packages, custom code should call these procedures rather than issuing direct DML against FND_RESPONSIBILITY, thereby preserving row locking, Who column maintenance, and translation consistency across Oracle EBS 12.1.1 and 12.2.2.