Stack Overflow
Stack Overflow

Questions tagged [oracle-fusion-apps]

Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation.

59 questions
3
votes
2 answers

How to query for Inactive Employees using BI Publisher in Oracle Fusion?

I'm new to BI Publisher and I'm using it through Oracle Fusion Applications. I am trying to make a report relating to the Inactive Employees in an organization. However I am unable to figure out how to query for an inactive or terminated employee. I…
George Santhosh
  • 119
  • 2
  • 13
2
votes
0 answers

How to get minimum records from the Oracle fusion run report API

Requirement: I am using the runReport API from the Oracle fusion report service to get the data by passing the parameter values as arguments. It generally takes more time for larger reports. So is there any way to get the total row count or else…
Venkat
  • 2,549
  • 2
  • 28
  • 61
2
votes
2 answers

Using pattern matching to outer join tables in Oracle SQL

I'm creating a DataModel in Oracle Fusion Financials to match parties together, from supplier use and customer use. These parties have a code which is registered in their name. Searching for the table names on Google will find the schemas (eg.…
MaartenB
  • 31
  • 4
2
votes
2 answers

Limiting lines per page in BI Publisher

I'm using RTF template to create a BI report. I need to limit the number of rows into 3 records on the 1st page only. The remaining records/rows will continue to fill the next pages. I'm also required to print the page total. I used the code below…
Liezel Francisco
  • 45
  • 2
  • 7
2
votes
0 answers

OTBI Time and Labour- Missing Time Card Entry

In Oracle Fusion HCM, using the OTBI tool I'm trying to figure out how to display the missing time entries for an employee. I'm still new at this and there is such less documentation, so if anyone has any experience on this it would be of great…
emeraldgreen
  • 37
  • 2
  • 7
1
vote
1 answer

Insert Excel rows for each x in adjacent country columns to prepare Oracle Calendar Event Coverage uploadsheet

I am uploading Calendar Events in Oracle Fusion. The events went fine, but I am now working on assigning the coverage which is set by country in our setup. My coverage source data (this is sample of it), delivered by a colleagues is structured…
MaartenB
  • 31
  • 4
1
vote
1 answer

Custom Notification in Oracle Fusion

i wanted to know if there is anyway to create custom Notification / bell alerts on Oracle fusion that can be triggered via Oracle OIC . Basically i want to send notification from Oracle OIC to Oracle fusion. A normal bell notification is what I'm…
Adarsh Narayan
  • 11
  • 1
1
vote
1 answer

How to generate JWT token using Rest API for Oracle fusion ERP Cloud in Java

In Oracle ERP cloud we can login via Rest API using JWT authentication i.e. Bearer Token in PostMan. So to generate this JWT token through browser I don't need much effort I just need hit below in my browser : https:///fscmRestApi/tokenrelay I…
Suraj Kudale
  • 39
  • 8
1
vote
2 answers

How to return the difference between 2 strings using Oracle SQL only

I have 2 strings for example: 'Source:Siebel; Name:Mary Jane; Gender:F; Age:24; N;' 'Source:Siebel; Name:Marie; Gender:F; Age:24; N;' The result I need is: Name:Mary Jane; Name:Marie; Most likely I need to reverse below code with cte1 as ( …
kathnisss
  • 15
  • 4
1
vote
2 answers

Where is Oracle Fusion Assets REST APIs?

From my understanding, Oracle Fusion apps on the cloud and Oracle Cloud SaaS Services are interchangeable. I was trying to locate the Oracle Fusion Assets REST APIs which should be under Oracle Financials Cloud APIs but I wasn't able to. Can someone…
Bassel Shmali
  • 207
  • 2
  • 15
1
vote
1 answer

Are there any Logic App connectors for Oracle Fusion ERP?

Are there any Logic App connectors for Oracle Fusion ERP? I've checked the Microsoft list and can only find the Oracle Database connector, which seems amazing. Alternatively, has one one created a custom connector?
SteveC
  • 15,808
  • 23
  • 102
  • 173
1
vote
0 answers

Import error 'FailedCheck' using SOAPUI for ERP Integration Service

I have tried automated importing of AP Invoices by using the ERP Integration Service from SOAPUI, but I am getting the 'FailedCheck' error whenever I am running a request. I have filled the necessary information, such as the base64 encoding of the…
riv5181
  • 11
  • 2
1
vote
1 answer

http listener is not running on port 7001

I am using oracle forms 11g with oracle database 11g. While running forms it's been showing an error that http listener is not running on port 7001. How can I resolve this? Error no is FRM-10142.
user3668036
  • 25
  • 1
  • 11
1
vote
1 answer

Is there any open-source 3rd party MDS (Meta Data Service) engine for Oracle ADF?

Oracle has its own MDS Engine for Commercial ADF which support personalizations and customizations. ADF Essential which is free doesn't has this ability for personalizations and customizations. Is there any other way to achieve same free version of…
Ritesh Lad
  • 11
  • 1
1
vote
0 answers

Webutil works fine when I run it from Forms Builder, but when I install it on our server, it doesn't work

I have used webutil functionality to upload and download files. It works fine when I run it from Oracle Forms Builder. But when I install it on our server I get the following alert when I click on a button to choose a…
Dax
  • 438
  • 1
  • 8
  • 29
1
2 3 4