-
Need solution to create an OTBI report to find AHCS Subledger Entry's Line level information
HI All, I am working on AHCS/FAH module and need to create an OTBI report to fetch the Line level details for a transaction loaded to Oracle using AHCS template. The data which is visible from Review Subledger Entries—> View transaction—> Line details, should be fetched.The report should have the option to populate the…
-
Where to find 'Payroll Term ID'
Hi, I'm currently engaging in a project for Payrolling Benefits. Sometimes employees leave unexpectedly and we need to find a way of updating Oracle for BenefitsTaxedViaPayrollYTD which appears in the FPS and then send an adjustment FPS. My approach has been to enter an Adjust Individual Balances but this requires a…
-
Problem opening Workbook OAC
Good morning, we're fancing an issue with a user: when the user tries to load a workbook in OAC he doesn't get an error but the page continues to load. Activating the Network monitoring on the browser we get a message as "Refuse to execute the script xxxx because its MIME tyoe ('application/jason') is not executable and…
-
How to create chart of account value sets in OTBI report?
How to create chart of account value sets in OTBI report?
-
OTBI Session Variable
Hello, I have a dashboard where I'm trying to create an instance of it for when an end user opens it the name column auto populates with their name and only their name so that they can't try and search for someone else. I know the other option would be apply the session variable to the reports within the dashboard. This is…
-
OTBI Subject Area for Total Compensation Statement
Is there a subject area for the Total Compensation Statement specifically in regards of pulling the feedback from the participants?
-
OBIEE Data Model Parameters
I have transitioned an analysis to a data model using the OBIEE connection. It's been requested to add parameters to the data model and report. I'm used to building them in any other connections, but the OBIEE connection is a little different. I'm running into an issue where the parameter is accepted, and I tried setting…
-
Can Count of Aligned Goals be altered to only bring in aligned goals for a specific Goal Plan Name?
We noticed the system delivered field "Count of Aligned Goals" (Workforce Goals - Goal Alignments Real Time"."- Goal Alignment"."Count of Aligned Goals") provides a cumulative count of all aligned goals for the user. We've tried filtering it by Goal Plan Name ("Workforce Goals - Goal Status Overview Real Time"."Performance…
-
We have an Existing BIP Report we need to fit this in OTBI Analysis
-
How to fetch and display employee details in rows based on manager hierarchy in OTBI reports.
There is a requirement to fetch and display below mentioned fields in an OTBI report based on manager hierarchy. Business Unit Cost Center Cost Center Manager Name Title Job Name Department Job Level A 10 X Employee a d g 1 A 10 X Level 1 Manager b e h 2 A 10 X Level 2 Manager c f i 3 What are the steps to fetch this Name…
-
Hide the factory catalog Objects in OTBI
Dear All, We would like to Hide the factory catalog which comes as part of Cloud ERP Implementation. We have implemented these modules i.e. Finance,SCM,PPM. In this regard would like to hide the other work areas like CRM,Marketing,Sales,Subsrciption Subject Areas in OTBI. We did follow the steps documented in this…
-
BICC frequency recommendation
Is BICC recommended approach for frequent scheduling? PFB the details: What sort of data is being extracted? — Subscription and Assets Data What is the data volume that you are expecting? — 300 records per day How frequently we want the extraction? — 30 minutes Where are we going to extract the data? — UCM server
-
TRIM Trailing Not Working
Hello: I have a column that I want to remove all characters after { and it isn't removing any characters. It is not erroring out, but shows the entire column. Here is my formula: TRIM(TRAILING '{' FROM "Opportunity"."Opportunity Name") What am I doing wrong? Thanks for any insight.
-
How to hide parameters from data model when the report is embedded by link in a dashboard?
Hi, I have a report that's embedded with link in a dashboard. I wanted to use dashboard prompt for the parameters. How can I hide the parameters from the data model without deleting it from the query? Regards, Ivony
-
Is there a way to deploy OTBI Reports (Data Models & Report Templates) from a GIT repo via CI/CD
Hello, We are developing custom reports for Oracle Financials . This includes the report data models and report templates. They are stored in a git based version control environment. We want to move away from the manual download and update of data models and report templates. Are there any APIs that can be used to put the…
-
OTBI Analysis Seniority Dates pulled into 1 row
Please, I need help I will like to create an Analysis into a table that shows respective dates of under each respective Seniority Date Rule column. Currently the analysis shows Seniority Date Rules and Seniority Dates in multiple rows for each Person The columns should be Column 1) - Person Number Column 2) - HR Status…
-
unsupported report object's type - [catalog]
Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?WSDL To upload the report into BI Pulisher we are leveraging the operation uploadReportObject of ExternalReportWSSService When we are…
-
dashboard link expir
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): AdaptHealth, Inc Description (Required): Dashboard bookmark error - The Bookmark link has expired or is invalid. We have created Dashboards and they were working fine. Suddenly starting…
-
Agent Condition Evaluates to False Despite Analysis Returning Rows
Hi everyone, I'm setting up an agent in Oracle BI with a condition based on an analysis. The configuration is as follows: Create condition based on: Analysis Condition Data: (Path to the analysis) True If Row Count: is greater than 0 The issue: ✅ When I run the analysis independently, it returns rows. ❌ However, when I…
-
Why are there no subject areas dedicated to Contracts in Project Financial Management?
With Fusion, it is easy to report on projects, whether they are in the early stages of planning or in execution. However, there are no subject areas that allow reporting of the contracts (customer contracts) associated with the projects that are setup. Till a contract is invoiced, all you can report is basic contract…
-
Procurement - Buyer Productivity dashboard is not returning data
Procurement dashboard "/shared/Procurement/Dashboards/Procurement/Buyer Productivity" is not returning any data when we are passing the value for buyer parameter. Although, when running it without passing buyer parameter, it's working. Interesting thing is, when running it with the XYZ buyer which is returned by the…
-
Published Report Schedule - showing message if attachment has nothing
Summary If the published report attachment has no data, can we put that in the body of the message? Content Hello, For a personal BIP report schedule, if the attachment has no data on it, is there a way to call that out in the body of the email message to the user? We find that users are opening reports that have no data…
-
Need BICC PVO details for OSS_PRODUCTS_XM
Can latest database lineage mapping be shared for CX. Unable to find PVO for OSS_PRODUCTS_XM.
-
How can I find all reports using the same BI Publisher Data Model
Summary I need to be able to identify all the reports that are using a Data Model before I make changes to the DM. Content Bi Publisher Data Model has been created, I now need to know all the reports that are using this DM. Is this possible? Version Oracle BI EE 11.1.1.9.0
-
Trying to find Default Expense Account discerption
Hello everyone, I am working in BI Report and I am trying to find Default Expense Account discerption. I found the code but I could not find the discretions. the code found it in this table gl_code_combinations. the path to get those detail from fusion My Client Group > Person Management > Search for Employee > Employment…
-
How to have Action Link on Totals but not on detail rows
So I have an OTBI Analysis which has navigation link on certain columns using the standard interactivability functionality on the column properties. I have enabled these action links at Total Level, but need to remove the functionality at row (non-total) level. I tried conditional display with things like…
-
Subledger OTBI Analysis - Report ran for one transaction number spinning until time-out
The issue with this report is with applying a filter to this field: "Subledger Accounting - Journals Real Time"."Journal Details"."Transaction Number". This is not a new report and we've just started having issues with that field post 24D. I've tested it under 3 scenarios in the edit screens/running the report with the…
-
OTBI report for absence with Accrual, Adjustment and carryover details of an employee.
I would like to create an OTBI report to display Accrual, Adjustment and carryover details of an employee. We have updated the carryover and adjustments through data load templates with type as ADJOTH and COVR.
-
I am trying to get first submission date
Hello All, I am working on dashboard and I am trying to find the first submission date for the supplier registration. as you can see in the following picture. Procurement -> Supplier -> Task ->Manage Supplier Registration Request I am using subject area called "Supplier Registration - Real Time" I tried to take the min for…
-
Oracle Cloud Fusion Multi Select Parameters Errors Out When two or more items are selected
I'm using Oracle Cloud Fusion to build a data model to feed a report. I'm trying to create a multi-select parameter. When making the parameter on my data model choose the option selecting all will return NULL. I do this because when I select return all values every option shows up on my report parameters making it…
