Search from 700 + Posts

Mar 6, 2019

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;

Feb 3, 2019

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

Nov 17, 2018

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