OTBI
Discussion List
-
Is any currently using NACHA File Format with more than one addenda record?I am trying to implement a NACHA CTX Format for my eText bank file using the US NACHA CCDP template. I have tried other templates as well. The closest I have come is to …Keith Doucet 31 views 2 comments 0 points Most recent by User_04LIM Payables, Payments & Cash Management -
Impact of Redwood Changes on backend Tables (OTBI/BIP/FRS Reports)Summary: Any changes to database/table structure for Fusion Financials? Any guide/pointers on what's needed to be checked before/after migrating to Redwood for our exist…
-
Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: PSummary Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: Person ManagementContent Hi Team, Is it possible to track how … -
How to get Sales Order Return Quantity against the Sales OrderSummary: How to get the Return Sales Order Quantity against a sales order using sql. Content (please ensure you mask any confidential information): Version (include the …
-
How to change the week start daySummary: Hello Experts, I created an Analysis and i see the Calendar Week Start Date is Sunday, but the customer need set to Monday. And this impact on the number of wee…
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v…Sejal Mehta 52 views 5 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
How to keep searching panel available on the screen?Summary: How to keep searching panel available on the screen? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you o…
-
How can I design an OTBI inventory analysis report that displays item serial numbers and lot numbersSummary: How can I design an OTBI inventory analysis report that displays item serial numbers and lot numbers as report columns with subinventory, Qty and Unit cost in O…
-
LMS Utilization ReportSummary: I need to build a report in OBTI that shows our LMS Utilization Rates for our Executive Team. Does anyone have any examples or files that they would be willing …
-
How can I populate longitude and Latitude in OTBI report?Summary: Hello, I am here to inquire about 25B new feature by the name: New Address Attributes Added to Worker and Location Dimensions. I am trying to create an OTBI rep…Vaishnavi Katiyar 31 views 5 comments 0 points Most recent by Melanie Ramirez Reporting and Analytics for HCM
-
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 11 views 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…