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
-
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t… -
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the view PAYROLL_FLOW that trigger a BIP report, but I'm unable to fin…
-
Is there a way to custom the buckets of Aging 7 Buckets?Summary: I need to change the period of the buckets. Content (please ensure you mask any confidential information): Is there a way to create a customized report based on… -
BIP Data Source: Secure HTTP ConnectionSummary: While setting up an HTTP connection in the Data Sources section, I noticed that the only authentication method available is basic authentication. I’m reaching o…
-
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 … -
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 …
-
reports dont appear when emailing a dashboardSummary: We have a dashboard that includes multiple analysis and one report (created from a data model). This dashboard is scheduled to be deliverd by email (not attachm…
-
Issue with Sheet Naming in BIP Report Excel TemplateHi All, We are developing a report using excel layout and enabled Scalable Mode = True under Report Properties. When the number of records exceeds 65531 the records are …
-
Error in OTBI report while using 2 Procuement subject areasSummary: I am trying to create a OTBI report to understand Non catalog Requisitions which are not created from Smart forms. For this i am combining 2 subject areas namel…
-
Need the SQL query used in SaaS Service Usage Metrics ReportNeed the SQL query used in SaaS Service Usage Metrics Report (the one with PDF format extracted from MyServices) as we need to use it in a bursting program under BI Publ…
-
What subject areas and query should I use to get AR Aging report based on BICC Extractts?Summary: I know the AR Aging report is complex with joins to XLA tables, hz tables, ar_payment_schedules, and other ra/ar tables. We are trying to generate the AR Aging …
-
How do I add the FDI link onto our oracle cloud homepageI am looking for the steps to add a link to FDI from our Oracle Cloud Homepage as shown in the screenshot below:
-
Which Table Stores the GL Overridden Natural Account Code in Oracle Fusion?Summary: Hello everyone, I am currently working on a data model in Oracle Fusion and need to identify which table stores the value for the GL overridden natural account … -
Anyone have experience in importing catalog file using PublicReportWSSServiceSummary: Can anyone help us to get the sample payload required to call PublicReportWSSService to upload catalog file in Oracle Fusion ERP application? Content (please en…
-
How to Bind List of Values together so when either parameter is select the other auto populatesSummary: Wondering how to bind list of values together so that when a user selects one parameter, then the other is auto populated and then vice versa. So far all I can …
-
Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OACHi All, Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OAC. Thanks & Regards, Keerthana Sekar
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
ExternalReportWSSService runreport data is inconsistentSummary: When we call a HCM report which has employee info, the contact details info-the phone number value is coming inconsistently. Sometime it gives a empty/null valu…
-
How to restrict schedule process page based on usersSummary: How to restrict schedule process page based on users Content (please ensure you mask any confidential information): Hi All, As of now who ever has access to sch…
-
What are the Oracle plans on releasing the Redwood functionality for Financial modules and any ETA?What are the Oracle plans on releasing the Redwood UI for Oracle Cloud Fusion ERP - Financial modules and any ETA?
-
Table or SQL queries for getting Project number along witht Expense report number ?Summary: Hi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJEC…
-
oracle.xdo.XDOException: Template type 'etext' is not yet supported.Summary: DataException:[INSTANCE_JOB_ID=1343928] oracle.xdo.XDOException: Template type 'etext' is not yet supported. oracle.xdo.servlet.data.DataException: oracle.xdo.X…
-
how to join pjf_projects_all_b and PAY_COST_ALLOCATION_KEYFLEX in fusionIn EBS we used the below query and later it needs to be linked with AP Invoices details…. SELECT hou.name, pcak.segment2 cost_center, from pjf_projects_all_b ppa, hr_all…
-
performance issue in transaction listing reportSummary: I am trying to optimize the performance of GL transaction listing report. It is taking longer time to load the report & after 30 mins it is getting failed while… -
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS roundingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Validate OTBI Table Access for User based on Item Class RulesSummary: We have assigned the group “HPSA_CHANGE_REQUESTER” to Item Class “IC_HPSA”. And then assigned the role “HPSA_CHANGE_REQUESTER” to some users in order to assure …
-
How to output html stored in database as formattedI have a table column zmm_notes specifically where a column for the note text can be stored as formatted text, so the html tags to format are stored in the database. Wha… -
Unable to select Manage Formats from the Report LayoutI need to be able to format a column on a custom BIP to HTML but in the report layout in edit mode, I am unable to select the Manage Formats. What could be the issue?
-
Unable to access Usage Metrics Drill-Through ReportSummary: Dear Concern, We have purchased cloud services through a resell/partner model (i.e. partner users) and now when searching found that some users are getting an e…
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…