-
Parameters in Layout If Statement Not Working
So I have a multi-select parameter that returns null when All is selected. I am printing my parameters to my RTF layout. I have tried: <?if@notEmpty:{CERT_NAME_P}?><?CERT_NAME_P?><?else?>All<?end?> <?if@inlist:{CERT_NAME_P}?><?CERT_NAME_P?><?else?>All<?end?> I get an error like this most of the time <Line 42, Column 72>:…
-
OTBI Analysis Report to get Aligned goal name
We are creating a OTBI Report With subject area Goal Status overtime real time and Goal Alignments Real time. We want to get the Aligned goal name but we are not able to get the Aligned goal name , we are only getting the aligned Field which gives Y or N . Any field in OTBI subject area to get the name of the aligned Goal…
-
How to determine field = division of two other fields, called from different templates?
Hi, We have a BI publisher report, with .rtf template. Any idea how we can divide two fields that we get by calling templates: ex: for one field: <?call-template:prj_accr1?><?format-number:xdoxslt:get_variable($_XDOCTX, ‘prj_accr1’);'999G999G990D00'?> and for the second field:…
-
not able to divide two columns RTF Template
Content we are trying to divide two columns but its not working.we are using the below code. <?CURR_TOT_GAURENTEED_COMP?>DIV <?NEW_TOT_GAURENTEED_COMP?>
-
HTML Report returns results, PDF report does not return results
Hey Everyone, I am a newbie but am trying to get up to speed. So I built a data model and report using an RTF template. When I view the results in HTML it looks fine. I can export to Excel and it looks good as well. However, when I try to export to PDF I get some problems I'd like to resolve: When I click the small PDF…
-
Need to create one user that can have only access to OTBI.
I need to create one user that have access to OBTI only and will be able to create analysis for Project related subject area i.e. for Project Costing and Project Billing.
-
Logical SQL report does not display values from one subject area for a user
We have built a report on "Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time" and "Procurement - Purchasing Real Time", to display project details against the POs. But, for some users the values are blank. On checking documentation, 'Receipt Accounting Transaction Analysis Duty' and 'Purchase Order…
-
Budget date in budgetary control balances screen vary in "budget_date" column in XCC_TR_LINES table
Summary: We wanted to display the budget date column in custom report where we have found discrepancies in fusion screen and "BUDGET_DATE" column in XCC_TR_LINES table, especially in the case of liquidated transactions. Looks the table showing PR budget dated "26-12-2024" not the actual budget date. If So, please help on…
-
Repeat Column Headers in BI Publisher Excel Templates
Summary Repeat Column Headers in BI Publisher Excel Templates Content Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when the data split into multiple sheets. Any help/ pointer is appreciated. Is it a limitation of the BI publisher excel templates. Thanks, Dhanuka Version 20B
-
Hi i need to run a report but i can't get the issue
In Procurement. I'm trying to run this report (That says "Do you want to approve?") and the YES (highlighted) doesn't work at all, this is the console error: Do i need any role or privilege or is it a development issue? here's the entire error line if it can be useful: <env:Envelope…
-
duplicate values in OTBI Excel output
In the OTBI report results tab showing only one record where as in the export showing expected number of rows along with duplicate rows. Please advise any property settings missed in my case.
-
Hi, i can't use the new redwood interface with every user
I need a user to use the Purchase Requisition (New), it used to work until yesterday, what's the problem? Do i need to set it up again using Manage Administrator Profile Values? if yes, which role/code do i need? Thanks Giorgia
-
How to Call ff_exec.run_formula in Oracle BI Publisher Report
Summary: Hello Oracle Experts, I am working on Oracle Fusion Cloud BI Publisher (BIP) report and need to call the ff_exec.run_formula function to retrieve Fast Formula results within my data model. However, I am unsure about the correct way to invoke this function in BIP and whether there are any prerequisites or…
-
Does enabling DFF in OTBI make it available in PVO in BICC ?
If we enable DFF in OTBI, does it get reflected in BICC PVOs? For e.g. if we enable DFF at Customer level, does the corresponding PVO in BICC get updated automatically with that column or do we need to create a new/custom PVO in BICC to extract that DFF column data?
-
How to combine Purchasing Real Time and Requisitions Real Time subject areas in a single analysis?
Is there a way to combine both subject areas? I need to create a report to analyze PO data and Requisition data. My goal is to find compute the time it takes from when a requisition line gets approved and the time the purchase order gets approved (PO Open Date).
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter Values
Issue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle's standard reports, the "BIP Report Audit Trail," located in the Audit Reports section. The Client specific requirement is to filter the report data based…
-
Salary Basis Join
I am building a OTBI report that requires the 'Benefits - Enrollment Real Time' and the 'Compensation - Salary Details Real Time' subject areas. I need to include 'Salary Basis' from the 'Compensation - Salary Details Real Time' subject area. The only place this is available is 'Compensation - Salary Details Real Time' >…
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A
Summary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Navigation Tools - Reports & Analytics - Audit Reports Version (include the version…
-
Dynamic Link to Oracle Integration Cloud
Hi, We create a custom app tile in spring board and calling OIC visual builder application. As you can see below screen, the static URL is point to PROD and TEST. If you do a P2T, the PROD URL will be copy to TEST. And we need to change it every time after P2T as post cloning activity. Is there a way to set this link as…
-
How we de output Header on CSV even when there is no data with SOAP API?
Hello, We have a report that we schedule through SOAP API payload, and the requirement is to have the header on the CSV output even when there is no data. Currently, on our report object, we disabled the REPUBLISHING/Save data xml option to achieve the requirement. We are able to have the headers only even when there is no…
-
How to fetch Recipient details from Leave Donation Real Time Subject Area
i was trying to fetch the absence donation Recipient details like (First name Last name of Recipient and Alias details ) i was not able to drag and drop those columns. It says "There was problem retrieving those response data" Note - User has all the necessary roles add to his account Please find the error screenshot
-
OTBI - Analysis Dashboard - Payables Invoices security context by BU
Hello, we are creating a report using OTBI for payables we have a question related the security access. Our customer want to query invoices depends of user, if the user has for example access to five BUs he-she can only consult invoices for these fives BUs. So, we dont find how to filter per role and security context BU,…
-
How to only show workers who have multiple managers
My org is switching to Oracle, and most of my experience in reporting is in Tableau. I'm struggling on how to filter to only show workers who have more than one manager. I tried count distinct of worker number, but that just returned a 1 in each row, I'm assuming because we only have 1 of each worker number. How can I get…
-
How to fetch the Contribution requested by employee (Cash disbursement) in OTBI
Can someone help to fetch the details of the hours which are raised for cash disbursement in OTBI
-
Procurement Spend analysis Report/Dashboard for Top level Executives
Our executives looking for for the real-time report/dashboard that will show spend analysis for all associates under their hierarchy (irrespective if transaction required executive approval or not).
-
what standard reports available which print Fixed Asset DFF Attributes
We would like to know what oracle standard reports available which display Fixed asset DFF attributes especially for Asset category and transaction DFF details. we have verified few key reports such as Asset Additions and Asset Listing reports but neither of those reports are printing the DFF details. Thank you for the…
-
OTBI - Subject Area Overview & Standard KPI Calculation Guidelines
Hello everyone, I wanted to ask if there is a way to generate a list in BI Publisher (Cloud) that provides an overview of the available Subject Areas along with their respective fields. Alternatively, is there another method to display this information efficiently? Additionally, I would like to know if there is a guideline…
-
How to restrict data access in OTBI reports: buyer can only retrieve their own PO
Hi Experts, (Please advise the category of posting this inquiry, I am choosing OTBI as a start, if it is more suitable to Purchasing category then please help to migrate this post. Thank you.) I got an Analysis using subject area "Procurement - Purchasing Real Time" which is allowing users with Buyer role to retrieve the…
-
Database Resource Condition session variable
Summary: Hi. We are trying to create new Database Resource Conditions to give visibility to users of specific data, right now we use the following variable: HRC_SESSION_UTIL.GET_USER_PERSONID We would like to know where to find further options, for example we know its possible to get PartyId with…
-
I have enabled descriptive flexfield for expenses based on expense type selection
I have enabled descriptive flexfield for expenses based on expense type selection for 2 expense types to display the same value set(free text) to capture values captured in another system. I am seeing 2 values for the same field in the subject work area of expense transactions realtime report. . If I add 1 field, i can…
