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
-
LUHN check digitHI All We use LUHN check digit part of the check numbers and transaction numbers extract from ERP to the client payment systems. This is a common requirements in the pay… -
How to pass multiple values in a single parameter in OTBI agent?I have a requirement to prompt user while running an OTBI agent. But I don't see that option. Is there a way we can pass multiple values in a single parameter by using O… -
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta… -
Unable to get OTBI column value for 'Request to Resubmit' Approval actionSummary: We are unable to fetch OTBI column value for 'Request to Resubmit' Approval action on Supplier Registration Request page which is impacting us to develop one ne… -
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… -
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… -
how to do sql query Report Job ID(Report Job History)Summary: How to do sql query Report Job ID(Report Job History) Content (please ensure you mask any confidential information): Look like this Report Job ID is not Correct…
-
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…
-
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…
-
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…
-
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…
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…
-
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 …
-
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…
-
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…
-
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…
-
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 … -
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…
-
Redwood Impact for Oracle Cloud FinancialsWe have been working on the HCM side for the Redwood updates and wanted to confirm the impact that Redwood will have on the Oracle Cloud Finance side. Please let us know…
-
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…
-
How to add Award project burden schedule and burden rate available in OTBI ?Summary: Our business needs ward project burden schedule and burden rate available on OTBI side. Has anyone configured them via flexfields? Content (required): Version (… -
Read only access to data modelSummary: We want to provide read only access to data model for some key BIP reports, to our Internal audit team as they want to review the code behind key sox reports. W…
-
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…
-
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…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
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…
-
Approval Groups Report - ESS JobSummary: Hi, which privilege grant access to this report? We know role Financial Application Administrator grant access but we need which specific privilege as we need t…
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…
-
Only access seeded reports and subject areas in OTBISummary: Client wants a role to allow them to access seeded reports and OTBI subject areas but not any fusion tasks. Is it possible? Can you please guide us?
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…