Category 129
Discussion List
-
using procurement data for commitment reportingSummary: Looking for a way to report commitment data using procurement data Content (please ensure you mask any confidential information): We currently report purchase c… -
How to dynamic format currency amounts in an RTF template (ref. Doc ID 1588933.1)?Summary: Hello, I have the following challenge that we need to format certain currency fields in an RTF (invoice) template regarding certain conditions WITHIN the templa…Frank.Steinjan 41 views 6 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
Need BICC PVO to get per_location_details_f tables Additional attributesSummary: Need BICC PVO to get per_location_details_f tables Additional attributes Content (please ensure you mask any confidential information): Version (include the ver… -
Is there any table available where we can get status of email sent via burstingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aditi Agrawal2650 31 views 5 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
BICC: Extract is failing with Error while fetching rows from serverWhen we run the following PVO in full extract it's failing due to huge data as row counts are 208,699,447. FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalD…
-
Requisition Report data not match with fusion job requisition data(attached screenshot)Summary: Requisition Report not match with fusion job requisition Content (please ensure you mask any confidential information): In the below SQL code for requisition co…
-
Report on user activities in Oracle Fusion ApplicationsSummary: Report on user activities in Oracle Fusion Applications Content (please ensure you mask any confidential information): Our management is asking for a report tha…JoanB 24 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Help on Defining the LOV in BIP Excel TemplateHi Team, We have requirement to define a Person Name List of value in BIP excel template . Report will be run by Manager. Based on manager scope list of person Name need… -
AD_APPLIED_Patches Patch TypeSummary: The AD_APPLIED_Patches "Patch Type" column has three different types - 'Maintenance-Pack', 'Patch-Set', and 'Snowball'. What are the differences between these t…
-
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p…
-
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 347 views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
line managers are unable to view any data from my team - team skills centerSummary: line managers are unable to view any data from my team - team skills center although one of his directs has skills data be he is even unable to view his directs…Nariman.Moussa-Oracle 11 views 0 comments 0 points Started by Nariman.Moussa-Oracle Reporting and Analytics for ERP
-
Is there a way to reset a PVO in a particular job from DB or any REST API or any other way in BICC ?We are looking to reset a PVO in a specific job by any other options like REST or other API or DB. We don't want to perform from the BICC page. If there are any inputs o…
-
Smartview:How to enforce data access control in Smartview based on rolesSummary: In Smartview, how do we restrict data access by Ledgers configured in Data Access set? Ex: If a user has access to only Ledger A controlled via Data Access Set,…Rakesh Viswambharan 1 view 2 comments 0 points Most recent by Rakesh Viswambharan General Ledger & Intercompany
-
Shipment Details To Costing JoinsHello Team, i need to join the wsh_delivery_details with cst_cogs_details table but could not find a
-
Is there any table which stores last email notification sent date for Requisition approvalwe need to display Last email notification date in our report so we wanted to check is there any workflow table which stores the details. we trayed to query this below t…Basavaraj Navalagi 41 views 3 comments 0 points Most recent by Basavaraj Navalagi Self Service Procurement -
Storing Oracle Fusion report outputs in document management systemSummary: We have a requirement for storing the output of various kinds of daily/weekly/monthly reports (BIP/OTBI/FRS) generated from Fusion ERP Cloud for audit purposes …
-
Mapping Tables Not giving us accurate dataSummary: Mapping Tables Not giving us accurate data Content (please ensure you mask any confidential information): We are replacing our old system of EBS with ADW. When …
-
is it possible to translate tags in OTBI in arabicSummary: I am developing a BI report in arabic, but the data I want to print through Tags (dynamically) in report such as Legal Entity Name, Legal Entity address, Bank n…
-
Default person name using SQL query for DFFHi Team, We have a requirement to default the person name on DFF filed using SQL query. By default the DFF value should be the person name who is logged in currently. We…Suresh Manchukonda 21 views 1 comment 0 points Most recent by Suresh Manchukonda Reporting and Analytics for ERP
-
HSBC Pain.001.001.03Summary: We are implementing payments in Fusion cloud with HSBC as our bank. Bank has specific requirement to have the oracle payment file in 'pain.001.001.02' or 'pain.…
-
bursting is not workingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
What are the Scheduled Process Tables that could connect to the business unitI'm trying to get the connection of the tables uses to store the scheduled process and join it to the table of business unitShe_1080 31 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Custom report Layout/Template not showing for a user for Accrual Reconciliation ReportSummary: Custom report Layout/Template not showing for a user for Accrual Reconciliation Report Content (please ensure you mask any confidential information): We previou…
-
Update information in Financial Reporting when new accounts are addedI would like to update information in Financial Reporting when new accounts are added: I have a report built in Financial Reporting, but the new account I added isn't ap…Jorge Luis Gomez 31 views 1 comment 8 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to use job schedule as a parameter in an SQL report?Summary: I need a method to get recurrence rules from a job to use it in an SQL report. So if I change the job, related SQL should have the same effect. Content (please …
-
Need to burst a book that will create one excel sheet with multiple tabsSummary: Need to burst a book that will create one excel sheet with multiple tabs, where each tab has the same report but is for a different cost center. Content (please… -
BICC PVO having attribute columns for PJC_EXP_ITEMS_ALLFrom the R113 PVO mapping document the BICC equivalent of PJC_EXP_ITEMS_ALL = FscmTopModelAM.PjcCapitalAM.ProjectAssetLineDetailPVO. Looking at the metadata and a sample…
-
OTBI project costing assets subject area filtering on in-service date results in no recordsI created an OTBI analysis using the project costing assets subject area. See fields in the screenshot below. The analysis returns correct results. However, when I filte…