OTBI
Discussion List
-
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti… -
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i… -
In OTBI unable to filter the trxs with 0 adjustments and with the status of approvedWhile creating an OTBI report, When we take the source criteria as Adjustment status we aren't able to filter out only the approved ones along with the transactions whic…Surbhi_1-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
When clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp ChangedWhen clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp Changed Is this normal functionality? How can we revert this?PhillipJ 3 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 1.9K views 2 comments 4 points Most recent by MarkS Reporting and Analytics for ERP -
Need to run the BIP report with one parameter which is having 500k Values .Summary: Hi All, I have a requirement to run the BIP report for 500k records which we will pass as a PARAMETER to the report . Please suggest the ideal way to do it . Is…
-
DFF causes error in joint GL and SL subject area analysis in OTBIReposting this question using my corporate ID as I am still having the same issue. I created a joint subject area analysis for General Ledger Journals and Subledger Acco…Walter L Gess 42 views 5 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss Added Font Ma…
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 184 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP -
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
Feasibility Check and Help for a OTBI ReportSummary: I am creating a new OTBI Dashboard for the Payroll Reconcillation Details. The Dashboard will have multiple sections including 2 waterfall charts and once pivot…VaibhavChavan20_ 2 views 0 comments 0 points Started by VaibhavChavan20_ Payroll and Global Payroll Interface (GPI)
-
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p…Sam Solomun 112 views 6 comments 0 points Most recent by 'Yehia Zakaria Reporting and Analytics for ERP -
OTBI is repeating the same values for multiple records.Summary: OTBI is Repeating the same values for multiple records, Subject Area Receivables Journal Real Time and Transaction Real Time Content (please ensure you mask any…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Intermittent Error with Custom OTBI ReportSummary: We are experiencing issues with one of our custom OTBI reports, which had been functioning perfectly until recently. Users have reported that the report intermi…
-
how to derive last day of month in OIC mapper to pass as parameterSummary: Hi All, Could someone please help me in deriving Last day of month based on system date? Content (please ensure you mask any confidential information): I have I…VasanthaFusion90 156 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to pass multiple values in one parameter in OIC mapper?Summary: Pass multiple values into a parameter with delimiter in OIC mapper to invoke OTBI Content (please ensure you mask any confidential information): Hi All, I have …VasanthaFusion90 158 views 9 comments 1 point Most recent by VasanthaFusion90 Reporting and Analytics for ERP
-
OTBI Report filter for first and last date of current monthSummary: Hi Team, I am scheduling an OTBI report. We have accounting date between parameter in report. I am adding filter to OTBI report and want system to take first an…Nidhi Chhajed 1.3K views 6 comments 0 points Most recent by VasanthaFusion90 Reporting and Analytics for ERP
-
Create Advanced Financial Controls Report with Deep Link to AP InvoiceSummary This video shows how to create an AFC report in OTBI with a deep link to drill to an AP Invoice. The documents referenced describe the various deep links that ca…Stephanie Golly-Oracle 531 views 4 comments 4 points Most recent by M.Stafford.FCGVT Reporting and Analytics for ERP -
Unable to get the data of glcoding for unapplied prepayments in otbi reportwe have created prepayment application register OTBI report, and we are getting the glcoding for applied prepayments but requirement to all data for unapplied and applie…Vikas V. Kamat 22 views 2 comments 1 point Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 850 views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI template?Hi Guys In OTBI for “General Ledger - Journals Real Time” I can see 2 fields for a Journal Header I can potentially leverage: Journal Header "Additional Information (Nam…
-
Roles and Privelege to access the "Receiving - Purchase Receipts Real Time" subject area dataHello, We’re working on a report that requires access to the "Receiving - Purchase Receipts Real Time" subject area on Oracle fusion. However, some users are unable to a…
-
How to calculate in OTBI the receivable balance for any transaction on any dateHi all I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current bala…
-
OTBI results in errors saying "The specified criteria didn't result in any dataSummary: Error in OTBI report using the Labor Distribution Cost Analysis Real Time subject area I am using the Projects - Labor Distribution Cost Analysis Real Time subj…Anand.a.Gaurav-Oracle 16 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 118 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe…