OTBI
Discussion List
-
How To Use SQL To Return Audit Of Supplier Bank Account Changes ?Summary: How To Use SQL To Return Audit Of Supplier Bank Account Changes ? Content (please ensure you mask any confidential information): Hello We have enabled the Suppl…Cesar Saveedra 296 views 2 comments 0 points Most recent by User_25PXG Payables, Payments & Cash Management -
Total Compensation Statement - AnalyticsSummary: Hi All, We have completed generating the Total Compensation Statements for our employees. However; we would like to know if is there any way to get the analytic…Santhosh Bachu 11 views 2 comments 0 points Most recent by Santhosh Bachu Reporting and Analytics for HCM -
how to make goals dashboard embedded on the goals screen in fusion to take parameters from the goalsCustomer has created OTBI Analysis report based on the Workforce Goals - Goal Status Overview Real Time subject area. A graph has been created based on this analysis. Th…ElTawil 51 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting & Analytics for Fusion Service
-
Validate employee and Manager hierarchy analysis - How to write?Summary: I am trying to write an analysis in OTBI which would provide an output of Employee and a Managers Level 2,3,4,5 Department. The aim of the analysis is to use as…Scott_Turner_ 31 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM -
If the learner has course which is not being completed and it is being assigned manuallySummary: If the learner has course which is not being completed, and it is being assigned manually from Learning Assignment or Learning Initiative, If the same course is…
-
What is the best way to prepare a consolidated Trial Balance of two business Units?Summary: What is the best way to prepare a consolidated Trial Balance of two business Units? Content (please ensure you mask any confidential information): There are man…Kirtee Jeetah-Naran 31 views 3 comments 0 points Most recent by Kirtee Jeetah-Naran Reporting and Analytics for ERP
-
Need to allow holds resolution routing for system invoice Hold codeSummary Need to allow holds resolution routing for system invoice Hold codeContent Hi, For our user case, we need to allow holds resolution routing for system invoice Ho…Mohamed jouini 256 views 4 comments 1 point Most recent by AmitGoel Payables, Payments & Cash Management
-
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
During which process the Unit cost will get updated in the Costing back end tableSummary: Hello Oracle Experts! Recently we faced an issue in fetching the Unit cost from the back end costing table. When we do an Intransit receipt for a particular ite…
-
We cannot download PO Pdf for all POs in Bulk. How can we download all POs pdf in one shotSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23D Code Snippet (add any code snippe…
-
Is there a subject area with the "Allow Offset Taxes" field?Summary: We need to build a report that presents the "Allow Offset Taxes" information. Is there any subject area that has this information? Content (please ensure you ma… -
How to fetch only One record for Expected Effort in OTBI Learning Subject AreaSummary: Hi Team, I'm trying to fetch the employee who has having max number of hours in the OTBI report. I can fetch the Sum of hours for each employee individually but…
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
How to limit values prompt values when using choice list values from SQL ResultsSummary How to limit values prompt values when using choice list values from SQL ResultsContent Hi All, In a dashboard Prompt we are using column prompts we want to limi…
-
Unable to see 'Costing - Inventory Valuation Real Time' under OTBI subject areaSummary: I am unable to see 'Costing - Inventory Valuation Real Time' under OTBI subject area. Here is the document I am referring to. I do have Cost Accountant role tha…
-
how to fetch the direct report of the manager in otbiSummary: I am creating a journey and performance report in OTBI in which if a manger logs in then he need to see only his direct reporties. Content (please ensure you ma…Sindhuja Neerasa-Oracle 141 views 2 comments 0 points Most recent by Sindhuja Neerasa-Oracle Reporting and Analytics for HCM
-
Strange OTBI Error:[nQSError: 27046] Inaccessible columnSummary: Strange Behavior, getting the below error however respective Job Role/ Duty roles are assigned to the user but still users are getting the below error (Screensh…
-
How to Create a OTBI Analysis Based on Simple Logical SQLSummary How to Create a OTBI Analysis Based on Simple Logical SQLContent Hi Experts, I was trying to 'Create a OTBI Analysis based on simple logical SQL' While I was hop…AshishERPCloud 707 views 12 comments 2 points Most recent by Scott Leong Reporting and Analytics for HCM -
Out of all the offers released and how many have joined from the offer released.Summary: How can we add this graph in ORC custom dashboard which shows us the data for 'Out of all the offers released and how many have joined from the offer released r…
-
Invoice date on asset following FBDI upload when blankSummary: Invoice date on asset was set as "Date place in service" when the invoice date column was blank in FBDI. Is this the default value it takes when invoice date is…
-
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…User_2025-01-22-19-28-29-985 97 views 6 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM -
Where can I find the list of all seeded reports (OTBI and BIP) provided by OracleSummary: Where can I find the list of all seeded reports (OTBI and BIP) provided by Oracle for Procurement and Contracts? Content (required): Where can I find the list o…Asutosh Mishra 3.6K views 5 comments 0 points Most recent by SharathBiz Reporting and Analytics for SCM
-
Looking for an OTBI dimension to identify courses that are part of a specializationSummary: We would like to identify any course that is part of a specialization via an OTBI analysis. We are currently using the Learning Management SA in a report that p… -
Granting access to PO OTBI reports based on requisition BUSummary: We have multiple requisition BUs(hotels) under one procurement business unit. Each hotel controllers now need to see a report of all their department heads POs …
-
Convert Rows to Columns in OTBI from multiple subject areasSummary: Hi All, We recently went live with oracle HCM implementation. I have a OTBI report requirement where I need to convert fields containing multiple rows to separa…Ameya_J 181 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM