Category 129
Discussion List
-
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F…Rihan Jameel 43 views 4 comments 0 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
Financial Reporting Webstudio Performance IssuesSummary: Oracle closed out the old discussions on this topic. We are still facing (on 22B) performance issues with Financial Reporting Webstudio. We are interested to he… -
Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO…
-
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …Bernard T 82 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Report that shows project codes and cash receipts associated with that projectSummary: I am working on generating a report that shows both the project codes and the associated cash receipts/revenue detail with regard to that project - grant revenu…
-
Working on PO detail report that includes change ordersSummary: I need to create a detailed report that shows all PO detail including all change order activities - this could also be a requisition report if that is the prope…Sara Ro 13 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 97 views 2 comments 0 points Most recent by Farooq H Syed Reporting and Analytics for ERP -
Receivables: Status Tracker in OTBI/BIPSummary: Content (required): Is it possible to report on this Status Tracker in OTBI? Or BIP? And if so which which subject area or which tables are these to find in? St…Nicolas Vahman 22 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to convert hexadecimal to Base64 in BI ReportSummary: How to convert hexadecimal to Base64 in BI Report Content (required): Hi All, How to convert hexadecimal to Base64 format in (SQL) BI report. Need to generate Q…Venkatesan 25 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 42 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
Where to find the Building Society Roll number for a supplier on OTBISummary: I'm based in the UK and need to pull together a report (preferably using OTBI) listing suppliers' bank details that includes the Building Society Roll number or…Fraser HES 40 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…Nicolas Vahman 22 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Is it possible to set up triggers for BICC extractsSummary: Is it possible to trigger a BICC extract to occur only when data has changed? Content (required): We would like to extract data stores that don't support increm…Holly Wells 22 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
How to modify Asset Cost Summary ReportSummary: I'm trying to modify the Asset Cost Summary Report. I created a copy of the DM (path = /shared/Custom/Financials/Fixed Assets/Asset Balances/Data Model/Cost Sum…
-
Custom report for Invoice approval workflow detailsSummary: Custom report for Invoice approval workflow details Content (required): Hi All, We got a requirement to develop BI report to show AP Invoice approval details li…
-
Oracle Fusion the seeded report "Receivables Aging by General Ledger Account Report" custom steps ?Summary: Seeded Report name - "Receivables Aging by General Ledger Account Report" custom steps ? How to use the Report parameters used in this scheduled report in some …
-
Legitimacy of SQL Writing Softwares like Cloud MinerSummary: Content (required): Hi Gurus, Recently, we heard that softwares like Cloud Miner is helpful in writing SQL query in Fusion BI without the need to create a repor…
-
OTBI legal entity of AP invoiceSummary: Content (required): We want invoice header LE information in the report but as soon as we are adding payment details it starts showing payment LE information. S…Vinay Gharge 13 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Invoices on Hold with Matching DetailsSummary: I cannot find a good screen that will show you the pricing or quantity details that are behind a matching hold, so I created this set of reports that I hope you…Pam Clark-Oracle 12 views 1 comment 2 points Most recent by Pam Clark-Oracle Reporting and Analytics for ERP -
Is there a setting in BICC so that data store extracts handle special characters correctly?Summary: We are finding that special characters are not being exported correctly in our data store extracts. Is there something we can do to export the characters correc…
-
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu…Elena Ramona 200 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Data missing in outbound integrationSummary: Data missing in outbound integration Content (required): Hi Experts, We implemented GL Journals outbound integration between fusion and AWS SFTP server. We have…
-
Is it possible to hide a graph prompt?Summary: I have a requirement to hide a graph prompt, because the graph is being updated by clicking in another table as a master-detail event. Content (required): It se…Anders W. Langholm 18 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to access the sample XML for the Printable Expense Report Template?Summary: I need to customise the Printed Expense Report Template to suit client's requirements. I understand that the seeded report does not have an associated Data Mode… -
BLOB in sql query datamodel, how to display readable values?Summary: In BI in a datamodel, how to display in readable format a BLOB value? select adhocschedule from fusion.request_history This value only displays: ��¿¿ ¿
-
Is there any Supplier Statement Report?Summary: Is there any Suppliers Statement Summary Report? including Opening and closing balance paid and unpaid invoices. Content (required): Supplier transactions Versi… -
Sequence Command for BI PUblisher eTextSummary: Sequence Command for BI PUblisher eText Content (required): Hi Folks, I'm using eText template to do payments, I need a unique id for each payment but for each …Eliel Douglas 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Where can we see warnings after FBDI import of customersSummary: Where can we see warnings after FBDI import of customers Content (required): Where can we see warnings after FBDI import of customers. I cannot find them in the… -
How many columns we can have in data modelSummary: Maximum number of columns we can have in data model Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Nidhi Chhajed 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Failing to retrieve data from presentation layer when trying to export BIP folderSummary: Our team is using the VBS pipeline to export BIP reports from the dev region to the sat region. Everything was working correctly and then it stopped working on …Scott McAnally 2 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP