-
What is the use of FlexFields in Oracle BIP
Hello Expert, I'm learning BIP, and I want to learn how to use Flexfield in an Oracle BIP parameter. Can anyone explain end to end with an example.
-
BIP Keep rows grouped together so they don't break between pages
We have a custom PO BIP report and each record (PO line) of the PO is comprised of three rows within a table structure (for-each repeating element). The issue we're facing is that at the bottom of each page part of the line record is getting broken to the next page. The screenshot below is an example of our PO output in…
-
Connecting to ATP db datgabase from BI Report
Hi Team, I want to fetch data from fscm data source table and join with ATP db table in BIP Data Model .Can we do that and how can we do that .
-
Query to find partners channel rebate program
Currently we are using oracle fusion 25C (11.13.25.07.0).What is the query to get partners chrm rebate programs.we need to get it from zpm_ tables .And through accruals table since we need to get partner's chrm rebate program to check eligibility for accruals
-
Oracle quote table in fusion 25d
Currently we are using oracle fusion 25C (11.13.25.07.0).in which table we can find quote id,quote number and otehr quote details .How this can be linked to partner or order details. I have done researchstill not able to find the table. Please help on this
-
Issue with OTBI Report Access for Non-Administrator Users
Dear All, I have successfully created an OTBI report as an administrator using the subject area "Payables Invoices - Installments Real Time", and the report is working fine. However, when a non-administrator user runs the report, they receive the following message: "No Results The specified criteria didn't result in any…
-
How to fix inconsistent positions of column?
Hello, I have an odd problem with my report. When the 'activity description' column is at the end, additional columns are showing at the right. When it is placed before any column, there is no additional fields at the right. How can I fix it? Because the activity description should be placed at the end of the report.…
-
Dependent parameters are not showing LOV'S when new custom ESS job created by copying standard ESS
Hi All, We have made customizations to the standard report and are currently attempting to create a new custom ESS job by duplicating the standard ESS job. The functionality of dependent parameters is not working as expected in the custom report when it is copied from a standard report. The dependent parameters are…
-
How do I convert comma separated values to columns in OTBI Report
Hi Team, How do I convert comma separated values to columns in OTBI Report. For eg- We have created a multiple select choice list field and data is showing in comma separated values in a row. We need to convert it into columns in OTBI report.
-
Recommended frequency to extract the active primary keys/application data
We are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics (one time full load followed by incremental loads). Noticed that BICC Application Data Extracts only captures updated and new records, but doesn't capture deletes. We figured that Active Primary key extracts, will provide…
-
HCM - Calculate average number of goals per employee
Hello, What would be the best way to Calculate average number of assigned performance goals per employee with breakdown per department? Formula needed is = Total count of goals / Total count of employees (per department) Thank you!
-
Oracle Catalog Manager Download
Could anyone please provide URL to downloading catalog manager? I have request to pull all reports using X column and found through other community posts that catalog manager is tool for the job. I referred to linked community posts but URL in there for catalog manager no longer works.…
-
OBIEE - Creating Agent from Analysis with "Is Prompted" fields - returning 0 rows.
Hi, First time post here with hopefully a simple question. I have created an analysis with various prompts; on the analysis there are also 3 fields that are set as “Is Prompted”. I'm trying to create an Agent that runs the analysis, but every time it runs, it says there are 0 rows found. I tried a Condition to check if the…
-
OTBI duplicate lines
Hi. Does anyone have any idea how to deal with duplicate lines in OTBI? The subject are we are using is Receivables - Standard Receipts Application Details Real Time. We are getting the receipt information, but it displays two lines for a receipt that was posted and updated. The receipt was posted and updated on two…
-
Having drill down BI Publisher report using rtf template, how can we rename tab
It shows RTF Template window tab but we would like to have it renamed and showing either the BIP layout name or report name. Howe can it be done ? Thanks.
-
BICC : Last Extract Date for PVOs reset only if the Extract Schedule completed successfully
Summary Update the logic to ensure Last Extract Date for PVOs resets only if the whole Extract Schedule completed successfully Content Currently, we have instances where when we are running an Extract schedule , some PVOs might fail resulting in No Manifest file being generated or files/data being available for processing…
-
How export more than 25,000 rows
Hello, I have a question that frequently comes up among colleagues who use OTBI for report extraction. There are two ways to export data: Formatted > Excel Limit of 25,000 rows Data > Excel Limit of 75,000 rows However, when I run these exports to Excel, I encounter the following limitation: I would like to know if there…
-
Workforce Mgmt - Areas of Responsibility does not extract Responsibility Type linked to Recruitment
Good morning We have an OTBI report built using the subject area: Workforce Management - Areas of Responsibility with the following fields: Person Number Display Name Responsibility Type Responsibility Name Work Contracts From Date This is not returning all of the expected data, as we should be seeing employees from the…
-
Schedule an OTBI agent to send the analysis using parameters
Hello, We have created an OTBI analysis, for which the parameters are as follows: --Year to Date; --Ledger ; Also, I created an agent to send daily by e-mail the report to the business user. Though, I did not find a way though which to pass a parameter for the "Year to Date" field when running the agent. Can you please let…
-
Context Value in Work Relationship subject area
Hello experts, does anyone can help me better understand what type of information refer to the following fields of the Workforce Management - Work Relationship Real Time subject area: Context Value Context Description Context Value Name they should be flexfields but it's not clear why some fields are filled even if we do…
-
How to fetch the lookup codes and lookup Types created in Fusion HCM into OTBI report
Hello All, we are using a OTBI analysis (Subject Area - Workforce Learning - Learning Records Real Time) to fetch the Learning Records for a few particular courses. so, we have hardcoded courses what we want to fetch. to avoid the hardcoding of the courses and offering we want to use custom lookup values (lookup_code)…
-
How to create an OTBI report to count all employees with no goals assigned
Hello, Need to create an OTBI report to count all employees with no goals assigned or with no individual goals assigned. When using the Workforce Goals - Goal Status Overview Real Time SA, the employees with no goals are filtered out (so they never even get into the report). Is there another SA that can be used in OTBI or…
-
How to get industry name from receivables in otbi(receivables-customer real time)
Hi we are joining two subject areas receivables-customer real time and receivables-transactions real time through (bill to customer number and organization number), we are getting data for all the fields except industry. Can anyone suggest on it. Thanks
-
Talent review template name column subject area for otbi
Hi, We are in need of assistance to locate the OTBI subject area for the following columns: Talent Review Template name Selected Population Employee Name Selected Population Employee Job Your help in finding the corresponding columns and OTBI subject area would be greatly appreciated. Thank you for your support. Please…
-
Excel report only showing parameter page and not data page when bursting
See attachment. When I run the report online it works. When I orride the bursting, it works. When I schedule with DM Bursting, the excel spreadshhet has the parameter values on Sheet 1, but no data on Sheet 2. https://us.v-cdn.net/6037859/uploads/U27SIUF4391N/bursting-setup-and-results.docx
-
OTBI Last Accessed Folder or Default Folder Option
I've noticed that when using OTBI, it doesn't retain the last folder I was in when I return to the tool. Each time I log in, I have to manually navigate back to the folder I was previously working in, which can be time-consuming—especially when working with deeply nested folders. It would be a great usability improvement…
-
What is the process to set up a Page Break in OTBI Analysis?
We’ve used page breaks in BIP reports and are looking for a similar feature in OTBI. Could you please guide us on how to achieve this? Thanks, Sathyaseelan C
-
Industry name attribute for the following - otbi
how to add industry name in otbi having subject areas- order management - order headers real time Receivables transactions real time
-
Link between 2 subject ares
link between CRM interactions real time and order management - order headers real time CRM interactions real time and Receivables transactions real time
-
Missing Field in Checklist Real Time Subject Area.
I am currently developing an analysis from a journey that leverages questionnaires. In each question, we provide the ability to add "Additional Comments". However, after pulling every field from the subject area, I have found "Additional Comments" isn't represented. That was further reenforced by questions here. My…
