Category 129
Discussion List
-
What would cause the same data to be bursted across multiple days?Summary: We have quite a few Bursting notifications but one of them bursts the same data across two different days. This Notification is a generic email and an excel att…Rebecca Hawker 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Find corresponding data of field in oracle database table.Hello, I am currently looking for the following information: From Edit Payment System page Field: "Name" From Edit Payment System Account page Field: "Name" From Edit Fu…Wellan G. Acrise 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem…
-
Licenses for Development ToolsSummary: Hello All, We are using the below development tools provided in Oracle Fusion and want to know if any additional licenses are required apart from Oracle Fusion …Sarthak Mohanty 41 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Why is the content server not opening correct document for maintenance work definition attachment?Summary: In the Manage Maintenance Work Definitions screen, each maintenance work definition code has an operation with an attachment. This is the .txt file that contain…
-
removeposted to the wrong place!Monique 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m…dennisepanopio 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How can I replicate data from a pivot table in an RTF report (BI Publisher)?I have a report for transaction build using BI publisher what is giving is the customer X is shown just once with multiple transaction what i want is to have the custome…Omran Zeaiter 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Oracle BIP Report Not SummingI need your help in my RTF template that has a sum for every each segments. I added the field in the cell, set the Calculation to Sum and checked the Grouping. Generated…Sofia Danielle Sarmiento 31 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…Jennifer-Leung 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to install oracle report builder to read legacy reportsHi All, we are in process of decommissioning r12 as we have moved into cloud. For reporting purpose we need some of the custom, standard rdf reports and their underlying…Kasthuri Haridass-Oracle 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Splitting Of master detail records into new detail result if detail data exists more than 2k recordsSummary: Hi Team, We have a requirement to develop master detail report with master data set containing header level details of transaction and detail data set containin…Bhanu Priya 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to show the data label (Count) in all the colors of Stacked Bar Chart in the RTF Template?Summary: We have a requirement to display the number as data label in the RTF Template – Stacked Bar Chart. The count is being displayed only in one colour and it’s not …SARAVANA KUMAR T-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Custom Report error out due to in put string ending with "."Hi - We have a custom report which uses XSL Stylesheet which errors out due to input string ending with "." which is a valid value. I would like to ask how we can modify…jhaira_18 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real TimeSummary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and …Rich Merkel 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to send excel output to legacy systemHi, We have a custom ESS job and generates the output in excel format and can't enable it in csv format as it's exporting all the columns which we don't want. We have a …Madhu A 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
In Event Triggers: Alternative solution for passing multiple values into a single parameterIn event triggers, I need to pass a multiple values to a single parameter and upon research I realized that oracle does not provide such feature. I need a alternative so…navya Nallamotu 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma…Dhilip Kumar P. 11 views 2 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
general ledger journals via subledger to receivablesSummary: BI publisher → SQL → Journal General Ledger Journal Data joining to Receivables at distribution level of detail Content (please ensure you mask any confidential…Robert of STAU 51 views 8 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
็How to custom Trial Balance ReportSummary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential infor…Patumwadee 121 views 1 comment 0 points Most recent by community-dw-integration Reporting and Analytics for ERP
-
Requisition Approvals History - Approval history has been purged and no longer availableWe are getting the error 'Approval history has been purged and no longer available' when to view document history in requisition and purchase order. Is there any tables …Kishore Kumar Reddy Bhushanam 95 views 1 comment 1 point Most recent by Lego Mathew-Oracle Reporting and Analytics for ERP
-
How to print "All" value in the output if BIP report is run for all parameter valuesHello Oracle Gurus, I have a requirement where the user is running the report with all parameter values. The parameter is Source. Currently if the user runs the report f…ShitalRamteke 724 views 8 comments 1 point Most recent by Sachin Dharmik Reporting and Analytics for ERP
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 3.2K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP
-
how to get json formatSummary: Hi, We've a requirement to format output into Json format. Is it possible to do OTBI / BIP Report in this format? Any help is highly appreciated. Thank you! -
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t…AndresGlz2109 202 views 4 comments 0 points Most recent by AndresGlz2109 Reporting and Analytics for ERP -
SQL for Project Events InvoiceSummary: Trying to get the approved Invoices only and I am getting incorrect values. Content (please ensure you mask any confidential information): Code Snippet (add any…
-
FUSION_APPS_PROV_PATCH_APPIDSummary: we saw in audit log that the user- Provisioning Patch Application Identity - user ID: FUSION_APPS_PROV_PATCH_APPID has added the role ORA_FND_APPLICATION_DEVELO…
-
Hide Custom ESS Job Parameters LOV Seach FieldsHello, As the client requirement, we create a Custom ESS Job to run a BI Publisher Report. For this report, we need a few parameters, and for two of these parameters, ex…Arthur Teodoro 81 views 6 comments 1 point Most recent by Shashank_hegde-Oracle Applications Security
-
How to remove double quotes when getting output in csv pipe delimited from BI ReportHow to remove double quotes when getting output in csv pipe delimited from BI ReportLakshmiVanarasi 28 views 3 comments 0 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
Ability to get the Payment Approval Rule details defined on BPM by queries in Reports and AnalyticsIdea Number: 707234…Thomas De Leeuw 11 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for ERP