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 & Analytics for Fusion Service
Discussion List
-
Calling an external image in bursting.While calling an external image in bip Busting its throws an error on the image. Error: The linked image cannot be displayed. The file might have been remove/renamed or … -
sql functionsLooking for sql function to use inside BIP report which does the following: We have a table column that stores: -AE,BH,BR,CA,CH,CN,GB,HK,IE,KW,MX,NL,OM,QA,SA,SG,US we wo… -
SQL to get employees and their dependents enrolled in a benefit planLooking for "SQL to get employees and their dependents enrolled in a benefit plan" to build BIP Report.
-
what are the seeded Reports/Analytics and infolets in Oracle Help Desk?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: What are the seeded Reports/Analytics and infolets and d… -
Is there a report or analytics for activity notes?Summary: Analytics for activity notes Content (required): Hello, For the Service request module, we need to create a new report that can download the notes from the acti…
-
can we create an ESS job to get output files of any other ESS job and send that output to email?Summary: We were trying to get output of an ESS Job (Approval Group Report) over mail. But unfortunately there is no output option for that particular job in advance opt…
-
How to use event triggers to send a reportI created a report in OTBI that returns urgent requisitions that were not processed by the buyer, but I would like to send this report to the buyer when an urgent line r… -
We would like to show a bank payment type (Receipts Only) in Cash Management to complete Bank RecsSummary: Our staff is trying to reconcile the bank statements (task is completed daily) BUT there are no identifiers that indicate whether payment was received via Maste…
-
We need to download the report for the audit purposeSummary: We need to download the report for the audit purpose. System changes log Authorization change log; add modify, delete. From where we can get this detailed repor…
-
How to setup monthly report generation and sending to mail address every month?Hello, I have a question for monthly generation report and scheduled sending to mail address, how to setup it? Can you please help? Kind Regards
-
Bi Publisher CSV output IssueSummary: Bi Publisher CSV Output Issue displaying all the fields in the output Content (required): Requirement is to display all the fields from the data model output of…
-
How To Restrict Access To Custom and Other Folders in Reports and AnalyticsSummary: We would like to restrict access to reports and analystics folder or Custom folder under reports and analystics. Pelase advise. Content (required): Version (inc…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_TXN_TYPESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_TXN_TYPES? Content (required): Version (include the versio…
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTALLED_BASE_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTALLED_BASE_V? Content (required): Version (include the…
-
How to enable selecting multiple values (not range) for Custom ESS Job parameters in Oracle FusionSummary: We have requirement where user need to select multiple values (not from - to range but random values) for different COA parameters in a custom ESS Job parameter…
-
ZX_REP_TRX_DETAIL_T not giving any dataSummary: I need accounting information for the transactions. zx_lines is not helping since it does not have history data. Tried using ZX_REP_TRX_DETAIL_T, but its not gi…
-
Will a version of SQL Developer that can connect to a SaaS instance be released?Summary: We see other products that are being marketed to allow users to query the tables in the SaaS database. Just wondering if a version of SQL Developer might be dev… -
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…
-
User is not able to run Customer report in OTBI report,Summary: Users is not able to run Customer report in OTBI report, could anyone please let me know which Duty Role or Privilege required to run this report, we have assig…
-
Oracle Fusion: Is there any relationship/link between Security Job Roles and FND ApplicationsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Fetch all the reports detailsWe are aware that to fetch reports details, "GL_FRC_REPORTS_B" table can be used. But it is giving only the Financial Report, do we have any other table which will give … -
Is it possible to add a Payment Date Parameter for Payables Withholding Tax Report.Summary: Adding Payment Date Parameter for Payables Withholding Tax Report. Can you please advise and provide the steps. Content (required): We are trying to add Payment…
-
How to create reports related to tables that are only in PaaSSummary: Hi, We want to know if there is a way to create reports in SaaS that retrieve information related to tables that are only in PaaS. I have created a custom table…
-
Questions on BICCSummary: Questions on BICC Content (required): Hello Experts - We are planning to pull some of the entities from Oracle ERP Cloud to our external DW tables for reporting… -
BIP report output file encoding is changing in different ERPC environment, why this is happening?Summary: We developed a BIP report and for that BIP report client requirement is to send data in particular format and it should be in UTF-16LE encoding . file is in .tx…
-
View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto… -
What is the limitation for how large of an XML string Oracle/BIP can handle?Summary: **This post was created as part of a How to Service Request (SR) Release: 23A Content (required): Customer is getting data from external source using web servic…
-
Moved: 2023SOC Reports and Bridge LettersThis discussion has been moved. -
2023SOC Reports and Bridge LettersSummary: Has Oracle changed the titles and/or naming conventions for SOC letter and Bridge Letters from 2022 to 2023 Content (required): Our External Auditors are questi…
-
Adding static hyperlink to BIP RTF TemplateSummary: I need to add a basic static hyperlink to a BIP rtf template to open a OTBI analysis. I cannot get the hyperlink or even basic text to display once I upload the…