OTBI
Discussion List
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 610 views 12 comments 10 points Most recent by Melissa Goodrich Reporting and Analytics for ERP -
Query to get all item attachments in OTBISummary: I need a query to get all item attachments (images and documents) in OTBI. Also it's necessary to show item number associated to the attachments. I ask which it… -
How to schedule an OTBI report to run for a subset of the full OTBI report?Summary: I have an OTBI report I created that lists all active Projects, the assigned project managers and total budgeted amount. The full report with all project manger… -
OTBI AP invoice report for approver, approval action date, payment dateSummary: We tried to build one, but the payment date is coming in incorrectly where it says it was paid before the invoice was even created. Anyone successfully build su…Alex Glose 3 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Deeps links for payable invoicei want to create a payable report when i click on invoice number open a new windows have the invoice deatils i want a deeps link for the payable infoices
-
Can we get the UCM file download link in BIPHI All, I'd like to build a report with UCM file name and download link. SQL can extract file name and file id. But how can I get the file download link? Thanks in advan…
-
OTBI Drill Down for AR_Transaction does not work with VIEW actionSummary: OTBI Drill Down for AR_Transaction does not work with VIEW action. It works with the EDIT action. It shows in Deep Links (under Tools) that it's a valid action.…Chris Diltz-Oracle 1 view 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Need to fetch the amount( Debit - Credit) from XLA tablesSummary: Need to fetch the amount( Debit - Credit) from XLA tables Content (please ensure you mask any confidential information): We developed the query to fetch the amo…
-
Link between Cost Management, XLA and GL_Code_Combinations tables in FuisonSummary: Link between Cost Management, XLA and GL_Code_Combinations tables in Fuison Content (please ensure you mask any confidential information): We need to build the …
-
Funnel percentage Graph change to 100%Summary: How I change the Funnel view to have 100% percentage in each phase? As below in the first phase I have 5395, where I've expect o have until 100% percentage Cont…
-
Fusion ERP - Roles x Privileges ReportHi everyone, Do we have a report that lists all the privileges for all roles (including both predefined and custom roles) in Fusion ERP? Something like this: Role | Priv…Jorge Gutierre 44 views 4 comments 1 point Most recent by Jorge Gutierre Reporting and Analytics for ERP
-
possibility to build OTBI analytics report from Cash Management bank statement + Accounting dataSummary: Hi, would like to ask for any hint and help, if OTBI analytics tool is suitable to build report from Cash Management bank statement + Accounts from Primary and …
-
The following KFF segments has set up issues and needs to be resolved before BI extender can be runSummary: We are running: Import Oracle Fusion Data Extensions for Transactional Business Intelligence Output file shows this error: Why are we seeing these errors?. We a…Bo Tøpgaard 41 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICCNeed to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC. In Fusion > Tools > Rep…Stéphane Lamy-Bouchard 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there a way I can concatenate addresses in HZ_LOCATIONS?In EBS, you could call a package (hz_format_pub.format_address()) which would concatenate the address elements when passed the location_id as an argument respective to t…Innovate.Matt 25 views 2 comments 1 point Most recent by Innovate.Matt Reporting and Analytics for ERP
-
Is it possible to filter Receivables Subject Area by a rollup within the Chart of AccountsSummary: Is it possible to create an OTBI Analysis that filters a segment of the Chart of Accounts by its roll-up within its hierarchy Content (please ensure you mask an…
-
Payment History Transaction amount getting doubled OTBISummary: We are selecting columns (Supplier Number, PPR Name, Payment method, Payment number Payment status, Payment History Transaction amount, Payment History Transact…Panduleni Kadhepa 14 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th… -
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…Sudha KOVURU 216 views 6 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
logo in OTBISummary: I am trying to load a logo image on an OTBI Report, I am getting this error. "The file uploaded may contain a virus or otherwise failed to be scanned for viruse…mmjohnson0522 51 views 7 comments 0 points Most recent by mmjohnson0522 Reporting and Analytics for ERP
-
BICC PVO Join ConditionsSummary How do we define joins between PVOs and is there any easier way of doing joins between PVOsContent On the older version of EBS one could have written their own q…Upendra Nayak 494 views 5 comments 3 points Most recent by CSINGH_KCC Reporting and Analytics for ERP -
I have the following error (PER-1531492) at Enterprise Resource Planning (ERP)The documentation shows me this description : “You cannot create a work measure record for the selected unit because future records exist for the same unit. Delete the f…
-
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR…
-
'Payables Invoices - Holds Real Time' subject area has been obsoleted from 19bSummary Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject AreasContent Hi All--> Payables Invoices Holds Informat…
-
Which subject area can we locate the consumption advice details?Summary: I'm trying to create an analysis which will me if the consumption advice line is open for invoicing or already invoiced. ex. Consumption Advice Number - PO Numb…
-
EGP_EXPLOSIONS_V loads nothing, component tables do.Content Hi. I'm querying the view EGP_EXPLOSIONS_V and loads nothing. I queried its individual tables and DO load data: * egp_system_items_b_v * egp_structures_b B, * eg…Gabriel Alejandro Zorrilla 45 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A…Cris_Yee_Allenite 19 views 1 comment 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Unable to access OTBI dashboard for Procurement - PurchasingSummary: An user can not access to a dashboard for Procurement - Purchasing on OTBI, the user has assigned the purchase analysis role Other user with te same role can ac…
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef…Gloria Brewster 31 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP