Reports
Discussion List
-
How to convert date to Thai and Buddhist era in Custom BIP Report.Summary: Convert date to Thai and Buddhist era in Custom BIP Report. Content (please ensure you mask any confidential information): We have requirement to show dates in … -
Query to get credit memo details applied for an invoiceSummary: Content (please ensure you mask any confidential information): I am looking for the details of credit memo applied for an AR invoice. For the invoice 1004830 he…Rahul K-Oracle 2K views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Difference between Ess Job Derived attributes and AttributesSummary: Content (please ensure you mask any confidential information): We are creating Custom ESS job for one custom report requirement. We need know, what is the real-… -
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 97 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …Thanigainathan R 526 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
Parameter getting defaulted automatically - BI publisherSummary: When I run a report, one of the parameters is unusable because, after I select one value, it gets defaulted to "All" The data model works fine before running th…
-
BI report cannot be restricted with data access setSummary: A user without a data access set(where only ledger A is attached) is able to select ledger A as the report's parameter, and view its data as well. (the user is …
-
Unmask Bank Account number in BI Reports only based in certain user roleSummary Unmask bank accounts in reports based on user rolesContent Hi , I have been able to generate a simple report to show some Suppliers details with bank accounts fo…User_BIDRC 449 views 6 comments 0 points Most recent by Pankaj Dhoopar Reporting and Analytics for ERP
-
Is it possible to export analysis results from pie chart drill down?I've created a performance tile pie chart for an infolet and linked it with an analysis. When you drill down into the pie chart, it provides the requested results from t… -
Is it possible to export analysis results from pie chart drill down?I've created a performance tile pie chart for an infolet and linked it with an analysis. When you drill down into the pie chart, it provides the requested results from t…
-
How to convert the “Amount in words to be changed to Millions and hundreds?We need to get the “Amount in words to be changed to Millions and hundreds instead of Crores and Thousands for all non INR invoices.
-
GL Detail Report w/ Subledger DetailsSummary: Finalize/Tweak built custom OTBI report to export the last bits of data needed by our auditors. We've built a custom OTBI report that exports GL and SLA numbers…Henry Imgrund 64 views 1 comment 1 point Most recent by James McBride Reporting and Analytics for ERP
-
Customer require to extract FRS report data in XML or SQL format. Is this possible?Hi All, Customer require to extract FRS report data in XML or SQL format. Is this possible?Janitha Perera 3 views 2 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
Is it possible to change the date to be used in aging transactions in the seeded AR Aging report?Summary: Is it possible to change the date to be used in aging transactions in the seeded AR Aging report? Content (please ensure you mask any confidential information):…Francine Gemora 85 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Report for Users Activity in Oracle Fusion - Audit ReportSummary: I would like to know if there is any report to see user's login date and time for audit purposes. Content (required): We would like to know when the users login…Sofia Alvarez 1.7K views 5 comments 2 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
need to connect oracle data from php or via MS power bi to retrieve dataSummary: need to connect oracle data from php or via MS power bi to retrieve data Content (required): need to connect oracle data from php or via MS power bi to retrieve… -
Load XML file into the dataset with xmlpserver/services or use BIP as print serverSummary: I am looking for a way to upload an XML file to a dataset that uses an XML file through the services offered by xmlpserver, but I can't find how to do it. I see…Edisson Gabriel López 107 views 3 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Can we use Pivot dynamically in BIPSummary: Hi Experts , We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values whic…Bhavani Rikkula 117 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Project Control - Budgets Real TimeUsing Project Control - Budgets Real Time subject area need to showcase Budget Cost in Project currency as well as in Ledger currency but unable to identify the dimensio…Kalyani-Oracle 22 views 3 comments 0 points Most recent by Kalyani-Oracle Reporting and Analytics for ERP
-
OTBI IssueHi There is an existing OTBI report which attached below. Now the customer requirement is to add the below condition. But on adding this, the count is reducing. Please s…Dona Das-Oracle 31 views 5 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
oracle fusion ESS job request limits per hour.Summary: We have a requirement to run a report through ESS in Oracle SaaS application, expecting 1500 requests per hour. is oracle supports these volume? is there a way …Santhosh Mothepati 211 views 2 comments 1 point Most recent by Gerardo Carrillo Applications Security
-
I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any…S.A.A Dinoli 22 views 5 comments 0 points Most recent by S.A.A Dinoli Reporting and Analytics for ERP -
TIMEZONE Display on the report field - UTC Timezone to EST TimezoneSummary TIMEZONE Display on the report field - UTC Timezone to EST TimezoneContent Hi Experts, I am using the OTBI Analysis (Payables Transactions Real Time) to create a…
-
How to read a tab delimited data using querySummary: I have a text file which have data separated by tab. I need to split that into multiple columns. How i can write a query to achieve this. any idea please. Conte…
-
Sql query issueHi All, We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should sh…Dona Das-Oracle 22 views 3 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for ERP
-
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
How to create drill down charts in Oracle BI Publisher (BIP) Reports?Summary: How to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables? Content (please ensure …