OTBI
Discussion List
-
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_ 7 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 9 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…
-
Question marks appearing in custom eText outputSummary: Custom eText payment format in BI Publisher has question marks inserted into output. Content (please ensure you mask any confidential information): I have creat…
-
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 34 views 6 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP
-
How/where to track PO's Communicated via Email to supplier in outlook sent item?Summary: Hi All, We are using the Oracle Supplier Communication functionality to send Purchase Orders to suppliers via email. Is there a way to track whether a Purchase …
-
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 1 view 1 comment 1 point Most recent by Julien_Dubouis Subledger Accounting & Accounting Hub
-
OTBI - Is Purchase Order Number available in the following Subject Areas?Summary: How to retrieve Purchase Order Number from OTBI Subject Areas for Implemented Change Orders and Requisitions. Content (please ensure you mask any confidential i…
-
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…
-
How to get Home and Work Email outSummary: I'm trying to build a report that includes both Home and Work Email. I have sufficient privileges to view and report on this data. Currently I have Workforce Ma…Sillery 30 views 4 comments 0 points Most recent by Abhishek Premchandra 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 74 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 16 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 -
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…
-
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 3 views 4 comments 0 points Most recent by Jenna Savage - Hunter Douglas Reporting and Analytics for HCM
-
BICC Deprecated PVOs for 26CCould you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test en… -
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 714 views 9 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
Report issue when running Carry Forward Purchase Order Budgetary Control Balances processSummary: Hello we are having issue where not all the reports generate when we kick off the Carry Forward Purchase Order Budgetary Control Balances process. We even tried…