OTBI
Discussion List
-
Unable to access the certs/attachments on Transcripts for termed employees in oracle fusionSummary: Hello All, we cannot access the certs/attachments on Transcripts for termed employees in oracle fusion. This is an issue anytime we need to pull any type of att… -
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
Facing issue while using OTBI Analysis payroll - calculation card entriesSummary: While using OTBI Analysis, payroll - calculation card real time for a person I am getting 2 rows for a person having LGPS ESCC Scholl employee. After adding ass…User_102WR 1 view 2 comments 0 points Most recent by User_102WR Payables, Payments & Cash Management -
How to add a new page for the inforletSummary: I was able to add a few report to an existing page. but I want to be able to crete a new page and add all my reports. I added my report using the page Composer …diego m schenquerman 1 view 3 comments 1 point Most recent by diego m schenquerman Reporting and Analytics for SCM
-
How to Automatically Send OTBI Reports to an FTP ServerHello, Has anyone managed to automatically deliver an OTBI report to an FTP server? Is there an Agent that can handle this automatically? If so, could you please share t…
-
How to combine multiple max formula criteria in OTBISummary: I'm having trouble pulling in all employees latest Seniority Dates. It seems I need to pull in 2 criteria: 1. LATEST Seniority Change Start Date & LATEST Senior…CGardner01 32 views 4 comments 0 points Most recent by Manasa Madishetty Reporting and Analytics for HCM
-
Change row output number on Oracle OTBI AnalysisHow I am able to change the output of the rows from 75000 to more on an Oracle OTBI analysis? -
Fixed Asset Additions/Adjustements Infotile datasource in OTBISummary: Hi, Where can we find this data for Fixed Assets in incomplete status, exceptions etc? Do we have an OTBI subject area to create this type of KPI/analysis? Cont…
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati…Matheus Roberto 31 views 2 comments 0 points Most recent by Saulo Salvador Reporting and Analytics for HCM -
Can we exclude minimum amount receipts from AR Aging report (like -0.01)Our customer don't want receipts which has amount less than $1 in their AR aging report (attached ss for the same), can we exclude those receipts from this report? -
track the Non catalog request history in Learning Assignment pageSummary: Hi Team, User able to request for the non catalog request and learning team able to edit the assignment and change the non catalog request to the catalog and ac…
-
We have a requirement to audit changes to folder permissions for custom folders in Reports and AnalySummary: We have a requirement to audit changes to folder permissions for custom folders in Reports and Analytics. Is there a way to get these details? Content (please e…Akash M Mahalle 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
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…
-
Tables that store the errors in FAH when the import Accounting transaction process failsSummary: What are the tables that store the errors in Accounting Hub when the import Accounting transaction process fails ? Version (include the version you are using, i…
-
OTBI Analysis- Open po report getting error while adding invoice dateSummary: Getting errors while adding invoice last updated date Content (please ensure you mask any confidential information): Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9I…uday kiran.b 11 views 0 comments 0 points Most recent by uday kiran.b Payables, Payments & Cash Management
-
HCM Alerts Composer: Not able to loop the comma-separated data to one below the other inside a TableSummary: We are looking for a way to get the comma-separated values one below the other. Content (please ensure you mask any confidential information): Version (include …
-
Are there folders called 'Measures' or 'Asset Balance Measures' in Fixed Assets - Asset Balances ReaSummary: Unable to see the 'Measures' or 'Asset Balance Measures' folder in the OTBI Fixed Assets - Asset Balances Real Time subject area Content (please ensure you mask…
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
Subledger Accounting - Journals Real TimeHi, We're experiencing an issue in an OTBI Analysis where we are unable to pull back data from any columns relating to Supplier, Purchase Orders, and Receipt Numbers at …
-
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…Rohit Soni-259808 222 views 5 comments 1 point Most recent by Dpalmborg-Amica Reporting and Analytics for ERP
-
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…
-
Add KPIs and Negotiation Dashboard to Redwood Sourcing Landing PageSummary: Is it possible to add OTBI-based KPIs and visualizations to the Sourcing Landing Page in Redwood, specifically to build a negotiations dashboard (e.g., invited …
-
Need Report to show Change Details of a BPA Change OrderSummary: Looking for a report to see what details were changed in a BPA or PO Change order. Please advise if there is any OTBI report or table to create BIP report. we c…
-
Table to query access groupSummary: Hi the team, In Oracle learning cloud we can link Global Access Group at Course and Offering level. We would like to run an analysis to see which learning conte…
-
Does Oracle Finance Cloud Support User-Based Concurrent Request Priority Like EBS?Hello Oracle Community, In EBS, the priority of concurrent requests is managed at the user level via the "Concurrent:Priority" user profile option, which System Administ…Steve Collop 11 views 2 comments 0 points Most recent by Steve Collop Fusion Applications Administration