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
-
'Create Accounting for Assets' Custom ESS Job for Draft Accounting Mode only.Summary: How to create custom 'Create Accounting for Assets' ESS job where Accounting mode parameter must be - Draft only..? Content (please ensure you mask any confiden… -
how to enable incremental value schedule standard report in oracle fusionSummary: how to enable incremental value option while scheduling standard report Report : Payable trial Balance report
-
How to convert PERIOD NAME to Date data type?Hi I am using Between operator in Period Name and it is not working. Period Name is a Varchar type. How to convert it into Date data type so i can use between operator i…
-
How to duplicate a DashboardI need to duplicate and modify an out of the box dashboard: CIP Account Analysis. How do I duplicate it and save it, when I try to do so, I am unable to edit components. -
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…
-
Best Practice for Monitoring Performance and Resolving Issues?Hello, We are experiencing recurring times of slowness in our system and want to better monitor the performance to potentially troubleshoot this problem. When users repo…
-
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o… -
Is it possible to schedule a BICC job to run twice in a day? If yes, how can this be achieved?My goal is to schedule a BICC job to run twice in a day but turns out its not possible to have 2 active schedules for a job. Is this possible to achieve?
-
Is it possible to schedule a BICC job to run twice in a day? If yes, how can this be achieved?Summary: My goal is to schedule a BICC job to run twice in a day but turns out its not possible to have 2 active schedules for a job Content (please ensure you mask any …
-
BI Publisher report parameters do not workSummary: Requisition Header Description based parameter is not working Content (please ensure you mask any confidential information): I have created a BIP report for Req…
-
HCM OTBI Report on all absences with a future or missing end dateSummary: Our IT dept are having a hard time identifying logins that are due for auto deletion due to inactivity but that actually need to be kept open (eg those on long … -
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…
-
facing trouble in printing repeating fields on PDF templateWe are having an issue on PDF template where we need to print multiple invoice lines on an invoice but issue is that we have to fix the space on template where these lin…
-
Approval History - AP Invoice Account Coding Workflow Notification CustomizationSummary: We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query. In BPM Workflow notification we can see the …
-
BICC Extract to get Data Access for UserSummary: We have requirement to get the details of Data Access for User (Containing User ,Roles assigned to User, Security Context etc.) using BICC Extract. Is there any…
-
What is "ORA_FUN_DATA_MAINT_KEY" about and How it worksSummary: is there anyone who knows what is "ORA_FUN_DATA_MAINT_KEY" look-up about and how it works? I've found that that this "ORA_FUN_DATA_MAINT_KEY" look-up code has b…
-
Can we get the UCM file download link in BIPHI All, I'd like to build a report with UCM file name and download link. SQL can extract file name and file id. But how can I get the file download link? Thanks in advan… -
Will Oracle provide NAUPA Reporting format for unclaimed property filings to State?Summary: State of Illinois requires electronic reporting for the unclaimed escheatment property. Will Oracle Fusion create a reporting format in later releases to accomo…
-
QUERY PURCHASE ORDERS WITH RECEIPTSHello everyone, I require a query for a report in OTBI that allows me to reach those values (those in the red box) when I pass the purchase order number as a parameter. -
Need to fetch the amount( Debit - Credit) from XLA tablesSummary: Need to fetch the amount( Debit - Credit) from XLA tables Content (please ensure you mask any confidential information): We developed the query to fetch the amo…
-
How to submit BIP Report in oracle fusion with soap webserviceSummary: How to submit BIP report in fusion with soap Webservice https:///xmlpserver/services/ExternalReportWSSService In this soap webservice need sample payload forsub…
-
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…
-
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign… -
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.
-
How to retrieve Custom Child Object and Custom Field in BI PublisherSummary: Hi, Would like to check how do I retrieve Custom Child Object and Custom Fields in BI Publisher? For example, under the SCM»Innovation Management»Proposal - I h…
-
How to delete chart of accountsSummary: How to delete chart of accounts Content (please ensure you mask any confidential information): Hi All, How to delete chart of accounts which is defined wrongly?…
-
Navigation to ERP AnalyticsSummary: Hi All We have client that buy ERP Analytics license. How to navigate to this ERP Analytics? You can check the screenshot using this link : https://www.oracle.c…
-
Oracle Fusion Workflow Report for all pending transactionsSummary: Is there any seeded Report available for all pending Workflows (PR,PO,AP Invoice, Payment, GL Journals, Expenses, HCM, PPM, OTL,etc). The report should show tra…
-
How to configure an additional Input parameter in Account Analysis Report XLAAARPTHello, We have a requirement to add additional department type Input parameter as a filter in BI Account Analysis Report XLAAARPT. This report is being run through the E…