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
-
Search ParameterContent Hi, How to have parameter with search icon as in Supplier or Party field in Analysis report. Thanks -
Procurement - Pending Change Order - Pending ApproverSummary Procurement - Pending Change Order - Pending ApproverContent Hello All, I am trying to get the the "Pending Approver" of a pending Change Order. Let me know if a… -
Extender log fileContent Hi, How to get extender log file of any analysis report, please advise Thanks
-
Scheduling Reporting & Analytics Analysis reportsSummary Need information on invoking an action to change subject description of emailed reportContent Hello: Can someone help with detailed information on how to change … -
No ResultsContent Hi, When I view the results of the report using subject area Payables Invoices - Transactions Real Time I am not able to fetch any records as it says No Results.…
-
Two Subject AreaContent Hi, Is it possible to create analytical report using two subject area as I found few column values in different subject area Please suggest Thanks
-
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax… -
Amount Column MappingContent Hi, In Receivables I would like to know under which subject area and folder does the two fields are available Invoice Amount, Balance Amount Thanks
-
Parameters for custom reportContent Hi, I am registering custom AR report as ESS job but need to have parameters is there any documents/configuration to achieve please suggest Thanks
-
Avoid carriage return character at the end of each line in etext outputSummary Avoid carriage return character at the end of each line in etext outputContent Hi, We have a requirement to remove CRLF at the end of each line in extext output.…
-
How can I either hide or remove columns easily in a data model?Summary data model bi publisher reportContent I have a data model that I have copied this over. I am trying to remove and/or hide some of the columns, and then move some…
-
Drill Down from the Master to Detail via Action Link using case formula columnSummary I am trying to drill from the Master report to the detail report, I am fetching the count of rejected invoices with respect to each statusContent Dear Friends, M… -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Exit the Foreach Loop after fetching once value in XSL TemplateSummary We have an requirement where if there are multiple Invoice lines with PO numbers,but we have to fetch any one of the PO number from lines in XSL template from Pa…
-
Query result shows duplicate records, what is the issueSummary Query result shows duplicate records, what is the issueContent Query result shows duplicate records, what is the issue? select a.ORG_ID , d.PARTY_SITE_NUMBER , c…
-
Financial Reporting Studio Install not available in WorkspaceSummary Financial Reporting Studio Install not available in WorkspaceContent I am trying to download the installation for FRS following the instructions (Implementing En… -
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-…
-
Show Declaration while running BI ReportSummary Show Declaration while running BI ReportContent Hello Experts Is there a place where we can show declaration before running/scheduling a report ?A checkbox will … -
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site… -
Unable to add repeating groupContent HI, In the template when I try to add repeating group I get the error as attached in the screenshot Thanks
-
RTF Template Table Overflow - SolvedSummary RTF Template Table Overflow to a different table in the same RTFContent Hi, I am trying to create a report where the data overflows from one table in an rtf to a…
-
Invoice LinesContent HI, The invoice has 12 lines but in the output I can able to view only 10 lines and I have not set any condition to print number of lines. The output XML has dat…
-
user getting error while clicking on Browse catalog under Reports and AnalyticsSummary User not able to access Reports and AnalyticsContent One of the client user not able to access reports page, he is getting error when he clicks on browse catalog…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
OTBI Reporting reporting Invoice Summary + checking hold statusSummary Wanting to report on Invoice summary (outstanding, in progress etc) but need to be not on holdContent Hi I am using the Payables Invoices Transactions Real Time … -
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 -
Email BurstingContent Hi, After submitting the Print Receivables Transaction report I found that the table AR_BPA_DELIVERY_DETAILS return no records due to which email bursting is not…
-
Supplier Registration Requests Error tableSummary Supplier Registration Requests Error tableContent We are trying to build a BI Report to send out a notification to the Supplier creation requester whose Supplier…
-
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
How to pass field value(s) from Page to OTBI (for report or dashboard generation) ?Summary An iFrame is created in an existing Page layout in order to accommodate a OTBI report. How to pass field value(s) from Page to OTBI (for report or dashboard gene…