-
OTBI Column Formula - TO derive values based on a report prompt/parameter
Hi Experts, We have created an OTBI analysis to get data for the ranking of suppliers based on their total invoice value.Further, this should be able to run based on a invoice date range as well. Please advice as to how we can have a column formula mentioning that the invoice values should be grouped based on the suppliers…
-
Adding Event Triggers on RA_INTERFACE_LINES_ALL data creation
Hi, I'm looking to intercept the creation of a record from the supply chain to account receivables (DOO source). Specifically, I need to trigger an action when the record has been created in the RA_INTERFACE_LINES_ALL table, which is a standard table in Oracle Fusion. Thank you Eros
-
OTBI_PIVOT_INDEX
Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek
-
Storing Copies of Emails sent from Eloqua
We have a requirement where in, when sending out the email communication using Eloqua, we want an 'actual copy' of the email to be automatically sent to a pre-defined address. This would a 'CC' functionality within the emails that are automatically pre-populated with a defined address and not just the Eloqua sent report.…
-
Is it possible to combine Primary and Secondary Ledger in One FRS Design?
-
Selecting Previous Thursday/Preceding Friday, regardless of run date
I'm trying to set an analysis that defaults to run for the previous payweek (which for us is Friday to Thursday), no matter what day of the week it's run on. So for instance if run today, Tuesday 4/16, one formula would select for the previous Thurday (4/11), and another formula would select the Friday before that (4/5).…
-
Build a OTBI analysis using 2 subject areas but results is giving blank table.
I am trying to build a OTBI analysis in oracle fusion application using two subject areas ' Risk Management Cloud - Advanced Financial Controls Real Time ' and ' User System Usage ' but after selecting the required columns from the both the subject area the table showing in the results tab is coming blank i.e. without any…
-
How to transpose data from rows to columns in OTBI
Hello Expert, I want to show row data as column I have two types. Personnel No and Account Name, and I want to show these two values as column and identifier as data like. If you have an idea how I can achieve these outcomes, please do let me know. Thank you.
-
In Trial Balance Report in FRS,is it possible to see the Drill Ending Balance of Secondary Ledger?
-
Maximum report data size for offline (scheduled) reports value change
Hi Team, Greetings! How do we change the value for the parameter "Maximum report data size for offline (scheduled) reports value change" as highlighted in below screenshot for BIP report on XMLPServer page under Administration :- Thanks Parag
-
Unable to get header column in csv output file if there is no data ?
We have requirement where we need to move the file to server . when there is no data in the file. we are unable to getting header column ?
-
How to Stop Duplication of Billed Amount in Analysis
I am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense report level. In the example below, the transaction was coded to two different cost centers, so there are two separate lines for the transaction on my report. However,…
-
How to Connect Item/Category to Task/Project via DataModel
We are in the process up updating a report, one that provides Item and Category descriptions, in order to try and find the associated Task Number as could be found on a Requisitions Disbursement Line. We have been able to identify a fair number of tables around the item and category, linking these together. And we can find…
-
Supplier DFF creation using REST APIs as a part of Supplier creation Endpoint
Hi Team, Business wanted to create Supplier DFFs along with the Supplier creation endpoint that is /fscmRestApi/resources/11.13.18.05/suppliers. Business is using a library that is being developed internally by another team and it doesn't (yet) support…
-
what is the issue of below logic in FAW?
cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <>…
-
OTBI Analysis to get Working Days count and total hours spent by employee in given date Range
Dear Team, I was trying create a Dashboard with multiple Analysis and Graphs. One requirement is to get Working Days count in the given Date Range and Total Work Hours spent by Employee in the same date range. I am unable to identify any dimention representing working day or not in the Time.Calendar date or any other…
-
Saved Customization report being deleted in OTBI
User cases: There are multiple users encountering deleted saved customization report in OTBI and it happens intermittently. Description of need: To have an audit log on the saved customization report on who created and when was the customization updated Or suggest how can we investigate this further. I have checked the…
-
SA- Payroll Element Entries Real Time - Filtering Displayed Input Value using Input Value name
Hello all, Trying to create an allowance report using the SA - Payroll Element Entries Real Time, I have this so far I would like to remove the 'Input Value Name' column, rename the 1st 'Displayed Input Value' as 'Allowance Justification' and the 2nd 'Displayed Input Value' column to 'Monthly Amount' - so all data is…
-
Payroll Legal Entity Registration Unit Field Navigation
Hello everyone, I have a requirement that needs to be pulled into the report, and I want to map it first in the UI/Front End. Can anyone provide where to find this fields in the UI/Front End?
-
Issue when subsequently calculating from formulas containing FILTER function
Background I have a single Oracle DB table set up as a basic Subject Area, comprising of one row per person per calendar month, showing data as of the last day of the calendar month (known as PERIOD_END). The table is called HCM_PERSON_SNAPSHOTS_DW. I have an Analysis that pulls out two separate months that will always be…
-
How can we confirm impacted reports before removing the subject area access from some roles
There are many reports are developed using some subject area and saved in different folders. Can i check how many reports would be impacted before removing the access? For example, I want to check how many reports are using "Workforce Management - Grade Rate Real Time" subject area.
-
Supplier DFF creation using REST APIs as a part of Supplier creation Endpoint
Hi Team, Business wanted to create Supplier DFFs along with the Supplier creation endpoint that is /fscmRestApi/resources/11.13.18.05/suppliers. Business is using a library that is being developed internally by another team and it doesn't (yet) support the /fscmRestApi/resources/11.13.18.05/suppliers/{SupplierId}/child/DFF…
-
Oracle BI Publisher Silent Installation
The Official installer for the BIPublisherDesktop is provided in .exe format. The official command that is being used is BIPublisher64.exe /S /v/qn The installation failed with the following error code: [ResponseResult] ResultCode=-3 The installation is successful with the UI Enabled. -- To make it work I extracted the…
-
Interface file error:Value larger than specified precision allowed for this column. Job is aborting
-
Due Date field from Receivables Transaction Real Time is not displaying any data/value
Even though we tried with the most basic fields but the Due Date value is not getting displayed (Screenshot 1). Only when we are adding due date field from Receivables: Payment Schedules Real Time then it is showing the value but after adding a few more fields, it is getting defaulted to all zeros 0/0/00 (Screenshot 2).…
-
How to source: Profile Item Id in OTBI to populate spreadsheet loader
I'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualifications screen. I manage to build most of it only the spreadsheet loader doesnt seem to like the Profile Item ID I specify (and this field in the loader…
-
OTBI Performance tiles for non measure fields
Hi, We would like to create a performance tile in OTBI analysis that will count distinct SR references that were opened in the last 2 days. Meaning, we want to use a dimension for calculation and a measure. I can't "pull" the relevant field into the function dialog. How can this be done? Thank you
-
Embed Hyperlink on Fusion UI to OTBI analysis with parameters
HI, I want to embed a Hyperlink on my Fusion UI to an OTBI analysis with parameters. Thus: I have added a Hyperlink Component on Fusion UI and gave destination path to an OTBI analysis with two parameters. I am able to open the OTBI analysis but parameters are not working. Can someone inform the exact way to construct URL:…
-
Implement a dynamic default value for a DFF field based on another DFF
Can anyone help with a SQL query - To implement a dynamic default value for a DFF field based on another DFF field in edit mode, ensuring that values captured in Task 1 of the checklist are visible in Task 2 of the same checklist. This process utilizes a configurable form to capture the details. DFF 1st
-
Embedding OTBI Report Directly in HCM without Page Composer or Page Integration
Hi there, I'm wondering if there are other ways to embed reports or include links to reports directly in HCM without using Page Composer or Page Integration tools. I saw this post and document that is specific to the Compensation pages where it is possible to use Rick Text Editor : via Report Link to add links to reports…
