OTBI
Discussion List
-
OTBI HOW TO TURN MEASURE COLUMN INTO ITD YTD PTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO ITD YTD PTDContent I spent (as a newbie in OTBI) a couple of days trying to display the same column measure but with differe… -
How to access P2P OTBI Dashboards in Oracle.Summary: A user is requesting access to P2P OTBI Dashboard they saw in Oracle Learning, we don't know how to get to it. Content (required): From that user: "I’m in Oracl…Dennis Chebotarev 51 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Deeplink to GL Journals from OTBISummary: Hi All, Trying to implement the deeplink in OTBI to GL Journals. No Subject area in OTBI has jeBatchId column. Validate this in Fusion OTBI Data Lineage Mapping…ArunKumarDammalli 136 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
How to disable Edit option in OTBI Reports?Summary How to disable Edit option in OTBI ReportsContent Need to disable the Edit Option from the OTBI Analysis. Could you please suggest how we can achieve this?Srikanth Raavi 591 views 12 comments 1 point Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
How can a User view scheduled OTBI reports monthly?Summary: I removed the BI Author & BI Administrator role from a custom role for a user - leaving only the BI Consumer role within this custom role. User is not able to v…Akbar Ahmed 44 views 2 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Where can I find the list of native reports that exist in OTBI for purchase contracts?Hello colleagues, I need to know if there is a document that specifies those native or standard reports that Oracle offers, if you have a document with this information …Fernando Chavez 21 views 2 comments 0 points Most recent by Fernando Chavez Reporting and Analytics for ERP -
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 333 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
How do I find the OTBI Analysis behind a standard Infolet for Project ManagementContent Hi, My understanding (from other posts on this forum) is that I should be able to find the path to a standard Infolet by activating a Sandpit in Page Composer mo…
-
Getting remittance message columns in OTBI before payment is madeWe want to create a report which we can use to check whether all payment details are filled correctly for large batches of payments before creating them, to prevent down… -
Project Detail not showing up in Subject Area: Financials - Asset Transactions in FAWSummary: In Fusion Analytics Warehouse: Subject area: Financials - Asset Transactions: when we are pulling Asset Detail: Asset ID, Asset Number and Asset Name with Proje…Nilanjan Biswas-Oracle 12 views 0 comments 0 points Started by Nilanjan Biswas-Oracle Reporting and Analytics for ERP -
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …SireeshaJaladi 398 views 9 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Is there a delivered report on percentage of candidates that turn down offers for specific positionsSummary: Job offer rejection rate for fiscal year. Content (required): I have a report request for % of candidates that turn down job offers for specific positions. If a…
-
What is MRC compliant in Fusion Reporting?Summary: How to check if the reports built is MRC compliant or not Content (required): Version (include the version you are using, if applicable): Code Snippet (add any …Priyanka_Ghosh 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How can I Archive multiple BI Publisher Data Models & Reports into one .xdo (catalog) file?Summary: How to archive multiple BIP reports in OTBI? Content (required): I believe it should be possible to archive multiple data models and reports into one .xdo file … -
Add Report to Manage Invoice Screen and have it be dynamicSummary: We are looking to add a report to the Manage Invoices screen and have the results of the report be specific to the invoice we are on. Content (required): We hav…Jennifer Tavino 93 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 346 views 0 comments 3 points Started by Bernadette Dorris Reporting and Analytics for ERP
-
Track setup change report/analysis in OTBISummary: Track setup change report/analysis in OTBI Content (required): I'm looking for a report or to create an analysis in OTBI to track setup change. Who and When Sco… -
Scheduled OTBI report isn't showing all rowsSummary Scheduled OTBI is truncated when exported as a CSV fileContent Hi All, I have several OTBI reports which I have scheduled to be run each morning and delivered in…User_2025-02-07-17-40-32-318 82 views 7 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Ledger Currency are null on some payments in Analysis Payables Payments - Disbursement Real TimeSummary: Ledger Currency are null on some payments in Analysis report using the Payables Payments - Disbursement Real Time subject area. Content (required): Is there a w…
-
Assign custom role to OTBI reportHi, I have to assign custom role to custom OTBI report and I was trying to assign a role to OTBI report but custom roles are not showing in the LOV. Any suggestions?
-
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an…
-
Unable to edit Data Model post Deployment using Oracle SOAP ServicesSummary: Unable to edit Data Model post Deployment using Oracle SOAP Services. Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dll?SoapImpl=…Ardhendu Santra 62 views 4 comments 0 points Most recent by Ardhendu Santra Reporting and Analytics for ERP
-
What Table is the Role Code found in?Summary: Writing a query and Need to know what Table the Role Cod is found in? Content (required):
-
Trying to create an OTBI Filter to convert string to DATE with current YEARSummary: Hi, I am trying to create an OTBI analyses that takes a DFF ATTRIBUTE5 in text format with the month and day, and then compares it to the date of the current ye… -
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…Mickel.Rmeily 54 views 4 comments 0 points Most recent by Mickel.Rmeily Reporting and Analytics for ERP -
Security Reporting: Who Logged in and When and did whatSummary: Content (required): We need to report on the following areas: Who logged in/out and When? What actions the user has done? Which Pages the user accessed? Which T…
-
What is the difference between Order Date and Creation Date?Summary: Content (required): What is the difference between Order Date (Time folder) and Creation Date in Procurement - Purchasing Real Time subject area? As per the ana…
-
Asset Transactions Real Time'. Which subject area can be joined to get the project informations.Summary: Hello Team, I am using this subject area to get the asset transactional details. I need project information. Which subject area can we join so that we can get t…Suhitha K-Oracle 22 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome…Anders W. Langholm 53 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 177 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP