Category 129
Discussion List
-
AR Aging for PBCS IntegrationSummary: We need to integrate customer Aging data from Oracle fusion to Oracle PBCS . We have customer as a dimension in PBCS. When I tried to customize "Collections Agi… -
What is MRC compliant in Fusion Reporting?Summary: How to check if the reports built is MRC compliant or not Content (required): Version (include the version you are using, if applicable): Code Snippet (add any …Priyanka_Ghosh 33 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Tool to extract query from CatalogSummary: Do we have any tool or any libraries which can be used to extract the Dataset (queries) from the DM catalog? or option to create DM programmatically based on th…sailesh_cloudare 33 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
How can I Archive multiple BI Publisher Data Models & Reports into one .xdo (catalog) file?Summary: How to archive multiple BIP reports in OTBI? Content (required): I believe it should be possible to archive multiple data models and reports into one .xdo file … -
Add Report to Manage Invoice Screen and have it be dynamicSummary: We are looking to add a report to the Manage Invoices screen and have the results of the report be specific to the invoice we are on. Content (required): We hav…Jennifer Tavino 96 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Dynamic page orientation change from portrait to landscape in a single RTF templateSummary: Dynamic page orientation change from portrait to landscape in a single RTF template Content (required): Requirement is to change the Page orientation conditiona…Lakshmi Bandlamudi 164 views 2 comments 0 points Most recent by Lakshmi Bandlamudi Reporting and Analytics for ERP -
Report is taking 17 minutes for 1M record using burstingSummary: Report is taking 17 minutes for 1M record using bursting Content (required): Hi Expert, We have build a report to extract ledger balance and the report is havin… -
Why are SOAP webservices reading sample data of a BI report with Excel layout?Summary: SOAP services - reading data from a BI report, with Excel data: date fields are taken from the sample data (report excel layout) and not from the report output … -
How to get the last instance of BIP report where delivery status = S & use it in FSCM Data sourceSummary: How to get the last instance of a BIP report where delivery status was successfull for a particular parameter and use that detail in Data Source Applicationdb_F… -
Oracle Fusion SaaS Cloud Application ManagementSummary: Looking for pre-built dashboards to monitor your entire SaaS Application like Content (required): Hi Team, We are looking for pre-built dashboards to monitor yo…Spats 44 views 2 comments 0 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for ERP -
Font mismatch between RTF template and PDF outputSummary: Font mismatch between RTF template and PDF output Content (required): Hi Experts, We developed a custom template for the PO PDF report. We found font mismatchin…Venkatesan 218 views 9 comments 0 points Most recent by Rajesh Singh Reporting and Analytics for ERP -
Track setup change report/analysis in OTBISummary: Track setup change report/analysis in OTBI Content (required): I'm looking for a report or to create an analysis in OTBI to track setup change. Who and When Sco… -
Select All columns from multiple tablesHi All, How to select all columns from multiple tables in the BI Data model. select a.*, b.* from table1 a,table2 b I cannot execute above sql statement when both the ta… -
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the … -
RWS vs SmartviewSummary: Hi All, Can anyone provide insight on when should we use RWS and when to use Smartview. Dimensions are same in both methods. Please help me with pros and cons o…Richa Arora-Oracle 24 views 0 comments 1 point Started by Richa Arora-Oracle Reporting and Analytics for ERP -
Invoice Line level Subject Area in FAW OACSummary: Hello, We need to create a Invoice line level report in FAW OAC, but do not find ant relevant Subject area in ERP Financials. Content (required): the Prebuilt A…Yogesh Dhanorkar-Oracle 53 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
What table(s) contain 'Invoice Method' and 'Revenue Method'?Hi, I'm trying to find what tables/views contain the following fields for: 'Invoice Method' - Cash basis, cost reimbursement, event-based, milestone, proportional perfor… -
Ledger Currency are null on some payments in Analysis Payables Payments - Disbursement Real TimeSummary: Ledger Currency are null on some payments in Analysis report using the Payables Payments - Disbursement Real Time subject area. Content (required): Is there a w… -
Parameters used to run the BIP report is not reflected in the HistorySummary: We have other reports where in the parameters are shown on the history. We don't know what's the difference with this specific report why it doesn't show the pa… -
Where to find employee W2 Box 1 and Box 5 Data?Summary: I have a report request for employee's W2 box 1 and box 5 values. Content (required): W2 Data in Oracle Fusion HCM Version (include the version you are using, i… -
Job Set ParameterSummary: I have seeded ESS Job and I want to make a ESS Job set that assign value to the seeded ESS Job. Is there a way I can achive that? Content (required): There is a…Naaman Yulianto 26 views 0 comments 0 points Started by Naaman Yulianto Reporting and Analytics for ERP -
Assign custom role to OTBI reportHi, I have to assign custom role to custom OTBI report and I was trying to assign a role to OTBI report but custom roles are not showing in the LOV. Any suggestions? -
How to change the "subject line" or "from address" details for Accounting Automation emailsSummary: Content (required): We have enabled GL accounting automation process in all our PODs. The issue we are facing is, all the emails from all the PODs are coming wi… -
Need the know table and field name for enterprise contract page to prepare BI reportSummary: I need to prepare BI report on Enterprise Sell contract as per client requirement. Please let me know the how to identify the behind table name on Billing and F…Manivannan V-Oracle 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
How the performance will be affected if multiple user run a BIP report at the same time?Summary: How the performance will be affected if multiple user run a BIP report at the same time? Content (required): If multiple users run the same BIP report at the sa… -
Can we submit a BIP Report as Job from UI using a linkSummary Can we create a link or button in ERP which submit a BIP Report as Job uplon click/press ? Content (required): Version (include the version you are using, if app…Sandeep19rm 56 views 5 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Question on Approval Groups ReportSummary: - How is a delegation visible in the system – will it show on that approval group report? Will it be indicated whether a member of the group was delegated vs co…Abhilash K - Deloitte USI 46 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Is there an option or XDO function to print country name using Country code?Summary: Currently, Client is using a DFF to capture country code for Invoices when the payment is made for a foreign professional. These are of type Payment requests an…Abhilash K - Deloitte USI 23 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an… -
Query to get salesrep assigned to the customer accountSummary: Hi, I am looking for the tables/query to get the salesrep number and name attached to the customer account in Oracle Fusion Cloud. Content (required): Version (…Ram Bala 001 586 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP