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
-
Moved: repeate notes for each purchase orderThis discussion has been moved. -
Customize create accounting jobHi, We have more than 50 ledgers and would like to schedule a create accounting program for all the ledgers. Ledger is a mandatory field while submission of the program … -
Moved: Customer Aging Report for Secondary IFRS ledger.This discussion has been moved.
-
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…
-
How to configure a company's logo for all standard reports?Summary: Hi all, Thank you in advance for your help and support. I am trying to configure the client company's logo on Oracle Cloud for all the standard reports. Is ther…
-
How to get Payment Id and Invoices related to a posted G/L batch?Summary: We need to get the payments and invoices related to a posted batch and prints it (the invoice) in a custom BIP Report Content (required): We're working on a cus…
-
User unable to create report in OTBISummary: User unable to create report in OTBI Content (required): Is there a request that must be submitted for users who have access to various subject area, but are un…
-
find an approver from the setup tablesHi, We don't have any report or workflow to check the potential approver once Invoice adjustment is submitted by the user in Receivables Module. so I am trying to develo…
-
How the system of Oracle Cloud save de period close information?Summary: I want to know if the system save the information of earning or loss of each period. Content (required): In our other system when we create the statement of fin…Jessica Yamilet Valdes Romero 45 views 1 comment 0 points Most recent by Jessica Yamilet Valdes Romero
-
Were Does The 'Generate Audit Report' Data Model reside in BI Publisher.Summary: Hi there, Were Does The 'Generate Audit Report' Data Model resides in BI Publisher ? Content (required): Does anyone know where the data model linked to the 'Ge…
-
Moved: OTBI Report Showing Budget Measures for All TasksThis discussion has been moved.
-
Need to create a View only role for all modules for Finance, Procurement, HCM Need to create a View.Summary: Client has a requirement to create a View only role for all modules in order to give access to Auditors. Can you please assist if this is possible to create a V…
-
OTBI Analysis - How to pass only Date for column that is having date and timeSummary: Content (required): The below condition is failing as Application Creation Date is returning date with timestamp and Current_date is returning only date. Applic…
-
Project Budget Vs Actual at Task Level ReportSummary: Project Budget Vs Actual at Task Level Report Content (required): Has anyone developed a report that contains Project Budget Vs Actual at Task Level? Version (i… -
Roles given to External Auditors during AuditContent External Auditors will need to view Journal Entries, Invoices, etc and the supporting documentation. What roles have you provided them? We are trying to avoid cr… -
CertificationSummary: Certificate of achievement : Bronze trophy level Only Content (required): Hello, Please note that i have received a certification from Cloud Customer Connect by… -
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table… -
How to delete clobs data from IBY_TRXN_DOCUMENTS tableSummary: After a P2T would like to delete clobs data as those will have production bank account data which we dont want. Content (required): After a P2T would like to de…
-
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …
-
How to replicate values from a calculated column to all table rows in an OTBI analysis?Summary: I have a table that shows columns related to Innovation Management Proposal's instances like Proposal name, profit, proposal type, proposal squad, proposal trib… -
Table/Tables to find the "Cost Center Owner" Name/ID in OTBISummary: We are looking for the exact table name/set of tables through which we may find the Cost Center Owner Name or ID. Any information on the Subject Area where we m…
-
Customizing data model in BI Publisher (Cost Detail Data Model)Summary: I would like to add some fields to the data model "Cost Detail Data Model" in Assets Balances. Content (required): I have copied the file to the custom folder, … -
CASDK-0004 Connectivity Error Between OIC And ERP Using OAuth Security PolicyHi Experts , We are trying to establish connectivity between ERP and OIC. In OIC we are using ERP adaptor to connect to fusion. We intend to use OAuth Authorization Code…
-
Payables Multi-Period ReportSummary: HI, Anybody have AP multi-period invoice reports with amortizations? Content (required): Version (include the version you are using, if applicable): Code Snippe…
-
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…
-
Is there any way to add Item number in seeded account analysis report?Summary: Customer is interested to see Item number in Account analysis report so that he/she can perform GRNI reconciliation Content (required): Version (include the ver…
-
Database connection in FRS reporting studioSummary: New COA is not available when trying to create new database connection FRS reporting studio Please advise Content (required): Version (include the version you a…
-
Two basic BI Report QuestionsSummary: Hi - I am using a custom data model which contains a mandatory parameter. I have defined the report output to default to Excel. I have 2 questions - please see …
-
SUM each Payment row Running Total (YTD) by Vendor ID/Name?Summary: My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors) A running total ( YTD Amount) for each group of Vend… -
Need to perform YTD calculation over ap_checks_all for reportSummary: Hi Forum: my customer would like to insert a YTD column right after Payment_Amount (SQL is over ap_checks_all) but there is no seeded YTD in ap_checks_all table…