Category 129
Discussion List
-
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r…bobby.hussey 174 views 10 comments 0 points Most recent by Florence Z Reporting and Analytics for ERP -
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PUGALESWARAN PALANIVEL 36 views 7 comments 0 points Most recent by dgeryol Reporting and Analytics for ERP -
Schedule job list wanted by name of schedule time interval by schedule process by status waitSummary: I need the Report that can show me all schedule process running on interval and because we have many schedule process running. We have no track of those schedul…JayaramK_yash 4 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Hi All, Can you help me with SQL Query for BIP Report Status and report name?Hi All, Do we have any SQL query for BIP Report Status ,report name and report history and the status of the Report?Sunil Kumar C 15 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Can I edit the template of FYI notification myself?Summary: Would you please let me know whether I can edit the templates of FYI notification myself? If yes, where can I find these templates? Thanks. 1, the FYI notificat…Chunqing Wu 164 views 3 comments 1 point Most recent by Rebecca_Edwards Reporting and Analytics for ERP -
Ability to load data into custom objects in file based using API similar to FBDISummary: We have a requirement to upload data into custom objects created using application composer file based, similar to FBDI approach. Has oracle exposed any service…Jepson Erattuparmbil 11 views 2 comments 0 points Most recent by Alex D-Oracle Reporting and Analytics for ERP -
supplier bank accounts fusion querySummary: I am trying to retrive the supplier bank accounts loaded in fusion at supplier header level. I have loaded bank accounts with only BANK_ACCOUNT_NUM. I did not i… -
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…Khushi 42 views 2 comments 0 points Most recent by Antima Rai-Oracle Reporting and Analytics for ERP -
Changing Fonts in PDF Forms within FinancialReportsWe are creating forms in FinancialReports and outputting them as PDFs. We wish to change the font used in these forms. We have confirmed that fonts can be changed on a c… -
Can we customise notifications to users only if there is any data generated after an ESS job runs.Summary: We have a requirement for which we want the notifications/Emails to be sent to users after an ESS job runs every week and if it does not have any data we don't … -
Which table/column store "Update unpaid invoices" of supplier bank accountSummary: Which table/column store "Update unpaid invoices" of supplier bank account Content (please ensure you mask any confidential information): Version (include the v…Saikumar Konduru 31 views 0 comments 0 points Started by Saikumar Konduru Reporting and Analytics for ERP -
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen… -
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia… -
BICC - Oracle AR Invoice Line extended amountSummary: Hi, We are extracting data from oracle fusion ERP using BICC. When extracting Receivables(AR) invoice lines, there is no column like 'extended_amount', basicall… -
Bi Cloud Extract is returning different amount of lines with same parametersSummary: BICC Extract Difference in amount of lines using same parameters Content (please ensure you mask any confidential information): I'm using BI Cloud Connector, da…Andres Celis-Oracle 11 views 0 comments 0 points Started by Andres Celis-Oracle Reporting and Analytics for ERP -
Guidance on Business Intelligence Cloud Connector job orchestrationSummary: Guidance on Business Intelligence Cloud Connector job orchestration Content (please ensure you mask any confidential information): We need to execute JOURNAL_IN…Elisa Rossi 3 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
Customize Report failed to generateSummary: Customize report in Report and Analytic fail to generate in this moth Content (please ensure you mask any confidential information): I have a customize report t… -
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis…Sean-B-01 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Can we track users selecting specific company codes from input parameters of FRS reportsWe have a bunch of FRS reports in which "company" is POV. Users have an option to select the different company hierarchies from LOV of input parameters. A new BU formed …Lakshmi Kanchi 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Some of the PDF attachments not appearing on printed AR Invoice in Print Receivables TransactionsHi Team, We are facing an issue where attachments in receivables transactions are not consistently getting attached or sometimes dropped during the printing of the invoi… -
Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time"Summary: Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time" Content (please ensure you mask any confidential information): Hi - has an… -
We need an SQL query to retrieve all scheduled ESS jobs from the backend in Oracle Cloud Fusion.We need to extract and get the list of all scheduled jobs and programs from the backend in Oracle Cloud Fusion. The extract should include the following details: Job Nam…Kiran Gaikwad 43 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Help finding the audit product id for middleware applicationsIn order to call the API endpoint /fscmRestApi/fndAuditRESTService/audittrail/getaudithistory you have to pass "product". The products for regular fusion modules are eas… -
Transaction Number in Account Analysis reportSummary: Can you please help to determine where we get this transaction number for payroll in Account Analysis report? Content (please ensure you mask any confidential i… -
AP Account Coding Approver CommentsSummary: We have built an AP Account Coding workflow report which pulls in comments that are left by approvers of the account coding. However, we noticed that these comm… -
how can we remove Account Value from Account Description Column? From Inquire: On Details BalancesWe are facing a discrepancy when running queries in GL Detail Balances: General Ledger: Inquiry and Reporting > Inquire on Details Balances The account description colum…User_WV62V 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Financial Tax Register is not picking receivable invoices created using REST APISummary: Financial Tax Register is not picking receivable invoices created using REST API Content (please ensure you mask any confidential information): Tring to create … -
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat… -
BICC Privileges or data access sets required to query PVO ReceivingReceiptTransactionExtractPVOSummary: Need to query PVO FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingReceiptTransactionExtractPVO via BI Cloud Connector. PVO is filtering data. Is there doc…Stéphane Lamy-Bouchard 6 views 0 comments 0 points Started by Stéphane Lamy-Bouchard Reporting and Analytics for ERP -
Scheduling OTBI report to store report output daily in sharepoint locationSummary: Scheduling OTBI report to store report output daily in sharepoint location where user can access directly instead of downloading it seperately from report Conte…