-
Is there a reason why OTBI would not show all employees within an absence plan?
Our business have a Holiday Purchase Plan Report - which is in the Absence Real Time in OTBI using the Absence Plan. However when using this, there seems to be a significant amount of employees who have the plan in HCM not showing in this report? Is there any reason why employees would not pull through? Is there a process…
-
Learning Evaluation OTBI Report - Learning Cloud
Dear Experts I have created the OTBI Report for Learning Evaluation using Subject Area workforce learning - learning management real time. I want to get the question texts/Questions in columns. For getting the questions (Eg: Learner Feedback) in columns, Which column name should i select? Can we get this? Looking forward…
-
OTBI link Receivables Customer Real Time to Transactions Real Time
Summary OTBI link Receivables Customer Real Time to Transactions Real Time Content I cant able to find the link between following subject areas in OTBI subject areas. a) Receivables - Customer Real Time b) Receivables - Transactions Real Time Thanks in advance!
-
Percent of Performance Document by Status Dashboard not working
When we run this dashboard we get the No Results Error, see below: The performance year only allows '2024' or '2015' to be selected. Any suggestions would be greatly appreciated!
-
Purchase Receipts Real Time subject area _ Last Receipt Date
Hi, I am trying to find Last Receipt Date from Receiving - Purchase Receipts Real Time subject area. can you please help me to find this column?
-
Unable to introduce new line within an excel cell
Summary Unable to introduce new line within an excel cell Content I am from Oracle Service Cloud (OSvC). We are using BI Publisher in our product to export data in various formats (We have XSL and XML). Our data is in a tabular format with multiple rows and columns. There are line breaks within data in most of the cells.…
-
schedule tables are emply in OAS
We have couple of agents running daily , when we check S_NQ_JOB for history of schedules, observed table is empty. Agents are running fine , I see details on Console -> 'Monitor Deliveries'. Can some please help me how to get Agent Details in Schedule tables. S_NQ_JOB S_NQ_INSTANCE S_NQ_ERR_MSG S_NQ_JOB_PARAM Thanks in…
-
Any OTBI subjectarea or Standard OTBI analysis/Dashboard to view history of PJF_PROJECTS_ALL_B table
We have enabled auditing on Project Foundation Product which reflects the history of fields enabled on PJF_PROJECTS_ALL_B table into PJFPROJECTS_ALL_B however customer wants to know rather than developing BIP custom report to view the auditing history is there any OTBI subject area or Standard OTBI analysis/Dashboard to…
-
Webservice to run OTBI agent
Webservice to run OTBI agent where we should not pass username and password in body of the request.
-
Not able to access SA "Distributed Order Orchestration - Fulfillment Lines Real Time" in OTBI
My user has been designated the role of "Order Administrator & Order Manager," and while I can access all the other subject areas, I am unable to view "Distributed Order Orchestration - Fulfillment Lines Real Time". Can anyone provide guidance on troubleshooting this issue?
-
Not able to access Subject area "Costing - Item Cost Real Time" in OTBI
My user has been designated the role of "Cost Accountant," and while I can access all the costing subject areas, I am unable to view "Costing - Item Cost Real Time." Can anyone provide guidance on troubleshooting this issue?
-
ORACLE licencing reports
ORACLE don’t provide users vs licences vs roles reports - do they? closest Ive got is this - since deleted - Document 2512770.1 Hera Licensing Monitoring & Optimization - OACS reports thanks
-
BI Report output shows Data_DS in csv format instead of showing empty table with columns
Report output displays Data_DS when there is not resultant data Expected: I need the CSV output to display column names when data in not present for further integration column mapping Please review attached document with screenshots what can be done to get the expected output format Thank you Ninad
-
Guidelines on OTBI/BIP Usage
Hi, We have a large number of OTBI analysis and BIP reports being executed on an hourly basis. We also repeatedly have errors on timeouts related to BIP presentation services being unavailable. I would like to enquire as to what are the guidelines around how OTBI/BIP has been designed and what sort of volumes of concurrent…
-
Need inputs in selecting subject area for an OTBI analysis.
Hi Team, Need to fetch Customer general info and his latest invoice Date and Payment Date. Trying to use Receivables- Real Time transactions and Receipts but no use. Unable to join the subject areas Thank you for your support and guidance.
-
Can we directly burst report output on object storage?
Can we directly burst BIP report output on object storage similar to email/FTP bursting? If yes then how? In which release the feature is available?
-
Any budy know the rol to need assigned for user of TI
I need to know what role cold be assigne for TI user this peopple make support for reporting to the rest of funtional users
-
Why can't I download BI Publisher output using Firefox anymore?
My Firefox updated to Version 123 yesterday (Feb 20, 2024), and I now I can't download BI Publisher output anymore. When I click on the report output after navigating to it (Navigate to Report, Click More, Select History, Click Report Job Name for report that I want to open, Click Output1). After clicking Output1, I see a…
-
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?
OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? For example, per Learning Assignment > Edit Assignment screenshot below, the Withdrawal Type is "Learning Specialist Withdraw Learner". However, we are curious to…
-
Table Location of To/From Dates for Talent Ratings
I am looking to find the the save table location for the To/From dates for the Talent Rating module. This is for a BI publisher report using a Data Model. The associated data for these ratings was found in HRT_RATING_LEVELS_VL. This view does contain date columns, however the DATE_FROM and DATE_TO are only pulling in…
-
Why this field is empty?
I have created a report from the subject area "Workforce Performance - Performance Rating Real Time", in which it's extracted the field "- Rating Level"."Rating Level Code". How come this is empty if I also add the fields "- Performance Document Item"."Competency Name" and "- Performance Document Item"."Proficiency Rating…
-
Formula to Calculate Between Two Dates
I've added a column to my OTBI analysis to calculate the days between when a Requisition is approved to when the corresponding Purchase Order is approved. Since the date format for Requisition Approval Date and Purchase Order Approval Date have the date and time, my calculation has rounding differences that I've tried to…
-
Hi, i'm new to Fusion, coming from PeopleSoft. Does Fusion use the CEMLI tool to migrate processes?
if not, what tools are available to migrate processes (i.e. SQL, etc) from one instance to another? we are developing with OTBI thanks Fred
-
OTBI - Edit column formula to include a filter
Is it possible to edit the column formula so that it will only show values with specific criteria? More specifically, I'm trying to add in AOR Responsibility information and would like to bring in the names of the AOR representatives for only 3 Responsibility Types. Currently, because we have several responsibility types,…
-
OTBI Analysis - Convert Datetime value to Date (only)
How do I convert a datetime value to a date only value: "10/16/23 9:24 PM" to "10/16/23" Should be simple, right? 😏
-
Extract Data Stores for the Shared HR and Projects in BICC (Business Intelligence Cloud Connect)
Hello....we are looking for the "Extract Data Stores" to create a Business Intelligence Cloud Extract for the Fusion Projects and Shared HR modules. Can you advise if any document(s) similar to what Oracle provides for the following offerings are also available for Shared HR and Project and Grants modules? +++ Documents…
-
How to change the week definition to ISO-8601 (1st day of the week being a Monday)
In OTBI the week definition is using the American standard, Week = Sunday - Saturday. But in Europe we do use ISO-8601. Week = Monday - Sunday. Also week number itself can be different. ISO-8601 always has 7 days per week and this makes reporting per week consistent. American week at the end and beginning of the year can…
-
I'm currently working on a OTBI report with a requirement of Plan Participation Details.
Question: I need the Purchase Plan Hours , Plan Current Balance Hours & Plan Used Hours. Upon building the report I encounter some issue if the employee have a multiple plan, It sum ups all the Purchase Plan Hours. is this possible to separate the hours? Plan #1: 100 Purchased Plan Hours Plan #2: 35 Purchased Plan Hours In…
-
How to extract OTBI reports with HTML Formatting
Hi Experts, I need your assistance. I need HTML PAGE formatting in my OTBI report XML format. As you can in see the first picture, I have set formatting for internal description, and now I need the same formatting in my OTBI report whenever I export my file in XML format. I could pick up Internal Candidate formatting in my…
-
Extracting all Columns from BIP Query without creating layout?
Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 100 or so columns and I really don't want to tediously have to drag and drop each column in via the report creator. Is there a simpler way to extract all…
