Category 129
Discussion List
-
FRS- How to replace Period Name with Calendar Date in Column HeadersSummary: Content (required): Hello. For columns in Income Statement we would like to be able to use the Calendar Date instead of the Period Name. For example, if Period …Marisa Escobar 13 views 0 comments 0 points Started by Marisa Escobar Reporting and Analytics for ERP -
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…
-
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…Robert of STAU 37 views 6 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
SOAP - Internal Server Error 500Hi Team, Can you please help in the below context SOAP - Internal Server Error 500 Thanks, Saurabh Singhal.SaurabhSinghal 35 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
How to create a custom tab in oracle fusion UI page?Summary: How to create a custom tab on the oracle fusion UI page? Content (required): Hi Experts, We got a requirement to add a custom tab to enter supplier details. Is …Venkatesan 48 views 8 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti… -
Is it possible to combine the Payables - Invoices and Budgetary Control subject areas?Hello, I am trying to create deep links to the different expenditure transaction types in my budgetary control report and one of the transaction type is for Invoices. Th…
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli Fernando 46 views 11 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How can we get GL accounting date for budgetary control ?Summary: Hi Team, We have requirement to build a report which will have accounting date for each line in budgetary control. How can we link budget and GL tables to fetch…Nidhi Chhajed 14 views 1 comment 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
Historical Depreciation & Total Accumulated Depreciation from Depreciation Real time Subject areaSummary: I am trying to calculated the Historical Depreciation & Total Accumulated Depreciation from " Fixed Assets - Depreciation Real Time" subject area. There seem to…Dharmendra Jha 2 views 0 comments 0 points Started by Dharmendra Jha Reporting and Analytics for ERP
-
How can we get the Ess job 'Approval Groups Report' output files as attachments on email?Summary: We were trying to run the ess job on ERP cloud called 'Approval Groups Report' and get the output files on mail as attachments. But we were not able to see the …sunny.k.singh 64 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Where I Can find Financials OTBI database mapping with ViewObjectsSummary: I am unable to find spread sheet of Finacial OTBI OTBI database mapping with ViewObjects excel. For earlier versions, I have downloaded through docs.oracle.com-…
-
Invoice Filter does not work. Please review and provide any suggestion for this OTBI code.Summary: Invoice id Filter does not work. Please review and provide any suggestion for this OTBI code. Content (required): OTBI Version (include the version you are usin…Abhilash K - Deloitte USI 21 views 3 comments 0 points Most recent by Manu R-Oracle Reporting and Analytics for ERP -
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 13.6K views 82 comments 46 points Most recent by Narendra K M Reporting and Analytics for ERP
-
Data migration from fusion to fusionSummary: Data migration from fusion to fusion Content (required): Hi All, Our customers having two different entities. In that one of the entity wants to move separately…Venkatesan 54 views 7 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
Duplicate lines in Fixed Asset Depreciation reportI've created a simple analysis that pulls the depreciation details from the application and presents it in an overview. Here is the analysis XML: There's an issue where … -
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…Anne Wong -Oracle 317 views 8 comments 15 points Most recent by Frank Meoli Reporting and Analytics for ERP -
Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP?Summary: Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP? Content (required): Dear All, I would need to know if a Finan… -
BIP Security - Need to restrict user from modify and deleting the reportsSummary: Hello Everyone, All the users in our environment have BI consumer role. So they are able to navigate to different folders and they have ability to modify and de…Oracletechnofunctional 46 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP…Joseph -Oracle 24 views 0 comments 1 point Started by Joseph -Oracle Reporting and Analytics for ERP -
Accessing Usage Metrics Drill Through ReportsWe are using version 22B. I received an email about accessing a usage metrics report showing user license consumption. However, I fail to find how to locate / generate t…G8rNtn 429 views 5 comments 0 points Most recent by Ross Walker-Oracle Reporting and Analytics for ERP
-
How to lock down HSGETVALUESummary: Would like to lock down (hard-code / copy-paste) all "HSGETVALUE" formulas, without locking down all the other formulas in the spreadsheet Content (required): I…
-
Subject Area for asset tag numberSummary: Which subject area of assets stores the asset tag number? Content (required): My requirement is to show the asset tag number on the retirements schedule of asse…CKleu 12 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Large number value pushing out as scientific E numberSummary: I have a rtf template that must show opening balance, total invoices, total credit memos, etc and a closing balance. My amount coluns are pushing out values lik…
-
BI Admin role revokation not workingSummary: Hello Everyone, We have assigned a BI admin role to user and it worked fine. It has all the admin privileges. So far so good. We have realized that the user sho…Oracletechnofunctional 12 views 2 comments 0 points Most recent by Dimple Nagesh-Oracle Reporting and Analytics for ERP
-
Check BI role as part of standard user rolesSummary: Hello Everyone, Is there a way or query to check which user roles have enherited the BI Admin/BI auther role ? Please help. Thanks in advance. Content (required…Oracletechnofunctional 26 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to filter by Invoice ID that has had the invoice approval state 'Automatic Rejected'.I want to filter a dashboard to show all invoices that still require action to be taken, that were automatically rejected by the system. I want to see all rows of "Payab…
-
Error in Financial reporting centerHello, I am trying to upload my balance sheets and income statements in financial reporting center, when I navigate, I can't find the different ledgers to select. In add…Victor Chrabieh 22 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
OTBI - Subject Area - General Ledger - Balances Real TimeSummary: General Ledger - Balances Real Time - can anyone confirm this works correctly with Budget and Actual data Content (required): I am trying to construct reconcili…AngelOftheNorth 15 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to get the link for a custom application pageSummary: How to get the link for a custom application page? Content (required): We have created a custom page in our Fusion Cloud instance, were we have gathered our cus…Anders W. Langholm 15 views 3 comments 1 point Most recent by Anders W. Langholm Reporting and Analytics for ERP