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
-
BICC Extract job timestamp used to extract data when there is a failureSummary What extract timestamp is used for each incremental job after a failureContent When there is a failure in BICC incremental job which timestamp is used to start t…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…
-
How can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific users
-
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.
-
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…
-
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…
-
Passing comma seperated parameter values through SOAP requestSummary Passing comma seperated parameter values through SOAP requestContent I running a BI Publisher report through SOAP request. the BI Publisher data model contain th…
-
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…
-
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want …
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…
-
Field in form - how to find the corresponding attribute and tableContent Hi experts :) I have been working in many different ERP systems. Oracle Cloud is new to me. In some ERP systems it is possible in a form to access information ab…
-
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…
-
Curiosity Question_Excel BI Templates NamingContent Good morning! I wanted to reach out to see if anyone has run into the error below when trying to preview data in an Excel template. I am running Excel M365 and a…User_2025-02-10-17-54-21-557 16 views 0 comments 0 points Most recent by User_2025-02-10-17-54-21-557
-
Cross subject area - on which facts are they joined?Content Hi there I have joined two subject areas - Expenses - Expense Transaction details real time - Workforce Management - Work Relationship Real time to get level 2 d…
-
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …
-
can i create report from subject area ?Content as i create report from data model. can i create report from OTBI subject area ?
-
Display OTBI DashboardContent Hi, I have dashboard report called P2P OTBI Dashboard and to invoke from Procurement Tab I created new page from Page Integration and make it visible from Struct…
-
in OTBI I need to send email or notificationContent I created an analysis for suppliers , I want to sent the output by email or sent tontification . if an analysis has a parameter so whatis the solution ?
-
create analysis include onhand quantity and available to reserveContent in inventory i want to use otbi to create analysis include onhand quantity and available to reserve
-
SQL STATEMENT FOA FIXED ASSET DETAILSContent I NEED A SQL STATEMENT FOA FIXED ASSET DETAILS.
-
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem…
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH …
-
EBS Data Extraction SQLContent Hi, I am in the process of migration data from EBS to Fusion can someone help me to get the EBS data extraction queries for Finance (AP, AR, GL) and SCM modules …
-
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …
-
Risk Management Entitlements ReportSummary A listing of entitlements and the access points they are composed of.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file…
-
Risk Management Results by Control Summary ExtractSummary For a specified control, show the last time it was run, by who and how many results it returned.Content * Download the zip file attached to this post * Unzip and…
-
Subledger Details resulting in Duplicate LinesContent I've created a subledger with details, but am noticing the lines are duplicating for my results. I've built the results in a normal table format as well in a piv…
-
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…
-
Cancelling other users scheduled processesContent Hello: We have been looked at documents 1467664 & 1980772 for viewing other Users' scheduled processes, but what our IT has tried, is not enabling a User to open…