To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin… -
Oracle Fusion BI Publisher - Pivot table - Dynamically derive headerSummary: Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name…
-
General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…
-
Payment Approval HistorySummary: We need the payment approval history data to capture the approvers at template level Content (please ensure you mask any confidential information): Hello Team -…
-
How to use if statement for comparing dates in BIP templateSummary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statem…
-
How to increase the attempts to fetch UCM document ID from Oracle Fusion ERP CloudSummary: We have ESS job in source Fusion and we running it from data management side. Sometimes job run long and not able fatch DocumentID. How to increase the attempts…
-
What is the field where I can check the inactivated date of user in fusion.Summary: I want field where inactive date of user gets stored . Also if I delete some role from user I want to have when did I delete the role. Also in Front end I am ab…
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…
-
24B INV_ORGANIZATION_DEFINITIONS_VHi , We were using the following query and post 24B its not fetching data set for users who are restricted for specific BU. Let me know if any one are facing similar iss…
-
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…
-
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
Approval Limit Matrix Report across modulesSummary: We are looking for a report which will take a username as a parameter and them report their approval limits across the various modules within Fusion (PO, AP, GL…
-
Facing issue with excel output from the standard report --Customer Statement Generation Report.We are facing extra columns and spacing issue with that template, Basically it is a standard report based on our requirement we customized that report. While checking th…
-
Is there a way to modify the Online report submission console while executing a BIP report online?Is there a way to modify the Online report submission console while executing a BIP report online. Our customer has about 28+ parameters and the requirement is to always…
-
How to join ZMM_NOTES to RA_CUSTOMER_TRX_ALLHello, I am trying to construct a sql query to pull notes related to AR Invoices, can anyone assist, I had thought the source_object_uid in ZMM_NOTES would join to the p…
-
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI … -
How to enable Export options when analysis added to Reports and AnalyticsSummary: Enable export options below a report from an analysis Content (please ensure you mask any confidential information): We have created custom analysis and made th…
-
Grouping in OTBISummary: Hello, In the screenshot there are 3 lines here coming from one transaction. I want to group these into one line with all the data you can see on the screenshot…
-
Limit Scheduled Process access to only Custom ESS jobSummary: We have created a custom ess job that runs a BI report. The privilege created along with the custom job has already been added to the custom role and our user a…
-
lineage document for SCM AND PPMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Rounding in RTF Template FormulaDear All, I am attempting to round the total of X/Y numbers in a sum, but it's not working using the RTF template. This is my formula: I need to round this equation (cu…
-
Alternative to Oracle BI Mobile appSummary: Earlier oracle provided the ability to scale the report output to fit the screen size of the device using the Oracle BI Mobile app. However, the app is now in d…
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
How does gms_ffr_indirect_expenses table get populated? Is it from another source tableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
split Interactive BIP report into multiple excel sheet outputHi, I have an interactive BIP report which needs to generate output into 2 different formats for which I need outputs to be in 2 separate excel tabs How can this be done…
-
How to create language (billto-site language) dependent BIP invoice template?Summary: We try to find a way (Oracle supported or best practice) on how to use multi language templates depending on our customers bill-to-site language setup. Oracle F…
-
Licenses for Development ToolsSummary: Hello All, We are using the below development tools provided in Oracle Fusion and want to know if any additional licenses are required apart from Oracle Fusion …
-
Report for supplier invoice with address not pullingWe are developing a supplier invoice report BIP report using the below listed tables. Admin users are able to get the data, but the end user with access to just this BIP… -
How to convert date to Thai and Buddhist era in Custom BIP Report.Summary: Convert date to Thai and Buddhist era in Custom BIP Report. Content (please ensure you mask any confidential information): We have requirement to show dates in …