Category 129
Discussion List
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 1.1K views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP -
FUSIONAPPSS_REQUEST_IDSummary: I'm trying to modify the ChartOfAccounts report in order to add new filters to the query, but as soon as I add the parameter :fusionapps_request__id the DM stop…Victor Bocardo Negrete 11 views 0 comments 0 points Started by Victor Bocardo Negrete BI Publisher Learning Center
-
Is there any functionality to have dynamic reporting parameters while scheduling FRS Reports.Summary: While we are scheduling FRS Reports, we need to add the ability to have dynamic reporting parameters for FRS reports. Recreating applicable schedules every mont…Abhishek khanduja 291 views 2 comments 3 points Most recent by Henry Pao Reporting and Analytics for ERP
-
Sql Query to get data security applied on Chart of AccountsHello, I need an sql query to get my user's data security on the chart of accounts values. Thanks,
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
R23 ERP OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 ERP OTBI subject areas to database tables mapping spreadsheets, R23 SCM OTBI subject areas to database tables mapping spreadsheets and …Mike.Myers.CDIPRODUCTS.COM 262 views 1 comment 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for ERP
-
How to find latest record in table PJO_PLAN_VERSIONS_B for projectSummary: Hi Team, I want to know how to find the most recent record in PJO_PLAN_VERSIONS_VL as version_number is same for all 3 rows. Regards Nidhi... Content (required)…Nidhi Chhajed 291 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
SQL query to fetch Purchase Requisition Audit History using BI ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Revathi I 75 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Issue with OTBI Subject Area "Installed Base - Meter Based Asset Usage Real Time"Summary: Our issue is with the OTBI subject area called “Installed Base – Meter Based Asset Usage Real Time”. We can’t figure out how to exclude the canceled readings fr…Ajeez K-Oracle 21 views 2 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 284 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
date masking reverting date back a daySummary: We have customized the AP invoice approval report to add fields needed. Content (please ensure you mask any confidential information): Issue is that the date in… -
Statement of Directions on FRS in Cloud ERP?Hi, Does anyone know if/when FRS is going to be retired in Oracle Cloud ERP and moved to Management Reporting like is being done in EPM? Trying ot understand if we wait …Hyperion_Junkie 21 views 1 comment 1 point Most recent by Hyperion_Junkie Reporting and Analytics for ERP
-
Report output name incorrect when downloading scheduled job outputs after upgrade to 23DSummary: We scheduled reports and when downloading it is generating name with % instead of space , but when republished it gives correct name for output file after upgra…Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
ESS Job vs BIPSummary: ESS Job vs BIP Content (required): Assuming we don't have any dependent list of values, is there any strong/security reason we should use ESS Job on top of the …Vinay Gharge 602 views 2 comments 0 points Most recent by User_8FGMM Reporting and Analytics for ERP -
How to get customer AddressType from background tableSummary: When I enter the url below in browser, I can get AddressType, I need to build a data model and get similar info for a customer. https:///crmRestApi/resources/11…
-
In which table I can find readable names from HZ_CUSTOMER_PROFILES_F.STANDARD_TERMS?Summary: I would like to get readable names from HZ_CUSTOMER_PROFILES_F.STANDARD_TERMS, how can it achieve it? In link HZ_CUSTOMER_PROFILES_F, it shows STANDARD_TERMS is…boeingdream 244 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 532 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP
-
How To get Cancelled Invoice Amount in AP Invoice in Oracle FusionIs there any ways to retrieve Cancelled AP Invoice Amount in Oracle Fusion Using SQL Script.EPNSLsupport 491 views 4 comments 0 points Most recent by EPNSLsupport Reporting and Analytics for ERP
-
Can I have a link for data lineage for 24 A versionSummary: Can I have a link for data lineage for 24 A version Content (please ensure you mask any confidential information): Version (include the version you are using, i…Prateek Dhawan 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Can we default a parameter with dynamic value in ESS Job definition?Hi, We have a custom ESS Job defined for a BIP Report with a parameter Period Name and attached a custom LOV data source defined which lists the periods from gl_periods.…Rajendra Kona 521 views 2 comments 1 point Most recent by Rajendra Kona Reporting and Analytics for ERP
-
ZIP and PDF inquiries for Oracle BIPSummary: 1. We are trying to create bursting email which sends 1 zip with multiple pdf(separated by invoice). 2. In history we have a consolidated output which has 1 zip…
-
OTBI report is taking very long time to complete.I have built one Payroll OTBI report. I have been able to run it successfully from my private folder in the Prod environment, but when we load it to the Payroll Team fol…Chetana Pawar 363 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
Not able to create analysis report while using a enquiry role.We need to grant users an "enquiry" role, which allows them to create analysis reports but restricts them from editing pre-existing reports. As we have added all the ana…
-
How to escape double quote character in .csv file of BIP ReportSummary: We have enclosed few columns of the BIP report within double quotes and output is expected in a csv file. This will overcome the columns having comma getting sp…Rakesh Soma 761 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
User should be able to create a new OTBI Report(Analysis) but will not be able to edit the existing.Our requirement: We need to create a custom role in which a user should be able to create OTBI Reports by using subject area "Procurement- Procure To Pay Real Time" but …
-
Querying GMS_XCC_BUDGET_BALANCE_V results in timeout error in FusionWe are getting timeout error while Querying GMS_XCC_BUDGET_BALANCE_V results in timeout error in FusionAbhilash K - Deloitte USI 51 views 8 comments 0 points Most recent by Simon Hong Reporting and Analytics for ERP
-
The Picture can't be displayed error in multi sheet excel templateI created an excel template which has multi tabs created dynamically. Logo in first tab displays fine while in rest of the tabs it displays error The Picture can't be di…Aakancha 31 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
BI Publisher - reference another group value from within a nested grouped areaSummary: BI Publisher Template: Reference a high level value from a lower level repeating group Content (required): I have a repeating group in an rtf template using BI …Robert of STAU 1.2K views 1 comment 0 points Most recent by Michael Angelo Lucena Reporting and Analytics for ERP
-
how to display clob data in oracle in readable formatSummary: My results are not as expected even i I followed the below link https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-6C8C333C-FF56-4376-9914-C298DF0DCE83.htm…Rama Krishna Annam 51 views 6 comments 1 point Most recent by Viswanadh Reporting and Analytics for ERP
-
unpaid reason lookupHi Experts - In Collections we have "Unpaid Reason" List . Can you please help me with the lookup so I can add more values?