Category 129
Discussion List
-
How to create ESS job to invoke multiple BIP Reports in oracle fusionHi All, We have a requirement to burst multiple-report output through the ESS job and this job will be invoked from OIC. Can you please help how we can achieve it. Thank…Arunkumar Ponnusamy 71 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to check all the schedules defined in BICC -- by anyoneSummary: How to check all the schedules defined in BICC -- by anyone How to check which all jobs are currently running in BICC How to check which all jobs errored out in…joelroshan92 31 views 4 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP
-
Output BIP Report into JSON formatIs it possible through OTBI BIP report to output into JSON format? -
Period Inventory Valuation Report has no RecordsSummary: Period Inventory Valuation Report has no Records Content (please ensure you mask any confidential information): I am trying to run the Period Inventory Valuatio…Mayura Kalupahana 32 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
BI Publisher Notification - PO ApprovalSummary: I have amended the BI Publisher approval but only certain users see the body of the notifications, others just get an attachment and approval buttons Content (p…Robert of STAU 22 views 2 comments 1 point Most recent by Robert of STAU Reporting and Analytics for SCM
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…NZ-user999 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
I can't find rest APIS to get some columns in work structures, person and assignmentsI can't find the rest APIS to get some columns in work structures, person and assignments. Attached are Excel sheets that include the missing fields.
-
Can we submit ESS job using BIP Report ??Summary: Can we submit ESS job using BIP Report ?? Content (required): Can we submit ESS job using BIP Report by setting data set as Procedural call ? Version (include t… -
African Countries - Statutory Reporting Requirement as per OHADADoes Oracle Fusion Cloud support the reporting requirement in African countries as per OHADA? OHADA stands for The Organization for the Harmonization of Business Law in …SaurabhSinghal26 11 views 2 comments 0 points Most recent by SaurabhSinghal26 Reporting and Analytics for ERP
-
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…
-
Publisher report export to CSV with different columns order when running manually versus schedulingSummary: Publisher report export to CSV with different columns order when running manually versus scheduling. We have a report that runs in the last 4 months scheduled o…Boaz Nurieli 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
BICC Union all - documentationSummary: Does someone have any experience or documentation on implementing using UNION all in BICC on incremental extracts? Content (please ensure you mask any confident…
-
How to get the status of ESS Jobs From UISummary: We need to get the details of ESS Job from UI ,we need Current state , count, time ...) Content (please ensure you mask any confidential information): Version (…joelroshan92 62 views 7 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP
-
Alex Glose 22 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center -
Oracle HCM BIP Report - Employee Hierarchy queryI have a BIP requirement to display the employee details in the report where I need to show the employee details like tree structure. Eg: Manager A has 2 reportees calle…KishoreHari 132 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Human Capital Management
-
VVattikuti 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How to connect to GL Cubes as data source for MDX queriesSummary: Hello, I am trying to run a MDX query in Fusion ERP. But there are no data sources available. How can I create a data source to connect to the GL Cubes within E…rizk7 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Lakshmi Kanchi 53 views 2 comments 0 points Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
Intercompany Reconciliation ReportSummary: Hello, I want to know if there is an intercompany reconciliation report with all Intercompany Organizations together. If there is, can anyone guide me where can…Ayub 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Need to control the access for users from copying/moving BI folders.Summary: Users with BI Author role are able to Move (Drag and drop) the BI folders to a different location. This is causing issues since the report/folder is not found i…Shashikanth Kumar P-Oracle 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center
-
How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP reportSummary: How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP report Content (please ensure you mask any confidential information): Version…ManishKr 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center
-
Print Receivable Transactions Report Custom templateSummary: Print Receivable Transactions Report Custom template Content (please ensure you mask any confidential information): Hi All, We customized the Print Receivable T…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. …
-
How to add sequence number & date in BI excel templateHi, I have developed a Data model and attached an Excel template in BI. I am able to generate the data as expected. However; we have a requirement to add a sequence numb…Madhu A 444 views 2 comments 1 point Most recent by Manoj venishetti Reporting and Analytics for ERP
-
Recommendations to generate a delimited output over 5GB in FusionAre there any recommendations to generate a delimited output over 5GB without timeout and going into error using a report in Oracle fusion. Currently we are generating e…Abhilash K - Deloitte USI 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP -
Query to fetch accounting period on project cost page in fusionSummary: Query to fetch accounting period on project cost page in fusion Content (please ensure you mask any confidential information): Hi Team, I am looking for query /…Nidhi Chhajed 599 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Excel output with Multiple sheets with hyperlink for cross-sheet reference BI Publisher ReportSummary: Hi , I have a specific query regarding the feasibility of a dynamic feature: Is it possible to enable a function in BIP's RTF/Excel template where, upon clickin…Sanmati Patil-Oracle 32 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
OTBI scheduled reports are not getting sent to recipientsReports are not getting delivered. Sometimes its just sending email notification but email doesn't stay in mailbox, it gets disappeared.Adeeba Akbar 12 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Date format issue in RTF formatSummary: We're trying to pass the date period filter criteria to the RTF template as MMM-YYYY, but it keeps coming our as a five digit number. Documentation reflects tha…Jason Parker 11 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to create a BIP Report in excel with a drill down option?Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and …Giuseppe Galluzzo 13 views 2 comments 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for ERP