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
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…
-
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…
-
Unable to download Financial Reporting StudioSummary Unable to download Financial Reporting StudioContent Our customer has financial reporting report which needs to be opened through Financial Reporting Studio. I t…
-
I am looking for a way to get the value of a custom field (data type: NamedIDLabel) that I have creaSummary I am looking for a way to get the value of a custom field (data type: NamedIDLabel) that I have created in my contacts table.Content I am looking for a way to ge…User_2025-02-03-22-06-34-432 23 views 0 comments 0 points Most recent by User_2025-02-03-22-06-34-432
-
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…
-
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined …
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…
-
query to get item cost to secondary uomContent if i have an item has prinary uom and secondary uom. i need to get item cost for secondary uom.
-
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…
-
Passing a Dashboard Variable to all BI reports on dashboardSummary Passing a Dashboard Variable to all BI reports on dashboardContent Hi All, I am preparing a dashboard to show multiple charts / reports embedded. I would like to…
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…
-
query to get item price from po and other expenses from landed cost(trade operation )Content i need a query statement which get item unit price from po + get all expense for this item from landed cost(trade operation )
-
seeded report for landed costsContent i need to know, what are the seeded reportd for landed costs ?
-
Fusion Reports for BAS/GSTSummary What reports Oracle Fusion has as standard for GST/BAS reportingContent Hi Team, We are seeking your direction on the reports that Oracle offers for reporting GS…Muralidhar.Gandrakota-Oracle 141 views 0 comments 0 points Most recent by Muralidhar.Gandrakota-Oracle
-
Cloud Financials on Macbook / Mac OSSummary Is Oracle Cloud Financials supported on Macbooks/MacOS?Content Hi, I'm posting to find out what level of support is offered for Cloud Financials on Macbooks/MacO…
-
How to access the New DashboardSummary How to access the New DashboardContent I have seen this post online but not sure is this Oracle Fusion OTBI Dashboard or need separate license or product. Please…
-
Need to use a parent value in offset in Wizard based allocationSummary As per clients requirement, we need value for 2 segments in offset be picked up from source. Source has parent value entered in these two segments, whereas offse…
-
Oracle Procurement withholding tax problem - sqlSummary Oracle Procurement withholding tax problem - sql - see no tax code at line location, but populated norec / rec tax at distribution levelContent Hi, this is a sql…User_2025-02-10-15-12-48-631 16 views 0 comments 0 points Most recent by User_2025-02-10-15-12-48-631
-
How Can we import Gl Balances from legacy to Oracle Fusion?Summary How Can we import Gl Balances from legacy to Oracle Fusion?Content Hello All, Can you please let me know what are the ways to import GL account Opening Balances …
-
Contracts Deliverables ReportContent Hello, Does anyone have a Contracts Deliverables Report that they can share? When I am building a report using OTBI Subject Area - I am getting many different st…
-
Source Safe - Oracle Fusion BIPSummary Source Safe - Oracle Fusion BIPContent Hi, Can you please guide me on how to and best tools for setting up Source Safe for Oracle Fusion BIP (ERP/HCM), as we wou…
-
Include 'Comments' from Contract Risks into Subject Area "Enterprise Contracts - Contracts Real TimeContent Hello, I am wanting to include a field called 'Comments' from Contract Risks into an OTBI report that uses the Subject Area "Enterprise Contracts - Contracts Rea…
-
Scheduling/Automation software available to support Oracle Fusion.Summary Scheduling/Automation software available to support Oracle Fusion.Content Hi Experts, We have a requirement to automate and schedule process in oracle cloud. Exa…User_2025-03-10-23-59-44-230 50 views 4 comments 2 points Most recent by User_2025-03-10-23-59-44-230
-
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…
-
query to get cost of item after each transactionContent if i get transactions for an item i need a query to get cost of item for each transactions
-
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…
-
What is the best way to identify whether the current Fusion instance is PROD or Non-PRODSummary What is the best way to identify whether the current Fusion instance is PROD or Non-PRODContent As we need to transfer BIP Reports to different FTP file servers …
-
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 …
-
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…