Category 129
Discussion List
-
Need help for getting Average cost of an item column in OTBI Subject areaHello experts, I need some quick help in for my OTBI Analysis which is for supply chain module. I want to calculate the Sum of Debits and Credits in Inventory. For that …NIKHIL M Y 52 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
display column based on promptSummary: I want to add a prompt (Yes/No) to display a column. I'd settle for a prompt that forks to two different results tables as well. Content (please ensure you mask… -
How to run US 1099 Electronic Media Report for a specific vendorHi All, We need to submit an electronic file for one vendor we missed. Is there an option to run the US 1099 Electronic Media Report for a specific vendor. There seems t…Lakshmi Kanchi 11 views 2 comments 0 points Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
SQL query to get the Item Category HierarchySummary: SQL query to get the Item Category Hierarchy Content (please ensure you mask any confidential information): Version (include the version you are using, if appli…Lakshmi Bandlamudi 951 views 1 comment 1 point Most recent by Kumar -Oracle Reporting and Analytics for SCM
-
Does an expense listing report exist?Users are wanting to run an expense listing report - does anything exist similar to what existed in EBS r12? Or alternatively is there a form where this can be extracted…
-
Data Model Default parameter to current periodOn a Data Model for a report I have a parameter for the period that I would like to default to the current period. The parameter is a Data Type of Date and a Parameter T…
-
secure flexfield by role on Purchase requisition lineSummary: Hello, Is it possible to secure a DFF on the requisition line by role ? Content (please ensure you mask any confidential information): Version (include the vers…
-
How to use Projects related Condition in AP Invoice Approval RulesSummary: We need to use Project related conditions in the AP Invoice Approval Workflows. Please suggest. Content (please ensure you mask any confidential information): W…Narasimha Rao Kondapalli 11 views 4 comments 0 points Most recent by Meghana Gaddam-Oracle Reporting and Analytics for ERP
-
Reporting on Approval Transactions outside HCMSummary: Is there a subject area or report for Approval Transactions that are not HCM related. I know of the Human Capital Management - Approval Notification Archive Rea…
-
How do I keep a table with repeating elements from breaking across multiple pages?Summary: I am trying to develop a PO rtf template to upload in BI Publisher. When the file runs if the PO is too long, part of the items table that has a repeating eleme…
-
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 74 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 35 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 23 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 21 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 65 views 7 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP
-
Alex Glose 21 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 143 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 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Lakshmi Kanchi 57 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