OTBI
Discussion List
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…Manish_Chauhan 12 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 787 views 6 comments 0 points Most recent by MarkGauthier Payables, Payments & Cash Management
-
Condition to display active customer accounts/sites in Customers extract OTBI ReportSummary: Hi, We used subject area named "Receivables- Customer real time" to create an OTBI to extract customer master. however, we couldn't find a column in any folder …
-
Link between ZX_RULES_B and ZX_STATUS_B in oracle fusion TaxSummary: Got a requirement to link these two tables to generate report for Tax Rate and Rule Content (please ensure you mask any confidential information): Version (incl…
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 74 views 12 comments 0 points Most recent by Jenna Savage - Hunter Douglas Reporting and Analytics for HCM
-
Receivables Transaction Review and Control ReportingSummary: We are working on implementing the new feature around Receivables Transaction Review and Control, however we are looking for reporting related to the credit mem…
-
Please let us know how we can add the Attachment column in an OTBI report for ReceivablesSummary: Please let us know how we can add the Attachment column in an OTBI report for Receivables subject area, prefarably Receivables- Real Time Transaction subject ar…
-
Construction Industry Scheme (CIS)Summary:Construction Industry Scheme (CIS) Under the Construction Industry Scheme (CIS), contractors deduct money from a subcontractor’s payments and pass it to HM Reven…Sofia Chen 74 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
The supply plan tables could be printed in BI report?Summary: Hello, I have a custom table for supply planning, I need a BI report to print data generated into the table for the 3 measures per period while is filtering by …Diego Zegarra 11 views 1 comment 7 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 106 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How can I add suggested start date of a maintenance program generated work order to an OTBI report.?Summary: I am trying to add the suggested start data of a work order to an OTBI report. Work orders that are created by maintenance programs have a suggested start date.…Phillip_Shearer 2 views 1 comment 0 points Most recent by Ezra Anderson Reporting and Analytics for SCM
-
How to make US1099 report to be emailed to Vendor?Summary: Content (please ensure you mask any confidential information): Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .p…Vikram_Patel 11 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…Marko Puskac 21 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Need subject area for Bank return number to add column in OTBISummary: Hi Experts, I am looking for subject area for bank return number to add in OTBI report. Task: Payments—> Manage bank Returns —> search with invoice number— Retu…Mahindra reddy-Oracle 11 views 1 comment 0 points Most recent by MiaM-Oracle Receivables & Collections
-
Absence Calendar Subject Area not showing all dataSummary: When I run my report using the Absence Calendar Subject Area a large amount of data is missing. I have tried running the Generate Daily Breakdown of Absence Det… -
All upcoming training/courses should be visible to learnerSummary: Hi, We have a requirement where from Me→ Learning tab employee can see a dashboard kind of things to check upcoming training or courses and can enroll them self…
-
API to run financial reportSummary: We have the following query, we need to call a financial report using a web service, we have tried using the WSDL (/xmlpserver/services/ExternalReportWSSService…Arin 12 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 308 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
How to create a dashboard.Hello, we have a Report set up to show managers their staff learning record. Is there a way to add this to a dashboard for them - at the moment they have to go into repo…
-
Capture the Learning Activity description in OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, is it possible to get the description of an Activity in an Offering from the Learning R…Bobby Jourdan 42 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the …Raghavendra M 803 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…Kayla Malecki 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Download AR attachment from OTBIIs it possible to download the attachments from and AR invoice directly from OTBI? These are attachments that are uploaded directly into each invoice and the user wants …
-
Enhanced subject areas - Oracle Fusion ERP Analytics (24D)In the whats'new 24D note we have an enhancement in these subject areas: Encumbrance Accounting is available as an additional opt-in Generally Available pipeline feature…Rocha, Diego Rodrigo 42 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Why are users with my custom role for OTBI not able to see data in OTBI reports?Summary: I created a custom role with copying "Project Administrator" role. Remove all "Function Security Policies" and do not touch "Data Security Policies". Remove all…
-
OTBI report returning Lookup codes, how to fetch meaning instead of codesSummary Few Talent profile attributes in OTBI report returning lookup codes.Content Hi, In the Person profile>License and certifications section few fields are lookup ty…Challa Vidyasagar 298 views 3 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM -
RTF file ConfigurationSummary: Dynamically Present non null column in table Content (please ensure you mask any confidential information): I am creating an RTF file using Word table with 3 fi…