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
-
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio… -
sql for material transaction reportContent i need to create a material transaction report between 2 dates the first i need open balance quantity (sum quantity before the first date) transaction between 2 … -
Fusion ERP REST APIs for China RegionContent I am looking for REST APIs for China w.r.to Fusion ERP. Is there a document ? Can anyone please point me to these documentation? Thanks, Aruna S
-
SOX and Smart ViewSummary SOX is asking how they can know Smart View data is accurate and completeContent Hello, Our SOX team is asking how they can know that Smart View data is accurate,… -
Financial Reporting Web Studio BookContent Hello: We have page inserts in our financial "book" for manually inserted pages. One of the Inserts is using a 2 page insert and needs a 3 page insert (so the pa…
-
Roles given to External Auditors during AuditContent External Auditors will need to view Journal Entries, Invoices, etc and the supporting documentation. What roles have you provided them? We are trying to avoid cr… -
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 26 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126 -
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th…
-
Receivables_ how join different subject areaContent i try to do a report for ar transaction invoice with receipts; i try to create a new analysis. I was able to view the invoice data, I tried to link the collectio…
-
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece… -
Created new CVR and receiving inconsistent testing resultsContent We are wanting to use CVR to only allow users to post to valid account combinations. We have about 1850 new rules that would need to be created and moving forwar… -
Which table store User category and Password expiration DateSummary Which table store User category and Password expiration DateContent Hi Guru's Please let me know Which table store User category and Password expiration Date und…
-
How to remove header from the last page i.e. terms and condition page of the RTF template in BIP?Content Hello All, We have a requirement to remove the page header from the last page i.e. terms and condition page of the Invoice print in BIP report using rtf template…
-
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below. -
Joining two subject areas OTBIContent Hello: I feel like I'm so close. I have the two subject areas and the criteria columns completed. But I'm getting an error when I run each one of them (worked wi…
-
Set Date FormatContent Hi, In OTBI reports is there way to setup the date format globally for all users ? Thanks -
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
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…
-
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…
-
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 -
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display…
-
Financial Reporting Web StudioContent Hello: I opened the Grid of a report we are currently using to make a change (report currently runs fine from the Financial Reporting Center Catalog) and immedia…
-
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…
-
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…
-
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…
-
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 … -
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…
-
Is is possible to merge Business Units in FusionContent Hi, We have a situation where there are almost 20 Business Units for one Legal Entity. This is posing problems like allowing duplicate invoices across BUs but al…
-
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… -
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…