Oracle Could PaaS Integration Cloud Updated UI

 I am going to give you a walkthrough of the new UI (User Interface) that Oracle Integration cloud OIC has incorporated and what new Features are brought with this update.

I Like the new UI as it has been built using Oracle JET and complies to latest UX standards with consistent layout and User interface across the whole Integration Instance.

Updated Menu Structure

The main menu in OIC has been Updated. Now when you click on Integrations a sub-Menu will open displaying links to designer landing pages instead of opening the list of Integrations. The main menu now contains links for the Monitoring and Setting sub-menu. Earlier you had to go into integration then click on back then go to monitoring.

Check Out: New Homepage of Oracle Integration Cloud.

Integrations

1. In the new UI, the Integration menu contains all the designer pages. With the updated Navigation you all the design element in Integration.

2. On the toolbar now the filter icon has been changed and moved to the left, also the Search bar has been replaced with the search Icon.

All the filter options appear on a popup allowing you more options for sorting Integration. By default, the Integration created by the user is displayed which makes it easier to find your integrations and reduces confusion when working in large teams.

To Know More About B2B in OIC

3. The view has been updated Instead of toggle switches now you have buttons that appear only when you hover on an item.

A New Card view has been added in which the teams are displayed in card size rectangles and the buttons are displayed only when you hover over the card.

Check Out: Our blog post on Oracle ERP Cloud Adapter.

Actions

The hamburger icon in the item list is the actions panel, there are two primary actions other are secondary actions/menu items.

Also Read: Our blog post on oracle process cloud service.

Integration Configuration

Inside Action then Configuration you have options to:

• View all dependent resources (connections) used in the integration
• View the usage and status information of a dependent resource (connections)
• Configure dependent resource (connections) and persist the changes
• You can also Perform all the operations during import or after import at a later stage.

Read More: About OIC Notification Activity.

Detail View Section

Then open details button expands an item to view more details. The details section can be opened by the open details icon on the action overlay panel.

Check Out: Our previous blog post on ICS to OIC Migration.

Connection Editor

The connection editor page is used to configure connection properties and security policies. The new UI lets the user to easily configure the endpoint information without needing to open multiple pop-ups to provide required details in the page.

To know more about Oracle API Platform Cloud Service Architecture.

Lookup Editor

Mapping of various values used by different applications are stored in Lookup, so it can be used in the integration for auto mapping.
Navigating across various mapping for a large table is fast using the paging control.

Also Check: Our blog post on Oracle CPQ to Oracle EBS Integration.

Library Editor

Functions are configured in the Library editor page to be used in the orchestration canvas and also to export/import metadata.

In the new UI, the configuration has simplified functions, with just a single click. Users can just select the checkbox next to the functions in the left panel and it automatically gets configured for both Orchestration and XPath types. Users can modify the param types and Save it.

In the new UI on the editor page where all the files/functions of the registered library are exposed in the ‘Functions’ panel.

I hope you find this blog post useful and now are familiar with the UI. If you want to know more about How to Managing & Monitoring Integration Errors in Oracle Integration Cloud (OIC) check our blog.

We Cover Oracle Integration Cloud OIC in our course where you will learn to Provisioning OIC | Connectors/Adapters | REST & SOAP APIs | Customer Case Study | Security | Monitoring Integration.

Apex Report Restriction Based on User level


declare
val varchar2(100);
c1 number:=0;
begin
val := APEX_CUSTOM_AUTH.GET_USERNAME;
select count(*) into c1 from apex_workspace_apex_users where upper(user_name)=upper(val) and user_name!='ADMIN1';
if c1=1 then
return true;
else
return false;
end if;

end;

Non Repeat The Column Record

Example Out Put  :


Receipt Date             Receipt Number    Applied_Amount  Receipt_Amount 

01-Jun-2015              RC-1                       10000                       50000
01-Jun-2015              RC-1                       500                           50000
01-Jun-2015              RC-1                       10000                       50000
01-Jun-2015              RC-1                       10000                       50000

01-Jun-2015              RC-2                       10000                       70000
01-Jun-2015              RC-2                       5005                          70000
01-Jun-2015              RC-2                       10000                       70000
01-Jun-2015              RC-2                       10000                       70000


Script :

(Case When  row_number() over(partition by Receipt_number order by Receipt_number)=1 Then Receipt_number Else '' End )Receipt_number


Actual Output :

01-Jun-2015              RC-1                       10000                       50000
01-Jun-2015                                             500                           50000
01-Jun-2015                                             10000                       50000
01-Jun-2015                                             10000                       50000

01-Jun-2015              RC-2                       10000                       70000
01-Jun-2015                                              5005                          70000
01-Jun-2015                                             10000                       70000
01-Jun-2015                                             10000                       70000

Script For Row Level Record TO Column Level Display

Actual Record :  

    1,  Arun,
    2, Mano
    3, Devaraj

Query For Chaging the Record Into Columsn level:

select
  LISTAGG( DEFAULT_DIST_CCID,',' )  WITHIN GROUP (ORDER BY Invoice_id)
from
  Ap_invoice_Lines_All@Apps_Prod Where Invoice_id=18000

Script Output:

Arun,Mano,Devaraj

AR Interface With Dynamic Loaded in BackEnd.


Function AP_Invoice_Submit
Return Number

Is

PRAGMA AUTONOMOUS_TRANSACTION;

v_request_id NUMBER;

Cursor AP_Invoice
Is

    Select Distinct RESPONSIBILITY_KEY,PROFILE_OPTION_VALUE,A.APPLICATION_ID,RESPONSIBILITY_ID, ORGANIZATION_ID as Org_Id,Source
    From AP_INVOICES_INTERFACE API,
    Apps.Hr_Operating_Units HOU,Fnd_Responsibility_Vl A,fnd_profile_option_values B
    Where  API.OPERATING_UNIT=HOU.NAME
    And A.responsibility_id(+) = B.level_value
    And PROFILE_OPTION_VALUE=To_Char(HOU.ORGANIZATION_ID)
    And RESPONSIBILITY_KEY Like '%PAYA%SUPER USER'
    And Nvl(Status,0)!='PROCESSED';



BEGIN

For i In AP_Invoice
Loop
            Fnd_Global.Apps_Initialize(1110,i.RESPONSIBILITY_ID,i.APPLICATION_ID);
         
            v_request_id := APPS.FND_REQUEST.SUBMIT_REQUEST(
                'SQLAP',
                'APXIIMPT',
                'Payables Open Interface Import',  
                TO_CHAR(SYSDATE,'DD-MON-RR HH24:MI:SS'),
                FALSE,
                i.ORG_ID,
                i.Source,
                NULL,
                NULL,
                NULL,
                NULL,
                NULL,
                'Y',
                NULL,
                NULL,
                NULL,
                NULL,
                NULL,
                NULL     );
           
             
    COMMIT;
   
End Loop;
Return v_request_id;      
END;

AP Interface With Dynamic Loader With Back End


Function AP_Invoice_Submit
Return Number

Is

PRAGMA AUTONOMOUS_TRANSACTION;

v_request_id NUMBER;

Cursor AP_Invoice
Is

    Select Distinct RESPONSIBILITY_KEY,PROFILE_OPTION_VALUE,A.APPLICATION_ID,RESPONSIBILITY_ID, ORGANIZATION_ID as Org_Id,Source
    From AP_INVOICES_INTERFACE API,
    Apps.Hr_Operating_Units HOU,Fnd_Responsibility_Vl A,fnd_profile_option_values B
    Where  API.OPERATING_UNIT=HOU.NAME
    And A.responsibility_id(+) = B.level_value
    And PROFILE_OPTION_VALUE=To_Char(HOU.ORGANIZATION_ID)
    And RESPONSIBILITY_KEY Like '%PAYA%SUPER USER'
    And Nvl(Status,0)!='PROCESSED';



BEGIN

For i In AP_Invoice
Loop
            Fnd_Global.Apps_Initialize(1110,i.RESPONSIBILITY_ID,i.APPLICATION_ID);
       
            v_request_id := APPS.FND_REQUEST.SUBMIT_REQUEST(
                'SQLAP',
                'APXIIMPT',
                'Payables Open Interface Import',
                TO_CHAR(SYSDATE,'DD-MON-RR HH24:MI:SS'),
                FALSE,
                i.ORG_ID,
                i.Source,
                NULL,
                NULL,
                NULL,
                NULL,
                NULL,
                'Y',
                NULL,
                NULL,
                NULL,
                NULL,
                NULL,
                NULL     );
         
             
    COMMIT;
 
End Loop;
Return v_request_id;      
END;

How TO Execute Procedure In Funtion



FUNCTION P_Execute(P_C_Name Varchar2,P_Org_Id Number,P_GC_Name Varchar2,P_Currency_Code Varchar2)
  RETURN Varchar2
  --P_C_NAME Varchar2
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
--    BEGIN
----        P_C_NAME := NULL;

        SOA_REPORT (P_C_Name,P_Org_Id,P_GC_Name,P_Currency_Code);
--    END;
  RETURN P_C_Name;
END;