Category 129
Discussion List
-
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 155 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 278 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 54 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 24 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 219 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 24 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 552 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 213 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…Omran Zeaiter 1K views 2 comments 0 points Most recent by Nathan CCC 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 471 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 438 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 32 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 438 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 283 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 632 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
BICC Downloading Files from UCMSummary: We are investing using BICC to schedule extract from Oracle ERP rather than relying upon our existing process of using Custom BI Publisher Reports then bursting…Rob_C19 887 views 7 comments 0 points Most recent by Kristel Janssens 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 33 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.1K 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 42 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? -
Is there any table to store the data model SQL query used while creating a reportSummary: Want to identify a particluar condition being incorporated in all the BIP data models ,once identified it can be replaced as per the requirement . Otherwise we …Hitesh Jasuja-Oracle 59 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Can provide READ ONLY option for report/ layout and data modelSummary: Can provide READ ONLY option for report/ layout and data model Can provide READ ONLY option for report/ layout and data model?Narendra Prasad Golla 32 views 2 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP
-
SQL query tunningHi, I have developed a sql query to get the balance for a couple of months ( it may be up to 12 months) and it's taking more than 40 mins and ended up with timeout error…