WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed. 1) Created by 2) Creation date 3) Last _updated_by 4) […]
Here there are few key FND tables that we use in our AOL queries. FND_APPLICATION: Stores applications registered with Oracle Application Object Library.FND_APPLICATION_TL: Stores translated information about all the applications registered with Oracle Application Object Library.FND_APP_SERVERS: This table will track the servers used by the E-Business Suite system.FND_ATTACHED_DOCUMENTS: Stores information relating a document to an […]
The below query will fetch the responsibilities assigned to a particular user. SELECT fu.user_id, fu.user_name, fr.responsibility_name, fr.description, fa.application_nameFROM fnd_user fu, fnd_user_resp_groups g, fnd_application_tl fa, fnd_responsibility_tl frWHERE g.user_id(+) = fu.user_id AND g.responsibility_application_id = fa.application_id AND fa.application_id = fr.application_id AND g.responsibility_id = fr.responsibility_id AND fu.user_name =UPPER(‘User_Name‘);
Responsibilities:A responsibility is a level of authority in Oracle Applications that lets users access only those Oracle Applications functions and data appropriate to their roles in an organization.Request Group:It is a collection of concurrent Programs. It is used to request programs from the responsibility.Data Group: It is a collection of Modules used to integrate one […]
What is attachment in oracle application?The attachments feature in oracle application enables users to link unstructured data, such as images, word-processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations as operation instructions.Where to find an attachment?There is an attachment icon in the oracle […]
Recent Comments