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
-
Getting data from a Data Model to test it (Ad Hoc)Content After the direct SQL query was removed, I am now forced to create a report for my data model when I want to see the data in any other format than XML or more tha… -
Vacation Rules - table where data is stored???Summary Need to know if anyone has identified the table(s) where Vacation Rules are storedContent Wanting to know if anyone has identified where the Vacation Rules are s… -
"Purge Interface Tables" ESS Job failsSummary "Purge Interface Tables" ESS Job fails and Interface table data has not purged.Content Hi, Experts, As per MOS note Purge Interface Table Job - Argument1 (Docume… -
Table which captures the User-Defined Fiscal Classification CodesSummary I am looking for the back end table which captures the Manage Transaction-Based Fiscal Classifications Task DetailsContent Setup and Maintaince > Search Manage T… -
WRS best practice for Financial reports or Oracle BI publisher is more stable?Summary WRS vs BI PublisherContent Where is it recommended to develop a complicated financial report with compairsons Oracle BI Publsiher will be better as best practice… -
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…
-
Fixed LayoutContent Hi, In the invoice report irrespective of number of invoice lines how can I make the particular section to be printed always at the bottom of the page. Is there … -
How to idenitfy attached expense at line levelSummary Need to find query for attached expense at line levelContent Hi, I am trying to create a table which shows the expense line and it's attachment. Currently I have…
-
BIP report deployment by using web service with object permissionContent Hi, Experts. I would like to deploy BIP report and data model by BIP web services from Test instance to Production instance. Each Object has specific permissions…
-
Need Help with a Deep Link for RequisitionSummary Trying to Create Drill down from a Simple OTBI report to the Requisition ScreenContent Hello. Looking for some help on what we think is a simple deep link from a… -
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter… -
Parameters not available in favouritesContent Hi, If any analysis report is displayed under Favourites it is not displaying with parameters. Is this the actual behaviour please advise Thanks
-
BIP Global Level Function Data not getting included in output after bursting.Summary Aggregate functions data show's up at report level which are involved in GLOBAL Level functions, but the same Data attributes wont show up, if we burst the file.…
-
Can a BI report be scheduled to email an excel attachement using Schedule Report JobSummary Email an excel attachement of BI report OutputContent Can a BI report be scheduled to email an excel attachment using Schedule Report Job? When scheduling via th…User_2025-02-06-00-15-19-515 67 views 6 comments 1 point Most recent by User_2025-02-06-00-15-19-515 -
Page Entry For OTBI DashboardsSummary How to Create page Entry for OTBI DashboardsContent Hi There, We have a requirement where in we want to have the page entry created for our dashboards. We dont w…
-
SaaS: Replacement of SOAP ErpIntergationService by REST APISummary REST APIs corresponding to ErpIntergationService OperationsContent Hi Experts, Need some information and want to know the REST APIs corresponding to ErpIntergati…
-
Parameter defaulting / autocomplete in Schedule Process formSummary Inconsistent and clumsy LOV selection, lacking autocompleteContent When I need to upload and process FBDI files manually, for example to the AR AutoInvoice inter…
-
List of standard approval workflows in the Fusion ERPSummary List of standard approval workflows in the Fusion ERPContent If anybody have the complete list or document that give the list of standard Approval workflow avail… -
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…
-
ERP-FINANCIAL-Data Migration-CHECK LISTSummary ERP-FINANCIAL-Data Migration-CHECK LISTContent Dear Team, Can you please share the ERP-FINANCIAL-Data Migration-CHECK LIST to avoid challenges. -
Unable to access the Standard Invoice screen from the OTBI Action Link ReportSummary I am trying to navigate to the Standard Invoice Screen from the custom OTBI Report via Action LinksContent Hi , I had created a custom report with the Payable In…
-
FRS scheduler how to pass current month or Date to PromptSummary FRS scheduler how to pass current month or Date to PromptContent We are scheduling FRS reports. When we create batch it requests to enter the prompt values. Thes…
-
what is the role of ar_receivable_applications_all.display columnContent ar_receivable_applications_all.Display = 'Y' or 'N' what will happen in each case. Can anyone explain? BR Lucky -
Under INV_MATERIAL_TXNS table transaction_cost,prior_cost,transaction_value are empty, from where caSummary Under INV_MATERIAL_TXNS table transaction_cost,prior_cost,transaction_value are empty, from where can we fetch/map the fields to get the resultContent Under INV_… -
Adding comments to FRS reportsSummary Add comments to specific cells in an FRS reportContent Hi All, Hopefully someone out there can help me with this, as its driving me slowly mad. We are currently … -
View Objects to get Invoice Headers and its Business Unit?Summary Need Invoice Header and Business Unit of those invoices.Content Hi. I'm working with VO extracts in Tableau. I'm using: fscmtopmodelam_finapinvtransactionsam_inv…
-
Logiacl sql for cross subject area analysisSummary Logiacl sql for cross subject area analysisContent Hello All, I am trying to create a cross subject area logical sql for receivables as below. However I still ge…
-
Customer Part Number/Customer Item Number field found in which tables that should refer HZ and wsh tSummary Customer Part Number/Customer Item Number field found in which tables that should refer HZ and wsh tablesContent Customer Part Number/Customer Item Number fields…
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou…