To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
execute multiple repots with one ESS jobContent We have registered an ESS job with a report in ERP bursting enabled. This ESS job will be called from Oracle Integration cloud. it works fine. But we have 20 suc… -
OTBI Drill down to External Cash Transaction - Blank transaction pageContent I cant get the drill down to External Cash Transactions to work in my OTBI Analysis. Everything seems to be fine and I am redirected as expected. The problem is …
-
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
OTBI report - Issue with Expense Transactions Real Time subject areaSummary OTBI report using this subject area no longer shows data from prior assignmentsContent We have an SR for this issue but I'm wondering if anyone else has noticed … -
ExternalReportWSSService sample payload to pass template nameSummary ExternalReportWSSService sample payload to pass template nameContent Hi, Can we pass report template name to ExternalReportWSSService SOAP service which triggers…
-
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
OTBI Report for element entriesContent Hello Guys, I need to create an OTBI report for element entries, but when i try to creare the analysis the system show me the following error: No Results The spe… -
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select… -
Table to get BI Report Template and Data Model DetailsSummary Table to get BI Report Template and Data Model DetailsContent Hello, In EBS, we had XDO tables which stored BI Report and Data Definition details. Do we have any…
-
How to use Flexfield feature at BIP data model?Content Hi, Are there any document about BIP data model flexfield feature? I hope the feature make me easy to query AFF info when I create custome BIP report. Thanks
-
Change ESS Job Description while submitting it from BIPSummary Change ESS Job Description while submitting it from BIPContent In Cloud, we can submit the ESS Job from BIP using "ESS_RUNTIME.set_submit_args" procedure. Is the…
-
Generate Financial Reports and Account GroupsContent I found the Scheduled Process Generate Financial Reports and Account Groups that is supposed to generate the following reports: * Consolidated Income Statement *…
-
Deep Links Results in Blank PageContent Hello, I have created my first Oracle Cloud ERP OTBI report with deep links to invoice. When I run the report, I have a hyperlink as expected, but the result is …
-
Need the mapping of Job Application Names EarHcmEss and FscmSummary Need the mapping of Job Application Names EarHcmEss and FscmContent We have a requirement to create a custom report of the ESS Job Execution details. We want to …
-
tables that stores the submission of BI Publisher reports which are not scheduledSummary tables that stores the submission of BI Publisher reports which are not scheduledContent Hello, Are there any tables that stores the submission of BI Publisher r…
-
Geography Municipalities ExtractionContent Hello Guys, We need to create a report in order to extract Geography Municipalities data, where could we find this information? Best Regards, Giuseppe
-
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…
-
OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap, 27 April 2021, 9 a.m.Content Submit your questions for the OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap session to have them answered during the live event. P… -
Customize Print Receivables Transaction for all Invoice TypesSummary Customize Print Receivables Transaction for all Invoice TypesContent Hello, Oracle has provided 4 different templates for 4 Invoice Types: Invoice, Debit Memo, C…
-
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…
-
How to track the BI publisher report which calling the specific table and attributeContent Hi, How to track the BI publisher report that calling the specific table (eg.POZ_BUS_CLASSIFICATIONS) and attribute. Thanks, Felicia
-
OTBI custom folder security in production VS test environmentsSummary How are you managing your OTBI custom folder security from Production to Test when different?Content I our current environment we have several self service users… -
Joining between database SQL and Excel Data Sources in the Data ModelContent Hi, I hope someone can help me out here. We have created a report where we have defined a data model with a join between an SQL data set and an Excel (xlsx) data…
-
Project Actual Costs - Account CodeSummary Project Actual Costs - Account CodeContent We are creating a report using the Project Costing - Actual Costs Real Time subject area. We are pulling cost distribu…
-
Projects Unprocessed Costs Error DetailsSummary Get detail of Projects Unprocessed Costs ErrorsContent I am trying to build a report using the Project Costing - Unprocessed Costs Real Time to build a report wi…
-
TIMESTAMPADD function in OTBI reporting in UTC and not ESTContent We are using the below function to fetch the data for the previous month in OTBI Reporting & noticed it extracting the data based on UTC time zone and not EST. I…
-
in gl, how i get parent of account ?Content in gl i need to get parent of account segment , how i do this ? in table gl_seg_val_hier_rf i don't have data .
-
Inventory Reconciliation ReportSummary Inventory Reconciliation to GL ReportContent Hello All - I have a requirement to create a sub-ledger report that shows inventory subledger detail and its reconci…
-
find field name behind oracle formSummary find the 'activity class' field in the the AR tablesContent Hello all, Can you please help me with something? I am trying to find out the table behind the Transa…
-
Accessing External DataSource via Fusion BIP reportsSummary We have a requirement to build a report the data of which will be in oracle cloud as well as in external database.Content Hi Guru's We have a requirement to buil…