OTBI
Discussion List
-
Duplicate rows in Fixed Assets Depreciation OTBI reportWe've created a custom dashboard to view our Fixed Assets Depreciation, based on the 'Fixed Assets - Asset Depreciation Real Time' subject area. We've found that some as… -
Is there a column "Ship Lines Together" in the "Fullfilment Lines Real Time" subject area?Summary: Is there a column "Ship Lines Together" in the "Fullfilment Lines Real Time" subject area? Content (please ensure you mask any confidential information): Wareho… -
Invoice Lines DFFSummary: Invoice Lines DFF Content (please ensure you mask any confidential information): Can invoice lines DFF that are displayed under "Details" be shown on the invoic…
-
Reporting duplicate supplier bank accountsSummary: We need to identify the suppliers that happen to have the same bank branch and bank account numbers. I plan to build a data model and a BI report to list the su… -
Duplicate rows in Fixed Assets Depreciation OTBI reportSummary: We've created a custom dashboard to view our Fixed Assets Depreciation, based on the 'Fixed Assets - Asset Depreciation Real Time' subject area. We've found tha…
-
Allow International payments not visible in OTBISummary: Hi, I am working on the Supplier OTBI report, there I have a requirement of the Allow International Payment field, Which is not available in Suppliers - Supplie…Abu Hussain 31 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank …Alessandra T. 1 view 0 comments 0 points Most recent by Alessandra T. Reporting and Analytics for HCM -
Procurement BU missing in Top 10 Spend by CategorySummary: Procurement BU missing in Top 10 Spend by Category Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you on …
-
SQL to Get Grade and Grade and Grade Step details on a assignmentSummary: Hello Everyone, I'm new to SQL query building. Just getting hands on it. I am trying to create a Data model that will return salary detail including Grade and G…PRABHA_DEV 4.8K views 16 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for HCM
-
Some of reports when we try to download the report we are getting processing errorSummary: HI Team, Some of reports when we try to download the report we are getting processing error . Export>Data>CSV or Excel Content (please ensure you mask any confi…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI error - Error during query processingSummary: We have an OTBI report, pulling from 2 subject areas — Workforce Management - Work Relationship Real Time and Workforce Management - Person Real Time. Our HR us…
-
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 61 views 4 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for SCM
-
What is the link between Sales order and Discount list through SQL in oracle fusion?Hi All, In my project we have done a customization on Discount lists setup which will apply on the sales order based on Attribute Matrix rules. Ex: so we have added a co…
-
How to disable Export -> Data in selected OTBI reports?Summary: Hello, Do you know how to disable Export -> Data in selected OTBI reports? When user clicks Export -> Formatted -> Excel, the report contains only columns that … -
OTBI Leave Learner on Report with Empty Completion Date?Summary: I have a OTBI report with a list of team members. All team members are required to complete Course A. Some have completed it and some have not, nor have they be…
-
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
OTBI BIP - Secured List Views for ERP and SCMSummary: With reference to the Fusion BI Publisher - Fusion Security in BI Publisher Data Models - Secured List Views SLV (Doc ID 2708546.1) - (Refer the document sectio…Kumar.Eswaran 455 views 2 comments 3 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 1 view 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
My approved invoices OTBI reportHow do I default in an OTBI report invoice approver to be the User running the report? Or at least have in the drop down list only value available my name (the name of t…Julia Kang 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Create OTBI Report for Project with it's Expenditure Type and costSummary: Title: How to Create an OTBI Report in below Table Format for Projects Hello Oracle Community, I’m looking to create an OTBI (Oracle Transactional Business Inte…Karthik Selvaraj 31 views 1 comment 0 points Most recent by sambasivarao kosuri-Oracle Project Management
-
Report that show what OBTI Analysis is being used with each initiative?Summary: We need to audit our initiative and OBTI analysis. Is there a report or can someone provide the criteria for a report that will show all the initiatives that ar…
-
Change OTBI Analysis PathSummary: Change OTBI Analysis Path Content (please ensure you mask any confidential information): We are planning to change the learning analysis folder path in the foll…
-
BI query as list of values for a dashboard promptHello, We have a request to create a prompt with the names of employees based on a given job title. To access the data in the subject area "Security - Roles and Privileg…Varun Dhondea 51 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
24D OTBI Skills CentreSummary: In 24D is there a way to pull out the full list of skills in the dynamic skills centre in OTBI? Including statuses and grouping? Content (please ensure you mask…