Category 129
Discussion List
-
Query to get Contract Financial SummarySummary: Dear All, I'm need a report that gets data from the following table in the Contract Financial Summary. What are the oracle tables or Views to get this data from…Patrick Chrabieh 51 views 3 comments 2 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Link between XLA, FA and supplier detailsSummary: Link between XLA, FA and supplier details Content (please ensure you mask any confidential information): We have a requirement to fetch the XLA accounted DR, CR… -
Is there a Supplier Open Balance Letter report in Fusion Payables?Summary: I need a report to list supplier's invoice amount, payment amount, discount amount, prepayment amount applied and remaining balance. Content (please ensure you …Dennis_0427-Oracle 81 views 2 comments 0 points Most recent by Sigrid B. Reporting and Analytics for ERP
-
Which subject area can we locate the consumption advice details?Summary: I'm trying to create an analysis which will me if the consumption advice line is open for invoicing or already invoiced. ex. Consumption Advice Number - PO Numb…
-
Issues with Expense Report DFF's in BI Publisher?Summary: In our expense reports, we have several DFF's set up to pull information regarding miles travelled for airfare, car and rail. The fields show up in OTBI, but no… -
Issue during passing a parameter to OTBI analysis in Page Composer doesn't workIssue during passing a parameter to OTBI analysis in Page Composer doesn't work Description : I am trying to do page customization using the page composer for the "BPA C…Venkata Jagan Mohan Vendra 55 views 3 comments 0 points Most recent by Venkata Jagan Mohan Vendra Reporting and Analytics for ERP
-
Recommended properties/parameters for an image to be used in RTF template of BI PublisherHello Oracle Experts, We are working on with updating the template for PO print to add logo/images. As such, may we know if there are any recommended properties for the …marc.joed.de.guzman 22 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Nees SQL query to get the transaction status of Intercompany transactionsHi team, I'm creating a BIP report to extract intercompany transactions and related details. I need to join 'AP_INVOICES_ALL' or 'XLA_AE_LINES' table to 'FUN_TRX_HEADERS…Tharushi Sathsarani 522 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle Reporting and Analytics for ERP
-
What is the best BICC PVO that matches to HR_LOCATIONS_ALL?Summary: Need BICC PVO that best aligns with on-prem table HR_LOCATIONS_ALL. I've looked at the most recent lineage mapping spreadsheet and the closest one I see is: Con…User_2025-03-07-18-57-57-349 101 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…
-
How to Reduce Sftp Bursting completion times.Hi Team, We would like to inquire if there are any options to reduce SFTP bursting completion times. Currently, we are trying to place 10K files into an SFTP folder usin…Sravan Komminedi 21 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
INV_MATERIAL_TXNSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…RAMESH VANGA 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How to schedule a custom weekly GL report, which includes date parameter of "PostedDate-7"Summary: Custom GL Report which needs to run at 12:05 AM weekly on Tues night and include data only from the previous week. If PostedDate = Aug 6, the report should incl…
-
Recommended approach for data warehouse extract from Fusion FinancialsSummary: We have implemented Oracle Cloud/Fusion Payables and Procurement modules. We have built custom data models and reports to extract data from Fusion and deliver t… -
Best approach to create a report templateHi everyone, I’m seeking advice on the best approach to create a report template with the following requirements (Bi Pulisher report): Year-to-Date (YTD) totals Subtotal…Omran Zeaiter 21 views 2 comments 1 point Most recent by Lucky Sharma Reporting and Analytics for ERP
-
ERP Sofware Version and NameSummary: I need to include the ERP application name and version in a custom report. Does anyone know if this information can be queried? Specifically, I'm looking for th…
-
Why does tax_amt_funcl_curr field table zx_lines not match the amount FIELD in INVOICESSummary: Shouldn't tax_amt_funcl_curr field from table zx_lines match the amount in invoice- View accounting match. we are noticing few cents off for philippines tax_amt…
-
Does the purpose of Cloud Collections related columns in AR Payment Schedule align with EBS R12Summary: We have a custom report running in EBS R12 that we are looking to port to erpCloud. The R12 report references columns: AR_PAYMENT_SCHEDULES_ALL.STAGED_DUNNING_L…
-
Unable to access OTBI dashboard for Procurement - PurchasingSummary: An user can not access to a dashboard for Procurement - Purchasing on OTBI, the user has assigned the purchase analysis role Other user with te same role can ac…
-
Incrimental logic for fetching the data in Custom report is not working as expectedSummary: Hi Team, We have a custom BI report which fetches Customer Invoices related columns. The ESS job for this report is scheduled to run every 15 minutes. The repor…
-
Reporting subledger modules to GL with transaction detailSummary: We're looking for a report that provides information from subledgers into the GL in an Excel like format. For example, we need the project number, expenditure t…Kristen Shimkus 42 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef…Gloria Brewster 31 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP -
job which populates invoices into the fixed asset moduleSummary: Would like to know which job populates invoice data into the fixed asset module. Content (please ensure you mask any confidential information): We're missing so…
-
Iam trying to customize the existing standard Supplier Balance Aging ReportIam trying to customize the existing standard Supplier Balance Aging Report where i want to same and export sample data by inputting parameters against the same data mod…Mr.Bilal 41 views 4 comments 1 point Most recent by Balaji Badrinarayanan Reporting and Analytics for ERP
-
Connection to SFTP is failing from BI ServerSummary: Hi Team, The BI Server connection to SFTP is failing with error "Could not establish connection. java.net.ConnectException: Connection timed out (Connection tim…Nidhi Chhajed 117 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR reportSummary: Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR report, it is showing name only for the seeded value i.e Corporate. P.N - We…Rahul Kumar Gupta.-Oracle 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
printer setupSummary: Questions regarding printer setup Content (required): Hi team, Kindly clarify below points. *BI Publisher >Administration>Manage Publisher>Delivery>Printer>Add …BhargavC 41 views 2 comments 0 points Most recent by Priyanka Girdhar Reporting and Analytics for ERP
-
bicc povSummary: We are trying to extract data using BICC. We need to know whether : 1) BICC POV s can be joined together to get the desired data 2) We can create our own POVs W…DebjaniRoy 31 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Unable to copy shortcut to MyFolders due to Path not found - Check the input path entered errorSummary: Hi, Got this error when trying to copy/paste shortcut of a folder to MyFolders : I have full ownership of the folder that i'm trying to copy the shortcut : Plea…Shashidhar Goud 12 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 267 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP