Enabling trace in DBMS OUTPUT for HR APIs

While doing conversion,interface or any extension in HR sometime we have to debug the API to analyze the transaction flow.Below code snippet will be useful for such debugging (only for HR APIs).The below debug message we can view in the editor console itself.

Steps

1) Enable the DBMS OUTPUT.
2) EXEC DBMS_OUTPUT.ENABLE(1000000);
3) DECLARE
      ---
   BEGIN
      HR_UTILITY.SET_TRACE_OPTIONS('TRACE_DEST:DBMS_OUTPUT');
      HR_UTILITY.TRACE_ON(NULL, 'XX_TRACE') ;

      ----
      HR_UTILITY.TRACE_OFF;
   END;

Oracle ERP Cloud Financials Seeded Data Extract

Oracle ERP Cloud Financials Seeded Data Extract 

The Financials Data Extract empowers business enterprises with the capability to extract financials data from the Oracle ERP Cloud to seamlessly integrate with on-premise systems,

legacy systems, or other cloud systems. Oracle ERP cloud provide lots of

Seeded data extracts.

The data extracts are provided in a XML or CSV format for direct automated

integration with other systems.  One very common business scenario in practice is

to leverage the extract capabilities to directly import the data files extracted from

the Oracle ERP Cloud into legacy or third-party partner systems.  In turn, those

legacy or third-party partner systems will perform very specialized niche business

functions based on unique legal or industry requirements such as generating

statutorily prescribed tax return forms for electronic filing with

local country tax authorities.

An outbound extract process can be launched programmatically by using the ERP Integration Service. .Oracle ERP Cloud has many Seeded data extract and can be

Use as it to fulfill data requirements in on-premise or 3rd party solutions.

Customization : User can create a custom report in BI Publisher (BIP) or clone one of

the seeded extracts and customize it based on their requirements.

The framework of Financial Data Extracts further simplifies the invocation of

custom BIP reports through ERP integration services by eliminating the requirement

to create a custom ESS job for each BIP report

Oracle Integration cloud E-Business Suite Adapter to connect to EBS

Oracle Integration cloud E-Business Suite Adapter to connect to EBS

Oracle Integration cloud uses Oracle E-Business Suite Adapter to connect to EBS -

The Oracle E-Business Suite Adapter is one of many predefined adapters included with Oracle Integration Cloud Service allowing you to securely connect and use Oracle E-Business Suite

services in integrations in Oracle Integration Cloud Service. It not only provides the connectivity between Oracle E-Business Suite and other cloud-based applications, but also

significantly simplifies the complexity of typical integration experiences.

There are other way to connect, but using ebs adapter and ISG means we have lot less to write ( I mean custom code), and we can use lot of code that exits in EBS , and as stated in documentations use of E-Business Suite Adapter really simplifies integration. ( as shown below)

The supported interface types for integrations in Oracle Integration Cloud Service through the Oracle E-Business Suite Adapter are

1. PL/SQL API
2. Concurrent Program
3. Business Event
4. XML Gateway Message

Other advantages are