Category 129
Discussion List
-
What is the difference between Apply of the filter and Refresh of the report outputSummary: We have built a report within a Subject Area, for which we have created a Dashboard. In this Dashboard, there is a section for the Prompt and a section displayi…AnnelizeHenskens 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Duplicated Job Definition not creating privilegeSummary: I am duplicating a delivered job definition and updating it to the custom report created. Based on documentation, it should create a privilege in order to grant… -
OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI template?Hi Guys In OTBI for “General Ledger - Journals Real Time” I can see 2 fields for a Journal Header I can potentially leverage: Journal Header "Additional Information (Nam…
-
Collection Note table?Summary: Collection Note table?! Content (please ensure you mask any confidential information): I am trying to find the table that stores the data for notes related to t…Robert of STAU 154 views 6 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Excessive delays generating XLS output files from Report books starting mid-March 2025Summary: Excessive delays generating XLS output files from Report books Content (please ensure you mask any confidential information): Starting on March 24, 2025, our re… -
SQL - GL Balances for IntercompanySummary: Can anyone help, I understand with subledger queries I can filter to accounting_class_code = 'INTER', is there any equivalent means of getting ONLY intercompany…Robert of STAU 42 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
FRS- How to replace Period Name with Calendar Date in Column HeadersSummary: Content (required): Hello. For columns in Income Statement we would like to be able to use the Calendar Date instead of the Period Name. For example, if Period …Marisa Escobar 61 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Which table holds the error details for failed records from "Customer Credit Hierarchy" conversion?Summary: Hi Team, In order to get the details of loaded and failed records when building a custom Reconciliation Report (BIP) for "Customer Credit Hierarchy" conversion,…Dhilip Kumar P. 2 views 0 comments 0 points Started by Dhilip Kumar P. Reporting and Analytics for ERP
-
Roles and Privelege to access the "Receiving - Purchase Receipts Real Time" subject area dataHello, We’re working on a report that requires access to the "Receiving - Purchase Receipts Real Time" subject area on Oracle fusion. However, some users are unable to a…
-
Enable hierarchy for catalogSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Yi Chin 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Oracle BI Publisher Errors with "Replacing Invalid junk char with inverted question mark"So, I am developing a BI Publisher report in Fusion Financials with an etext template to generate output in a flat file csv format. I have done this 30+ times at least a…Robert of STAU 22 views 3 comments 1 point Most recent by User_PZBRW Reporting and Analytics for ERP
-
I need to restrict record in the BIP report query using Lookup valueThere is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item num…Shahid Qureshi 21 views 5 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Project Budgeting is done at resource level or task levelSummary: Hi experts, Is there a way or a flag or field which indicates if the project budget is done on the resource level or task level ? we are trying to identify that…
-
Historic table for EFF "ego_item_eff_b_" is timing out.I am writing a very simple query to see historical EFF data for an item and It is timing out when I tried to search with the inventory Item ID. What is the issue with th…Ramsha Zameer 11 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Product Master Data Management -
Query or Table for Budgetary Control Settings under Manage Financial Plan TypesSummary: Hi Team, We need a Query or Table for Budgetary Control Settings to get below fields under Manage Financial Plan Types. Content (please ensure you mask any conf…
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…Anne Wong -Oracle 1.2K views 32 comments 19 points Most recent by THawkins_LGI Reporting and Analytics for ERP -
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i…
-
How to calculate in OTBI the receivable balance for any transaction on any dateHi all I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current bala…
-
How to disable logon using username and password in Oracle ERP, EPM and OCICan someone please provide the insights on the below query We need help to understand options around security, namely:- Can we disable the ability to log on using a user…Sheshan Ukkalkar 12 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP -
To restrict access so that only pending workers can use the username and password.Hi All, Can someone provide insights on how to implement restricted access so that only pending workers can use the username and password login while everyone else uses …Sheshan Ukkalkar 23 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP
-
In OTBI unable to filter the trxs with 0 adjustments and with the status of approvedWhile creating an OTBI report, When we take the source criteria as Adjustment status we aren't able to filter out only the approved ones along with the transactions whic…Surbhi_1-Oracle 2 views 0 comments 0 points Started by Surbhi_1-Oracle Reporting and Analytics for ERP
-
Supplier Registration DFFs after Next-Gen Supplier Self-service Registration ImplementedSummary: After implementing the Security Policies against Value-sets linked to Supplier Registration Descriptive Flexfields, these flexfields are no longer available in …Chris Alexander 11 views 0 comments 0 points Started by Chris Alexander Reporting and Analytics for ERP
-
RTF template to enable the checkbox option in generated emailSummary: I have a requirement like need to send mail to Manager asking to wheather contract extension is planned or not with No and Yes checkbox. ? Content (please ensur…
-
BIP Bursting output with CSV fileSummary: BIP Bursting output with CSV file Content (please ensure you mask any confidential information): I am trying to burst a CSV file to an FTP server and I am havin…
-
trigger a Oracle HCM Cloud BIP report based on an onlineSummary: There is a requirement in our project that once a certain transaction is submitted in the system (Newly created candidates' security verification custom field o…
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
OTBI results in errors saying "The specified criteria didn't result in any dataSummary: Error in OTBI report using the Labor Distribution Cost Analysis Real Time subject area I am using the Projects - Labor Distribution Cost Analysis Real Time subj…Anand.a.Gaurav-Oracle 2 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
how to load jobrequisitions.dat with minimal mandatory fields onlySummary: I went through the below documentation before i started doing a basic load of open job requisitions, as part of our data migration requirements: " Examples of L…
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …