Posts

Upload Document and Download Document In Directory

Image
 1. Create Directory in Database and provide grant to directory >>> create directory dir_xxapex as '/apexshare'; >>> grant read,write on directory  dir_xxapex    to xx_apex; Also Provide folder permission to pubic 2. Create Table   CREATE TABLE xxapex_documents (     do_doc_no            NUMBER,     do_doc_reftable      VARCHAR2(250),     do_doc_refid         NUMBER,     do_doc_file          BLOB,     do_file_name         VARCHAR2(250),     do_mime_type         VARCHAR2(250),     do_created_by        VARCHAR2(255),     do_created_date      TIMESTAMP,     do_last_updated_by   VARCHAR2(255),     do_last_updated_date TIMESTAMP ) 3.Create Report with Form pag...
Post a Comment
Read more

Oracle Apex and EBS Integration

Image
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         ...
Post a Comment
Read more