Oracle Apex and EBS Integration
Configuration from the Oracle APEX Perspective Create Application in Workspace. Create Application Items for Storing EBS Session Values. Navigate to Authentication Schemes, Create Custom Authentication with 'No Authentication,' and Set it as the Current Authentication Scheme. Navigate to Authorization Schemes and Create a New Custom Authorization Scheme Set to 'Once per Session. Here first need to create XXAPX_APEX_GLOBAL_PKG and related procedures in APPS scheme or we can create it in custom scheme. Navigate to Security Attributes and Implement the Following Changes. Choose Your Custom Authentication Scheme as the Selected Authentication Scheme. In the Database Session section, Insert the Following Initialization PL/SQL Code. BEGIN APPS.XXAPX_APEX_GLOBAL_PKG.APPS_INITIALIZE( p_user_id ...