OTBI
Discussion List
-
Zip File for 'Identifying Authorized Hosted Named Users' no longer available?Summary: Hi, I used to be the primary person managing Oracle Licenses and would utilize the 'Identifying Authorized Hosted Named Users' reports which provided the follow…Rebecca_Edwards 6 views 1 comment 0 points Most recent by User_53APA Reporting and Analytics for HCM -
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature … -
for creating learning assignment profile/initiative using OTBI report for making audience basedSummary: For creating learning assignment profile/initiative using OTBI report for making audience for Course A based on the completion status on other course B which is… -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 47.1K views 101 comments 121 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get inactive, Obsolete items, Inactive customers from Oracle DMC?How to get inactive, Obsolete items, Inactive customers from Oracle DMC? Is there any direct sql i can run?Sivakumar J 26 views 2 comments 0 points Most recent by Sivakumar J Supply Chain Planning and Collaboration -
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
How can we identify Redwood vs Classic creation source for Agreements, Purchase Orders & Suppliers?Summary: We are working on reporting to help monitor and measure Redwood adoption across Oracle Fusion Procurement. Specifically, we would like to identify whether trans… -
subject area for getting open pick slip detailSummary: subject area for getting open pick slip detail for OTBI report Content (please ensure you mask any confidential information): Version (include the version you a…Aarti Karale 67 views 2 comments 0 points Most recent by Aarti Karale Reporting and Analytics for ERP -
How do I open the table that contains this information from the Redwood screen Active Layers?Summary: The company's current process uses standard costs, and they want to create a report that shows material consumption levels when inventory issues are generated. … -
How to accommodate custom breakdown reasons within existing Production Exceptions (Redwood)?Summary: We've configured custom manufacturing exception types nested under Exception → Manufacturing → Resource Content (please ensure you mask any confidential informa… -
Which table are we going to use for Redwood Trading Partner Items?After migrating Trading Partner Items to Redwood, their data now resides in both EGP_TRADING_PARTNER_ITEMS table and EGP_SYSTEM_ITEMS_B table. Is this how it's going to … -
Enable Procurement Dashboard under Procurement tab in Oracle Fusion Cloud instanceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
User is unable to see distribution details for more than 30 lines in this sandbox through UIA sandbox is created to fetch and display Invoice distribution Lines. This distribution tab is created on the invoice inquiry screen on UI by calling a OTBI. OTBI is abl…Sifat Shaikh 21 views 1 comment 0 points Most recent by Scheduler_User Payables, Payments & Cash Management -
Working of CreditCheckingService SOAP WebserviceSummary: Working of CreditCheckingService SOAP Webservice Content (please ensure you mask any confidential information): Hello Team, We would like to know how the Availa… -
How is the IRIS 1099 Reporting Requirements for Separate Name Fields handled in Oracle Fusion?Summary: The IRIS electronic filing format requires that for individuals the name fields be separated in First Name, Middle Name and Last Name. For businesses the name f…JanLarson 97 views 6 comments 0 points Most recent by JanLarson Payables, Payments & Cash Management -
If anybody worked on ZPL format for label printing can you please share the ZPL formats and outputsSummary: We need to implement zpl format to print the labels using zebra printer. So need any samples of ZPL formats which are already implemented Content (please ensure… -
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h…E McDonald 139 views 3 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Custom OTBI Dashboard Appears Blank in Redwood ServiceSummary: Hi Team, I have created a custom OTBI dashboard for Service, which contains multiple custom analyses/reports with drill-down functionality to view the underlyin… -
Our SQL Query only show Account Alias Receipt TransactionsSummary: Our SQL Query only show Account Alias Receipt Transactions Content (please ensure you mask any confidential information): Hi I want to create SQL query that can… -
how to create ARCS report smoothly using EPM toolSummary: I want to create a report for the below requirement. Do we have any tool in EPM so that it can be created easily rather than creating report in BIP Analytics? I…Debasmita Adak 22 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections -
Bulk report to identify users and roles with access to custom BI Publisher reports.We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and…Sawan Choudhary 57 views 0 comments 1 point Started by Sawan Choudhary Reporting and Analytics for ERP -
Role/privilege is required to retrieve Position Code from OTBI "Position Real Time" in BI Publisher?Summary: Hello Experts, I am trying to retrieve Position information from OTBI subject area Workforce Management - Position Real Time through a BI Publisher Data Model. …PavelACT 42 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BICC - Custom offerings migration Import / ExportSummary Dears, We created custom offerings and added PVOs in that custom offerings. BICC Job is created and the source is the PVOs with in that custom offerings. Now the… -
SQL query or table for Project Cost Transaction AccountingSummary: Hello, Please help to have query or table to get the accounting details from Project Cost Transaction where we know the transaction number. Content (please ensu… -
How to extract requisition approval rules created in BPM as a report or CSV file.Summary: Requirement is to extract approval rules along with details/settings of the various stages, participants and the rulesets. Content (required): I have referred a…Ananda Bhargav Potluri 2.1K views 14 comments 3 points Most recent by PhilippeTawk Self Service Procurement -
Report on who created a classroomSummary: Report or SQL on who created a classroom in learning resources Content (please ensure you mask any confidential information): Can you Report or SQL on who creat… -
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 1K views 7 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM