Category 129
Discussion List
-
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… -
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…Robert of STAU 274 views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
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 57 views 2 comments 0 points Most recent by Sigrid B. Reporting and Analytics for ERP
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…Mayur Gangar 11 views 1 comment 0 points Most recent by Mayur Gangar 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… -
Create Customer StatementHi All, while calling Create Customer Statements ESS job same We Have requirement to pass 'cycle' and 'generate bill parameters' into Statement Generation Data Model. /s…
-
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 41 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 11 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 200 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…JeannieMoore 81 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A…Cris_Yee_Allenite 10 views 1 comment 0 points Most recent by alexey.shtrakhov 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 12 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 44 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 34 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP -
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 34 views 1 comment 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
OTBI Agent - Error Generating DocumentI have an OTBI report that I'd like to schedule to run and send the report via email. I've created an Agent to run the report, but when I receive the results via email, …Steven Woods 30 views 2 comments 0 points Most recent by Mona Mantry 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 42 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP