Category 129
Discussion List
-
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 45 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 24 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 21 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 41 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 24 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 21 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 21 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…
-
How to lock down HSGETVALUESummary: Would like to lock down (hard-code / copy-paste) all "HSGETVALUE" formulas, without locking down all the other formulas in the spreadsheet Content (required): I…
-
Accessing Usage Metrics Drill Through ReportsWe are using version 22B. I received an email about accessing a usage metrics report showing user license consumption. However, I fail to find how to locate / generate t…
-
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 11 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 11 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 118 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 11 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 3 views 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 11 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 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How do I remove grouping of grouped columns?Summary: I have created a report with a subject area and it has worked fine... For some reason, it's suddenly decided to group almost all my chosen columns and I simply …Anders W. Langholm 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Customize seeded report "Award Approval Notification Report"Summary: We need to customize this seeded report "Award Approval Notification Report". We have made the changes as per the process but the Award approval notification is…Ashu Raj-Oracle 11 views 2 comments 0 points Most recent by Ashu Raj-Oracle Reporting and Analytics for ERP -
22C PORTAL UPLOAD AS A DELIVERY METHOD FOR CUSTOMER TRANSACTIONSOracle has introduced this feature in 22C - I wanted to check if anyone has used this - I do see that delivery method LOV has a new value but I do not see where we need …Dhruvjoshi23 64 views 3 comments 0 points Most recent by Karan Dass-Oracle Reporting and Analytics for ERP -
Report gives an errorI created a excel template report which data model is working fine but when i run the report which is excel template its give me an error Error The report cannot be rend…Mirza_Adeel 21 views 10 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for ERP