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
-
Formula to sum up linesSummary Formula to sum up linesContent Hi all, Just wondering if I have PO lines say 3 lines and I want to display the total sum of the PO amount. How to do it in BI pub… -
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…
-
Bank statement balances check reportContent Crossposting here from the Cash Management forum as per Oracle's suggestion. We want to have a report that shows bank statements for which the subsequent bank st… -
How to avoid special characters from rtfContent How to avoid new line feed coming as special symbols from rtf template.? Ex.. text entered to item description from application is like line 1. press Enter Line… -
No response after import sample XML data into excel through BI PublisherSummary No response after import sample XML data into excel through BI PublisherContent Hi all, I have export xml data and want to create xml template in BI publisher in…
-
How to set/enable the menu "Reports and Analytics" regardless of responsibilitySummary We’ve created the BI reports to General Ledger but is not possible see the “Reports and Analytics” option on the responsibility menu area, is possible enable thi… -
Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsSummary Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsContent Hi all, This is 19c new function, "Drill Down from OTBI Subledger Acc…User_2025-02-04-05-26-22-197 77 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197
-
Custom Style in OTBISummary How to change graphs color, stlying in OTBIContent Hello - Is there a way to change or add custom style/color to a graph or chart within OTBI analysis and dashbo…
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
-
Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelSummary Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelContent Hi I have LACLS Colombia reports into Oracle ERP Cloud. However, they…User_2025-01-30-22-31-23-162 52 views 1 comment 0 points Most recent by User_2025-01-30-22-31-23-162
-
How to save a report output with date suffix?Summary How to save a BIP report output with date suffix.Content I managed to get a complete XML output using select query with XMLELEMENT () tag using Data Model. Now I… -
Write Back to the Oracle Financials Cloud from EPBCS using Data managementContent Hi All, We wanted to write back data to Oracle Financials Cloud general ledgers in Actual Scenario. Can we Write Back to the Oracle Financials Cloud from EPBCS u…
-
Custom Role to access Finance related Schedule ProcessesSummary Is there a way where we can provide Finance users to have access to only Finance related Schedule Processes and not other processes.Version Oracle fusion Release…
-
Prompt Variables Not Being PassedSummary Selections from Prompt variables are not passedContent I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas,…
-
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 510 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro -
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha…
-
PO and Invoice Amount - OTBISummary Need to show PO and Invoice Amount in a reportContent Hello - I have a requirement to show the Invoice Amount and PO Approved amount in the same report. I can se…
-
ERP Cloud implementation using Agile methodologySummary ERP Cloud implementation using Agile methodologyContent Good Morning everyone, Has anyone done ERP Cloud implementation using Agile methodology ? Any feedback/le…
-
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea…
-
Usefulness of the Cloud Learning SubscriptionSummary Usefulness of the Cloud Learning SubscriptionContent Hi we are new in the cloud and I am trying to figure out whether the Cloud Learning Subscription is worth th…
-
Schedule and distribute a report to specific usersSummary Schedule and distribute a report to specific usersContent Hello Friends, I need to schedule and distribute a report to specific users. I clicked the "More" optio…
-
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…
-
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
OTBI Project Reporting - ForecastsSummary Unable to locate any measures that relate to past versions of forecasts in OTBIContent Hi, I am in then process of building an in-year expenditure/budget/forecas…
-
PO interface error table getting auto purgeSummary after import PO ESS , Error table is not having error recordsContent Step 1 : Loading Data into interface table Step 2 : Calling Import PO program Step3 : Import… -
19C ThemeContent Hi After upgrade to 19C Patch seems some of the pages have got a black banner at the top with font in grey color . See attached . Any help how to change it back … -
Drill Down Facility in Reporting and AnalyticsContent Drill Down Facility required in Reporting and Analytics. can you please guide me about this task. -
Document Number in OTBI Receivables - Transactions Real TimeContent I am building an OTBI report using Receivables - Transactions Real Time, and I'm looking for the column for 'Document Number'. Does anyone know if this column is…