OTBI
Discussion List
-
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 53 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 5 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 12 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 20 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 72 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 -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 118 views 20 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
Need a query that identifies run results or balances where taxes are not being withheldNeed a query that identifies run results or balances where taxes are not being withheld, even though tax withholding is configured on the Calculation Card. There are sev…
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…Darrin N 32 views 4 comments 0 points Most recent by Jenna Savage - Hunter Douglas Reporting and Analytics for HCM
-
Associating the reconciliation history table with system transactionsIn the CE_RECON_HISTORY_ITEMS table stores the bank statements reconcile record. The field RECON_SOURCE shows where the matching item comes from. And I believe field SOU…
-
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether…VijayaBaskar Ranganathan 726 views 9 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
PO PDF Custom Template not getting selectedSummary: Hello, we are having an issue where our Custom Template is not getting selected when creating PO's. It is pulling the seeded template and I cannot figure out ho…
-
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi… -
How many users are in a specific Global Access Group. Prepare OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, I want to see if we can prepare a report with the name of the Global Access Group and t… -
Problem with scheduling OTBI reports - error messagesContent I've set up loads of scheduled OTBI reports in the last few months. Although they are still coming through by email when they should, if I try to set up any new …User_2025-02-05-04-46-07-194 98 views 4 comments 1 point Most recent by RoyKC Reporting and Analytics for HCM -
How to capture Tax Registration Number at Supplier Address level in OTBI reportSummary: Requirement is to populate Tax Registration Number from Supplier Address level in OTBI report Content (required): I have created an OTBI report for Supplier Mas… -
Does the person with delegated role get access to the additional data via reportingContent (please ensure you mask any confidential information): If a Manager has delegated (say) their Line Manager role to their Exec. Assistant (EA), then does the EA s…SameerJain 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Request to Notify Invoice Creator on Hold Release/AcknowledgementSummary: I have configured FinApHoldApproval to send notifications to the invoice requester, and it is working as expected. The user would like to know whether notificat…Krishna Kanth Kommuru 33 views 1 comment 0 points Most recent by Devesh Tyagi Payables, Payments & Cash Management
-
Applied Receipts Register Report Showing Only Consolidated Values Instead of Parameter-Level DetaileWe are facing an issue with the Applied Receipts Register Report in Oracle Fusion Receivables. The report completes successfully and returns data; however, regardless of…
-
OTBI Report shows wrong annualized salary and annualized full-time salarySummary: OTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensat…
-
Error Codes: OAMP2OPY:U9KP7Q94 - OTBI AnalysisSummary: We have a weekly Analysis that runs via Agent. After running many times without issue each week, we are getting these errors: OAMP2OPY:U9KP7Q94 - "An Unexpected…User_2025-03-07-06-07-08-189 1.5K views 9 comments 0 points Most recent by Dolly Singhal Reporting and Analytics for HCM
-
How to convert an existing OTBI report with prompts and filter conditions to BIP reportSummary: We have requirement to convert the OTBI report to BIP report. The OTBI reports has prompts and filter condition. How can we convert the same in BIP report witho…