Category 129
Discussion List
-
I need a query to obtain Chart of accounts Values on ERPSummary: We are trying to create a report using BI Publisher and We require a SQL query to obtain the chart of account value set values (Value and Description shown on s…Robinson Antunez 2.3K views 3 comments 0 points Most recent by ROBERTO J CAMACHO Reporting and Analytics for ERP -
I was creating multi partitioned external table received errorHello Tom i was creating multi partitioned external table from parquet file but end up having these error did so much research but not able find cause of this error plea…ankeshphapale1234 33 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can we access dashboard prompts value in URL as Dynamically in BIP Report?Summary: Hi Experts, We are having a requirement, whenever user clicks on count then it should redirect to the detail report for those specific values selected in Dashbo…
-
Sql query for Canceled Payment Report.I wanted to fetch the Canceled Payment details from the person results through SQL query.Chetana Pawar 22 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for ERP
-
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash JayavelPrakash Jayavel 31 views 1 comment 1 point Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
In Payment Approval Notification, Can we add one more pdf attachment?Summary: We want Output of Payables Selected Installments Selection Report along with Disbursement Payment Process Request Status Report in the Payment Approval Notifica…Deepa Kumari 21 views 2 comments 1 point Most recent by Mohammed Qurram Reporting and Analytics for ERP
-
bi publisher to oci object storageSummary: How can bi publisher report burst the out to an Oracle Cloud Insfrastructure Object Storage Content (please ensure you mask any confidential information): BI pu…Maria Inocentes 22 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to populate tax rate name under Receivables-Transactions Real time subject area in an OTBIWe built an OTBI report with the subject area - Receivables-Transactions Real time. We do not see an option to select the tax rate name/code such as GST, HST etc. Only t…Lakshmi Kanchi 11 views 2 comments 1 point Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
Scheduled BI Publisher reportSummary: Does a scheduled report need re-scheduling if its underlying BI Publisher template or data model is changed after the scheduling starts? Content (please ensure …Robert of STAU 13 views 2 comments 1 point Most recent by Robert of STAU Reporting and Analytics for ERP
-
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 923 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 33 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 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 33 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 13 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP