To Provide Access to Segment Values in Accounting Flex field to find-update in R12.2 onwards

   TO Provide Access to find/update Flexfield Segment in R12.2 onwards: From R12.2 above Value set Insert/Update depends on Security access To Insert/Update the Accounting Flex filed segment values we need to provide access for specific user by assigning roles (flexfield value set security) so they can have access to Segment Values form and can … More To Provide Access to Segment Values in Accounting Flex field to find-update in R12.2 onwards

TO ADD SYSTEM ADMINISTRATOR RESPONSIBILITY from backend DB:

Below query can be used to add (any)responsibility from backend database: BEGIN FND_USER_PKG.ADDRESP ( ‘JUNAID’, — Username ‘SYSADMIN’, –application short name ‘SYSTEM_ADMINISTRATOR’, — Responsibility Key ‘STANDARD’, — Security Group Key ‘Sysadmin Responsibility added due to work’, –Description sysdate, –Start date null –End date ); COMMIT; DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line ( … More TO ADD SYSTEM ADMINISTRATOR RESPONSIBILITY from backend DB:

Create-Drop Database Link in Oracle

Step-1: Login to PL/SQL Developer in Host DB where we want to create Database Link and execute below query to create: CREATE  PUBLIC DATABASE LINK ora_std_link CONNECT TO apps IDENTIFIED BY password USING ‘(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ora.oracle.com) (PORT=1521))(CONNECT_DATA= (SERVICE_NAME=ORACLE) (INSTANCE_NAME=ORACLEDEV)))’; NOTE: Apps -> User name of Target/Remote Database Password -> Password for above username of Target/Remote Database … More Create-Drop Database Link in Oracle

How to Enable Personalization link for OAF Pages using Profile

These four profile options can be enabled while working on OAF personalization in apps. To Assign these Profile Options, we need to go to System Administrator or Functional Administrator Responsibility. Navigation: System Administrator -> Profile -> System Functional Administrator -> Core Services -> Profiles Profile Name Profile Value FND: Diagnostics Yes Personalize Self-Service Defn Yes FND: Personalization Region … More How to Enable Personalization link for OAF Pages using Profile