OTBI
Discussion List
-
Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses AvailabilityHi All, I'm implementing the new Redwood Purchasing Landing Page feature and trying to add KPIs to the Visualization Configurations page. When I access the configuration… -
How to create custom filters and infolets in redwood screenSummary: How to create custom filters and dashboard in redwood Content (please ensure you mask any confidential information): We are looking to create several other filt…Abhishek Kumar Ranjan 213 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Maintenance -
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 696 views 7 comments 1 point Most recent by Kamalnath V Reporting and Analytics for HCM -
Printing the XML for Purchase Agreement Report PdfSummary: I need to print the XML for the Purchase Agreement Report PDF. I have created a custom folder, ensures that this report is in the correct directory, changed the…
-
How to get the details of action items which are denied?Summary: Need details of the action items which are denied along with their denied date Content (please ensure you mask any confidential information): We have a requirem…anirbanchatterj7 35 views 0 comments 0 points Started by anirbanchatterj7 Reporting and Analytics for HCM
-
What Subject Area provides access to Contract Billing Controls (Soft/Hard Limits)?Summary: OTBI Reporting of Contract Billing Controls Content (please ensure you mask any confidential information): Looking to create an OTBI report that includes Contra…
-
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…Maddipati Ajay Kumar 708 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How can we define. aba format file for payments?We have a third-party vendor who validates the payment file in ABA format before a payment file is shared with the bank. So, our request is how do we generate an. aba fo…Veera_CPS 141 views 5 comments 1 point Most recent by NayanajithG Payables, Payments & Cash Management
-
Is payment transmission information available in Payment subject area - OTBI - AnalysisSummary: Hi Is payment transmission information available in OTBI analysis Payment subject area? Table → IBY_PAY_INSTRUCTIONS_ALL - Column → Payment_instruction_id Conte…
-
Creating BI Publisher Audit Reports Equivalent to Native Oracle Fusion Audit ReportsSummary: Hi everyone, We're running into the row limit in the native Oracle Fusion HCM Audit Reports UI and are exploring the possibility of building custom BI Publisher…
-
Creating BI Publisher Audit Reports Equivalent to Native Oracle Fusion Audit ReportsSummary: Hi everyone, We're running into the row limit in the native Oracle Fusion HCM Audit Reports UI and are exploring the possibility of building custom BI Publisher…
-
How do I calculate the number of days a position has been vacant?I am trying to write a report in OTBI to calculate how many days a position has been vacant for to enable management of aging positions. My initial analysis was in Worke…Scott_Turner_ 20 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…
-
Inquiry on Learning PricingSummary: Hi, I would like to better understand how Pricing works in Oracle Fusion Learning and would appreciate any guidance from the community. How does the system calc…
-
Access to OTBI from the subject area Security - Roles and Privileges to resolve access issuesSummary Need to to provide more broadly access to the OTBI from the subject area Security - Roles and Privileges subject area to help resolve access question more quickl… -
Changes to custom report, replicates in seeded reportHi all, I have encountered a problem while customising reports. -When I create a copy of a custom report ("customise it" using XMLP server) then the seeded object disapp…Shruthi Arun Krithika 31 views 2 comments 0 points Most recent by Dhruvi Reporting and Analytics for ERP
-
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu…
-
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 63 views 6 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP
-
I need to understand how to monitor and audit user access to subledger journal transactionI need to understand how to monitor and audit user access to Financial Accounting Hub (FAH) subledger journal transaction details. Track and report who has accessed or v…sunil_bhatt comcast 11 views 1 comment 1 point Most recent by Julien_Dubouis Subledger Accounting & Accounting Hub
-
OTBI report exported to different tabs in one Excel workbookSummary: We have a legacy OTBI report that provides GL details for multiple accounts. The analysis only has one table view, however, the table view is separated into sec…
-
Session Variables for Use in Activity Center VisualizationsHello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reportin…Nick Dorfner 23 views 1 comment 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Cannot Create Visualization in Redwood AnalyticsHello, In following this documentation, I attempted to create a new visualization for Redwood Analytics and mapping an OTBI report to it. My goal is to add this to the R…Nick Dorfner 23 views 1 comment 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM
-
How to list all changes made against a BPM rule in given time period?Summary: How to list all changes made against a BPM rule in given time period? we are referring to table POR_AMX_RULES but it doesn't have changes made against any condi…
-
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …Swapna Govind 81 views 5 comments 0 points Most recent by Stefano Mauri Reporting and Analytics for HCM
-
Incremental extract for EFF BICC PVOs (FulfillLineBIEffEFFBIFlattened , HeaderBIEffEFFBIFlattened )Summary: We are Unable to run incremental extract for BICC PVOs (FulfillLineBIEffEFFBIFlattened , HeaderBIEffEFFBIFlattened ) There isn't a suitable column (like a last …
-
Which table stores Receivables Specialist Assignment Rules?Summary: Which table stores Receivables Specialist Assignment Rules? Is there any Subject area to create OTBI report? Content (please ensure you mask any confidential in…Bhanu Prakash Sharma 11 views 3 comments 0 points Most recent by Bhanu Prakash Sharma Receivables & Collections