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
-
how to convert Amount to WordsSummary: in EBS we Used Pacjage AP_AMOUNT_UTILITIES_PKG to convert Amount numbers into Word We see the same package in fusion but We do not understand how to use it - SQ… -
How to change the measures in the Chart based on the Dashboard promptSummary: Content (please ensure you mask any confidential information): We have a scenario involving three types of costs: A, B, and C, which have been added as measures… -
Issue during passing a parameter to OTBI analysis in Page Composer doesn't workIssue during passing a parameter to OTBI analysis in Page Composer doesn't work Description : I am trying to do page customization using the page composer for the "BPA C…
-
Query to find out GL code combinations used in a bank account (LE and Org access Level)Summary: I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle do…
-
Image in BI Publisher template spills into attachment when sent to e-mail outputSummary: Image in BI Publisher template spills into attachment when sent to e-mail output Content (please ensure you mask any confidential information): In BI Publisher …
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.
-
Format Automatic Receipts - Override Email CommunicationSummary: At BIP server level, for the complete POD, is there any option to override the TO email address is being used to communicate any email via bursting query? Conte…
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…
-
How to View BIP Report Output in CSV Without Creating a LayoutSummary: Default the output of BIP Report to csv without having to setup a layout Content (required): In order to set the Default Format of a BIP report to csv you must …
-
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or… -
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 628 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058
-
ESS Schedule Process Job Name not availableSummary ESS Schedule Process Job/Program Name not able find any tableContent Hi All, We need to build a BIP Report for audit purpose with all ESS job details but unfortu… -
Joint Venture Setup and Contributions AnalysisSummary: It seems there is only an OTBI subject area for the Joint Venture module Transactions and Distributions details. There does not seem to be a way to report on an… -
campaign emails are still not being delivered to employeesSummary: Hi Team, I am facing an issue with HCM Communicate campaign email delivery in our DEV environment. I created and activated the campaign successfully, scheduled … -
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc… -
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…
-
create customer statements ESS job output in Excel formatSummary: Requirement is to generate Statements in PDF and Excel format for the standard ESS job "Create Customer Statements". No option to select output type as Excel. A…
-
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 for pillar ERP. The process completes in Warning and logs: BI extend…
-
Guidance for copying seeded report for customizationSummary: As someone new to OTBI, I'm hoping to copy a seeded report (Payables Trials Balance Report) to run for specific vendors. I've copied the report, but don't know …
-
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher…
-
Can the column count of each BICC extract be captured?Summary: We have an ask from audit to confirm that each BICC extract contains the complete dataset for a period of time and that no data was missed and that the file is … -
Missing time cardWe would like to see missing time cards. We have specified Compliance also and existing report related to compliance OTBI gives time entry is missing if anyone creates a…
-
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment …
-
Background Image Not Displayed in Outlook DesktopSummary: Hello Team, I worked on an OIC integration that sends email notifications using HTML code, where the email background is set as an image. However, when the emai…
-
Does anyone know the Oracle BI Publisher Notification can be customized or notDear all, We would like to teach the user to schedule the report, however, does anyone know if this "Job was successfully processed" notification can be customized or no…
-
Dynamic Data field on Interactive DashboardSummary: Dynamic Data field on Interactive Dashboard Content (please ensure you mask any confidential information): I am building a dashboard (in online template builder…
-
In reports and analytics, from which table I can get engineering change order approver's name?Trying to get this info to build a report for the customer. Table EGO_CHANGE_ACTIONS_B is supposed to show the change events, but independently of the event, it always g…
-
Audit Reports History Retention for Work Definitions – How many days?Hi all, I’m trying to understand the retention period for audit reports history, specifically regarding work definitions / records. I know that audit history is not kept…
-
Send Dunning Letter Job getting errored out while trying to load new templateSummary: Hi Team, Send Dunning Letter Job getting errored out while trying to load new template. Attached the error details. Thanks. Vidhya Content (please ensure you ma…
-
Add "manage autopost criteria" to task panelSummary: In Oracle Fusion Financials, we need to add "Manage Autopost Criteria Set" to task panel for the standard role "General Accounting Manager". I mean I create a c…