The ADFdi add-in for Excel runs on Microsoft Windows inside Microsoft Excel

Where to download The ADFdi add-in for Excel runs on Microsoft Windows inside Microsoft Excel

https://<hostname>:<portnumber> /fscmUI/adfdiRemoteServlet?excel-addin-installer-all-users

Object Extension Types in Oracle HCM Cloud

 _B - base table. It holds the main details of the object in question and it implies that there is also a _TL table for it. You'd never find a _B table without a _TL table. the primary key is the id column.

_TL - translatable table. Holds the translated names/descriptions for base objects. will have one row per installed language. linked to the base table by the _id column. Doesn't always imply that there is a _B as its base data could also be in a _F table or a table without postfix. The primary key is the id column plus the language column.

_F - date effective table. Tends to exist only in HR and it holds objects that are date effective. It means the primary key is the combination of the ID column, effective start date and effective end date. there is only 1 row per ID for any date, but you can have multiple rows for the same id over time. Some _F columns come with a matching _TL column, too.

_VL - translatable view. It's not a table, but the view that represents the join of the base table and the TL table using the user's session language. You can assume that almost all _TL tables come paired with a _VL view.

_M - multiple changes per date table. Like a _F table, but it allows rows to start and end on the same day. There is only one such table per_all_assignments_m, and it has additionally the effective_sequence in the primary key.

_DN - denormalised table: usually just a simplification of another table that holds hierarchies or trees of some kind. The denormalised tables are populated by ESS processes and hold the flattened hierarchy that has direct links between all nodes and their distance. Those are used e.g. for security profiles based on the manager hierarchy.

source: oracle

APEX_JSON.WRITE Tips

• For null case

Use: APEX_JSON.write('P_INVOICE_TRACKING', '', true);

Result: "P_INVOICE_TRACKING":null 

• For Escaping "& /" character 

Use: APEX_JSON.write_raw('P_INVOICE_NUMBER', '"'||r_header.sppd_code||'"');

Result: "P_INVOICE_NUMBER":"0134/XYZ/084/RS/2021" 

How to get SOURCE SYSTEM OWNER list

 Here how to get SOURCE SYSTEM OWNER on HDL process

1. Go to Setup and Maintenance



2. Search "Manage Common Lookup"





3. Search "HRC_SOURCE_SYSTEM_OWNER"





4. By Query

SELECT *
FROM fnd_lookup_values
WHERE lookup_type = 'HRC_SOURCE_SYSTEM_OWNER'

 

Oracle APEX - Using Outlook 365 as outbound email

Here the steps to use SMTP Outlook 365 as email outbond from oracle APEX

• Setup SMTP outlook 365 relay register your APEX host and get the smtp server name and port. how to to it check this youtube
• Create oracle wallet on DBaaS/DB to *.outlook.com
• Set Instance Setting > Email values on Workspace Internal

• Test it using apex_email

  procedure send_email_test(
    p_from    varchar2 default 'info@yourdomain.com'
  , p_to      varchar2
  , p_subject varchar2 default 'Email test'
  )
  as
    l_body      clob;  
  begin
  
    l_body := 'Thank you for your interest in the APEX_MAIL package.'||utl_tcp.crlf;
    l_body := l_body ||'  Sincerely,'||utl_tcp.crlf;
    l_body := l_body ||'  The APEX Dev Team'||utl_tcp.crlf;
    apex_mail.send(
        p_to       => p_to,   -- change to your email address
        p_from     => p_from, -- change to a real senders email address
        p_body     => l_body,
        p_subj     => p_subject
    );
        APEX_MAIL.PUSH_QUEUE; 
  end send_email_test;

Thats it and good luck :D

Install/Upgrade Oracle APEX 18.1 on Oracle Database Cloud Service (DBaaS)

Assumption

• You can connect to DBaaS through Putty and FileZilla
• Oracle Database 12c Release 2 install on plugable db: PDB1
• You have the required version of the cloud tooling

Steps

1. Log in to the compute node as the oracle user.
2. Log in to SQL Plus as the SYS user.
3. Upload Oracle Application Express 18.1 to the compute node: /home/oracle/tmp
4. Go to /home/oracle/tmp directory unzip to /u01/app/oracle/product/apex/18.1.0.00.45 directory:

unzip apex_18.1_en.zip
mv /home/oracle/tmp/apex/ /u01/app/oracle/product/apex/18.1.0.00.45/

5. Final directory preview

6. Go to /u01/app/oracle/product/apex/18.1.0.00.45/ directory
7. Make sure you can connect using ORDS_PUBLIC_USER, by default will have same password like sys,system on DBaaS creation.

sqlplus /nolog 
SQL> CONNECT ORDS_PUBLIC_USER 
Password: 
Connected. 
SQL>

8. Intall APEX 18.1
• Log in to SQL Plus as the SYS user and install

ALTER SESSION SET CONTAINER=PDB1; 
@dbcsins.sql SYSAUX SYSAUX TEMP /i/18.1.0.00.45/ <ORDS_PUBLIC_USER_PASSWORD> 

• Check the installation went fine by issuing the following command (Using the same sqlplus session or at lease issuing the statement to the same container you installed APEX into)



SELECT VERSION, STATUS, SCHEMA FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';

9. Create a link to the APEX images in ORDS' docroot by executing the below command as the oracle user



ln -sfn /u01/app/oracle/product/apex/18.1.0.00.45/images/ /u01/app/oracle/product/ords/conf/ords/standalone/doc_root/i/18.1.0.00.45 



10. Configure Oracle Application Express by executing the Oracle REST Data Services (ORDS) assistant:


11. Log in to the compute node as the opc user
12. Start a root-user shell:

$ sudo -s 

13. Change to the ords directory:

# cd /var/opt/oracle/ocde/assistants/ords

14. Execute the ORDS assistant:

# ./ords -out="/var/opt/oracle/ocde/res/ords.out" -ords_action="configure_apex"

15. Restart ORDS:

# /etc/init.d/ords restart

16. Exit the root-user shell and log out of the compute node.

Reference

• Upgrading from Oracle Application Express 5.1.0 or 5.1.3 to 5.1.4 for Oracle Database 12c and Oracle Database 18c
• SR support

Implementing PDF.js on Oracle APEX

Here step by step preparation :

• Install PDF.js under image prefix apex

• Prepare Download page helper
  • Page with alias : DOWNLOAD_PDF
  • Process : before header

  declare
    r_data EMP_PDF%rowtype;
  BEGIN
    select * into r_data
      from emp_pdf
     where empno = :P4_EMPNO;
      sys.htp.init;
      sys.owa_util.mime_header( r_data.mimetype, FALSE);
      sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( r_data.pdf_data ));
      sys.htp.p('Content-Disposition: inline; filename='||r_data.filename );
      -- tell the browser to cache for one hour, adjust as necessary
      sys.htp.p('Cache-Control: max-age=3600');
      sys.owa_util.http_header_close;
      
      sys.wpg_docload.download_file(r_data.pdf_data);
      apex_application.stop_apex_engine;
  exception when others then
      sys.htp.prn('error: '||sqlerrm);
      apex_application.stop_apex_engine;
  END;
  

Case 1 : On form

• Create Static Region

• Preview

Case 2 : On Tabular form

• Install plugin : Execute PL/SQL Code and Return Content
• Preview