Thursday 25 January 2024

How to resolve issue for BIP RTF template XML tags showing value as

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?> 

Sometime these xml data tags automatically changes to <?ref:xdoXXXX> format when opened in RTF. This is because of fields compatibility (BI Desktop version) with MS Word.


To resolve this issue we need open new Word file and modify Add-on setting for publisher as given below.

1. Navigate to Add-on Publisher -> Options -> Options


2. Change Field Labels from Business View to XML Tag Name.




3. Then in Build Tab select below given option


click on OK. 

After this changes now try to open BIP RTF template again and it will show you now correct XML tag as expected.






Thursday 7 December 2023

How to submit ESS Job request using SoapUI in Oracle Fusion

Submit ESS Job request using SOAP UI using SOAP web service ERP Integration Service

Step1: Navigate to oracle document.

https://docs.oracle.com/en/cloud/saas/financials/23d/oeswf/erpintegrationservice-d16476e420.html#u30243249

 

Step2: Select ERP Integration Service

Step3: Copy Service WSDL URL


Step4 : Replace servername with Fusion ERP URL from Service WSDL URL: https://servername/fscmService/ErpIntegrationService?WSDL

e.g. if your fusion ERP URL is https://fa-makd-saasfademo1.ds-fa.oraclepdemos.com/fscmUI

Then replace server name with fusion URL as given below.

e.g. WSDL URL: https://fa-makd-saasfademo1.ds-fa.oraclepdemos.com/fscmService/ErpIntegrationService?WSDL

Step5: Open SoapUI tool and enter project name and WSDL


Step6: Click on OK button , it will fetch service details 


Step7: Expand ERPINtegrationServiceSoapHttp service and select SubmitESSJobRequest


Step8 : Login to Fusion application and got to Manage Job and schedule from Setup and Maintenance 

Step9: Enter details for Job package name and Job Definition Name 


Step10 : submit SOAP request

Check output


You can see same ESS job request id get submitted in ERP application 




Monday 4 December 2023

How to load GL daily rates using FBDI in oracle cloud ERP

 Step1) Download FBDI file for GL daily rates

https://docs.oracle.com/en/cloud/saas/financials/23b/oefbf/importandcalculatedailyrates-3135.html#u30240265



Download DailyRatesImportTemplate.xlsm file

Step2) Open FBDI file and EDIT as per your requirements.


Step3. Click on Generate Daily Rates button generate zip file


Step4) Login to cloud application and check existing rates for given date.


Step5) Run Load Interface File for Import job in application


Pass parameter for daily rates


Browse zip file from computer and submit Job

It will run below given 4 program one by one automatically.


Once last program import and calculate Rates get successful check latest updated daily rates for given date. FBDI program loaded data successfully in cloud.





Friday 24 November 2023

Integration Style In OIC

 


1) App Driven Orchestration:

Create an integration that uses an event or a business object to trigger the integration. For example, you create an integration with an Oracle RightNow Adapter as a trigger and an Oracle CX Sales and B2B Service Adapter as an invoke. The Oracle RightNow Adapter subscribes to an event from the Oracle RightNow application to trigger the integration. Orchestration integrations include features such as the following:

Switch activities to create multiple routing expressions.

For-each activities for looping over repeating elements.

Assign activities for assigning values to scalar variables.

Ad-hoc mappings on switch branches.

Callback activities (to end a process and respond back to the sender) and end activities (to end a process without responding back to the sender) in asynchronous integrations.

2) Scheduled Orchestration:

Create an integration that uses a schedule to trigger the integration instead of an adapter. For example, you add an initial invoke adapter to read a trigger file and a second FTP adapter to download the file for further processing. After designing this integration, you schedule when to run it.


3) File Transfer:

Create an integration to move files across a network.

4)Basic Routing:

Create an integration with a blank trigger and invoke in which to add your own adapters. You can also create a single routing expression and request and response enrichments, as needed. You cannot create multiple routing expressions. If your integration requires this feature, create an orchestrated integration.


5) Publish to OIC:

Create an integration in which you add a trigger adapter to publish messages to Oracle Integration through a predefined Oracle Integration Messaging invoke. No configuration of the invoke subscriber is required.

The publisher and subscribers participating in this integration style can be activated and deactivated independently of each other.


6) Subscribe to OIC:

Create an integration in which you add an invoke adapter to subscribe to messages from Oracle Integration through an Oracle Integration Messaging trigger. You are prompted to select the publisher to which to subscribe. You must have already created a publisher to which to subscribe. The publisher does not need to be active, but must already be completely configured.

Any business identifiers defined on fields in the published integration are copied to the subscriber. Any changes made to the published integration’s business identifiers after copying are not reflected in the subscriber. The publisher and subscribers participating in this integration style can be activated and deactivated independently of each other.



Fusion OTBI Report Subject Areas for Payables and Receivables

 1) Payables

Payables Invoices- Installments Real time

Payables Invoices- Prepayment Application Real Time

Payables Invoices- Transactions Real time

Payables Invoices- Trial Balance Real time

Payables Invoices- With Holding Real time

Payables Payment-  Disbursement Real Time

Payables Payment- Payments History Real Time

2) Receivables

Receivables- Adjustments Real time

Receivables- Bills Receivables Real Time

Receivables- Credit memo Application Real Time

Receivables- Credit Memo Request Real Time

Receivables- Customer Real Time

Receivables- Miscellenious Receipt Real Time

Receivables- Payments Schedule Real Time

Receivables- Transactions Real Time

Receivables- Receipts Details Real Time

Thursday 23 November 2023

How to unlock as locked Fusion/Cloud user?

 Here are the steps you can follow to find a locked user:


    a. Login to Oracle Fusion Cloud Application as Admin user (must have IT Security Manager job role)

    b. Navigate to Tools > Security Console > Users page

    c. Search for the locked user

    d. Click on the Username or Display Name to get to the User Information page and then click the Edit button

    e. Under Account Information, uncheck the Locked check box

Wednesday 8 November 2023

How to create PGP encryption key in Oracle fusion

 Step1. Login to Oracle cloud application

Navigate to Tools-> Security Console


Select certificate from lefts side menu


Step 2- Click on Generate Button


Step3- Select PGP radio button and enter details


Save and close



click on OK

Step4.  Export both public and private key



Check downloaded public and private key










How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...