Category 129
Discussion List
-
Job Definitions Created Did not Connect to BIP reportSummary: l need to create job definitions to run reports as scheduled processes. However after l maintained the job definition and BI report's property, the schedule pro…Abby Chen522 61 views 11 comments 1 point Most recent by Lucky Sharma Reporting and Analytics for ERP -
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 52 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the … -
open PO report with receipt datesSummary: We are trying to build a report with open POs and their associated receipts. Content (please ensure you mask any confidential information): Requirements are ori… -
Parameter values to pass to save update Data model of Subledger Period Close Exception ReportSummary: Customer is looking for Customized Subledger Period Close Exception Report to add Supporting Reference columns. Thus looking for an input to know which valid va…
-
where are segment member aliases stored in the oracle financials database?Summary: Where can I find the aliases for individual segment members in the oracle financials database tables? Content (please ensure you mask any confidential informati…josstenger 1 view 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Custom role Project Administrator and Cost Controller cannot see AnalyticsThe custom role that we made Project Administrator and Cost Controller should be able to see the Analytics Widget with Project Dashboard information. However its missing…Fred Benedict 1 view 3 comments 0 points Most recent by Fred Benedict Reporting and Analytics for ERP
-
What is the impact of General Ledger Segment Security on OTBI reportsOracle document 2486655.1 refers to a document which state in Page 26 he operator "Is last descendant of" is not currently supported for Segment Security Conditions in O…ramesh.sivapalan 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Convert English numbers into Arabic numbers in rtfI used function to calculate the summation of the VARI variable in the page and used this to show the number in footer, I need this number to be displayed in Arabic, n…Salma Mohamed Salem 72 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…Mohamed Abdelbar 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to download entire Data ModelsHello, We have created an update of a very complex data model and would like to compare it with the old one. We remember that in the previous versions it was possible to…simonl 51 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 51 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP
-
What is the field where I can check the inactivated date of user in fusion.Summary: I want field where inactive date of user gets stored . Also if I delete some role from user I want to have when did I delete the role. Also in Front end I am ab…
-
Execute SQL Query against Cloud ERP/HCM without using DataModel/BI ReportSummary: Hello, Usually Oracle Fusion BI Report/Data model was used to create SQL(like "select * from poz_suppliers_int") against Fusion DB ( like ApplicationDB_FSCM,App…Vetrivel J 579 views 10 comments 0 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
24B INV_ORGANIZATION_DEFINITIONS_VHi , We were using the following query and post 24B its not fetching data set for users who are restricted for specific BU. Let me know if any one are facing similar iss…Rakesh Sreenivasa 81 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Procurement - Purchasing Real Time project DFF missing after 24B updateSummary: Procurement - Purchasing Real Time project DFF missing after 24B update. This was working fine before the update. Did this get removed from the subject area? Co…MichelleHaynes 11 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Need to know the table and api for Fusion application notification setupWe want to know the tables and web service APIs of the below two locations of notification setup. As we are creating bip reports and integrations for the same. Navigatio…
-
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…Lavina Bansal 321 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI …Lucky Sharma 31 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
How to join ZMM_NOTES to RA_CUSTOMER_TRX_ALLHello, I am trying to construct a sql query to pull notes related to AR Invoices, can anyone assist, I had thought the source_object_uid in ZMM_NOTES would join to the p…Robert of STAU 205 views 5 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Is there a way to modify the Online report submission console while executing a BIP report online?Is there a way to modify the Online report submission console while executing a BIP report online. Our customer has about 28+ parameters and the requirement is to always…Aparna N-Oracle 11 views 3 comments 0 points Most recent by Aparna N-Oracle Reporting and Analytics for ERP
-
How to create language (billto-site language) dependent BIP invoice template?Summary: We try to find a way (Oracle supported or best practice) on how to use multi language templates depending on our customers bill-to-site language setup. Oracle F…Frank.Steinjan 71 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Limit Scheduled Process access to only Custom ESS jobSummary: We have created a custom ess job that runs a BI report. The privilege created along with the custom job has already been added to the custom role and our user a…
-
SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values SourcesSummary: SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values Sources Content (required): I have entered below SQL on the Query b…Ajay Hareesh 231 views 7 comments 0 points Most recent by Sravan Komminedi Reporting and Analytics for ERP -
Grouping in OTBISummary: Hello, In the screenshot there are 3 lines here coming from one transaction. I want to group these into one line with all the data you can see on the screenshot…
-
lineage document for SCM AND PPMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…user4177158 1 view 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Does anyone have a template for annual retirement plan audit information?Summary: I need a report to show Total Gross Earnings, Deferral Eligible Earnings, Employee Contributions, Employee Roth Contributions, Employer Matching Contributions a…Chris West 1 view 0 comments 0 points Started by Chris West Payroll and Global Payroll Interface (GPI)
-
split Interactive BIP report into multiple excel sheet outputHi, I have an interactive BIP report which needs to generate output into 2 different formats for which I need outputs to be in 2 separate excel tabs How can this be done…Ninad Joshi 81 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How does gms_ffr_indirect_expenses table get populated? Is it from another source tableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Annie Li 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP