Category 129
Discussion List
-
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 14 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 2 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 26 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
We would like to understand the New Redwood features for Oracle FinancialsHi Team, Can someone please help us understand What are the new Redwood Oracle financial features? Is there any documentation or screenshots explaining the Finance upgra…Sukumari 158 views 4 comments 0 points Most recent by Alicia Ng-Oracle 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 3 views 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 4 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…
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…Mainur-Oracle 113 views 11 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…
-
Change database timezone?Hello Gurus, I understand that data in Oracle Fusion tables are being stored in UTC timezone. Can that be updated to timezone per Organization's choice? If yes what can …Sheetal VBCS 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Custom FRS Reports not showing up in Financial Reporting center post P2T RefreshSummary: Our Custom FRS Reports are not showing up in Financial Reporting center post P2T Refresh but we are able to access reports using EPM Workspace. This is working …Abhilash K - Deloitte USI 292 views 6 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
sql query to fetch serial number per every transactionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Balance Sheet is displaying 0 figures when selecting Accounting/quarter as parameter in FRCWe have configured the Balance Sheet with parameter as per below But the figures when selecting accounting/quarter in the parameters are not appearing.Kirtee Jeetah-Naran 2 views 0 comments 0 points Started by Kirtee Jeetah-Naran Reporting and Analytics for ERP
-
OTBI report timed out for specific Period onward even data count is similarWe are facing issue with a OTBI report that's part of a dashboard. The user runs the report exclusively through this dashboard. It has been working fine since last one y…Abhishek_Kumar_DTV 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
ESS Job Report Output File NameSummary: After running the ESS job in Oracle Fusion 'Default Document', we can see the output name. Can we set this output name to reflect the order number or invoice nu…User_39SVE 43 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.Roy1823 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Any SOAP or REST calls available to see status of scheduled BIP reports?Hello Gurus, I am looking for SOAP/REST calls that can tell me whether the scheduled BIP report failed or succeeded. The navigation is Reports and Analytics → Home → Rep…Sheetal VBCS 22 views 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP