Category 129
Discussion List
-
Track setup change report/analysis in OTBISummary: Track setup change report/analysis in OTBI Content (required): I'm looking for a report or to create an analysis in OTBI to track setup change. Who and When Sco… -
Select All columns from multiple tablesHi All, How to select all columns from multiple tables in the BI Data model. select a.*, b.* from table1 a,table2 b I cannot execute above sql statement when both the ta… -
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the …
-
RWS vs SmartviewSummary: Hi All, Can anyone provide insight on when should we use RWS and when to use Smartview. Dimensions are same in both methods. Please help me with pros and cons o…Richa Arora-Oracle 21 views 0 comments 1 point Started by Richa Arora-Oracle Reporting and Analytics for ERP
-
Invoice Line level Subject Area in FAW OACSummary: Hello, We need to create a Invoice line level report in FAW OAC, but do not find ant relevant Subject area in ERP Financials. Content (required): the Prebuilt A…Yogesh Dhanorkar-Oracle 52 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
What table(s) contain 'Invoice Method' and 'Revenue Method'?Hi, I'm trying to find what tables/views contain the following fields for: 'Invoice Method' - Cash basis, cost reimbursement, event-based, milestone, proportional perfor…
-
Ledger Currency are null on some payments in Analysis Payables Payments - Disbursement Real TimeSummary: Ledger Currency are null on some payments in Analysis report using the Payables Payments - Disbursement Real Time subject area. Content (required): Is there a w…
-
Parameters used to run the BIP report is not reflected in the HistorySummary: We have other reports where in the parameters are shown on the history. We don't know what's the difference with this specific report why it doesn't show the pa…
-
Where to find employee W2 Box 1 and Box 5 Data?Summary: I have a report request for employee's W2 box 1 and box 5 values. Content (required): W2 Data in Oracle Fusion HCM Version (include the version you are using, i…
-
Job Set ParameterSummary: I have seeded ESS Job and I want to make a ESS Job set that assign value to the seeded ESS Job. Is there a way I can achive that? Content (required): There is a…Naaman Yulianto 23 views 0 comments 0 points Started by Naaman Yulianto Reporting and Analytics for ERP
-
Assign custom role to OTBI reportHi, I have to assign custom role to custom OTBI report and I was trying to assign a role to OTBI report but custom roles are not showing in the LOV. Any suggestions?
-
How to change the "subject line" or "from address" details for Accounting Automation emailsSummary: Content (required): We have enabled GL accounting automation process in all our PODs. The issue we are facing is, all the emails from all the PODs are coming wi…
-
Need the know table and field name for enterprise contract page to prepare BI reportSummary: I need to prepare BI report on Enterprise Sell contract as per client requirement. Please let me know the how to identify the behind table name on Billing and F…Manivannan V-Oracle 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How the performance will be affected if multiple user run a BIP report at the same time?Summary: How the performance will be affected if multiple user run a BIP report at the same time? Content (required): If multiple users run the same BIP report at the sa…
-
Can we submit a BIP Report as Job from UI using a linkSummary Can we create a link or button in ERP which submit a BIP Report as Job uplon click/press ? Content (required): Version (include the version you are using, if app…Sandeep19rm 52 views 5 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Question on Approval Groups ReportSummary: - How is a delegation visible in the system – will it show on that approval group report? Will it be indicated whether a member of the group was delegated vs co…Abhilash K - Deloitte USI 41 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Is there an option or XDO function to print country name using Country code?Summary: Currently, Client is using a DFF to capture country code for Invoices when the payment is made for a foreign professional. These are of type Payment requests an…Abhilash K - Deloitte USI 22 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an…
-
Query to get salesrep assigned to the customer accountSummary: Hi, I am looking for the tables/query to get the salesrep number and name attached to the customer account in Oracle Fusion Cloud. Content (required): Version (…Ram Bala 001 578 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Unable to edit Data Model post Deployment using Oracle SOAP ServicesSummary: Unable to edit Data Model post Deployment using Oracle SOAP Services. Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dll?SoapImpl=…Ardhendu Santra 66 views 4 comments 0 points Most recent by Ardhendu Santra Reporting and Analytics for ERP
-
Limiting access to folders in custom folderSummary: We want to provide access to only expense folders to expense auditors/expense managers within Custom/Financials and to AP Managers to AP folder and so on. AP Ma…Dibyanshu_Shekhar 32 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
How to pass KPI value dynamically to Agent subjectSummary: How to pass Metric value to OACS agent body like 'Thresholds by Customer Level @CUSTOMER_THRESHOLD ' . Content (required): How to pass Metric value to OACS agen…Viswanath-Oracle 12 views 0 comments 0 points Started by Viswanath-Oracle Reporting and Analytics for ERP
-
What Table is the Role Code found in?Summary: Writing a query and Need to know what Table the Role Cod is found in? Content (required):
-
General Ledger Trial Balance Report column detailsSummary: We are looking to use the General Ledger Trial Balance Report but would like to understand each column definition of the balances. Can anyone help? Content (req…Anne Cilia 63 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Trying to create an OTBI Filter to convert string to DATE with current YEARSummary: Hi, I am trying to create an OTBI analyses that takes a DFF ATTRIBUTE5 in text format with the month and day, and then compares it to the date of the current ye… -
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…Mickel.Rmeily 52 views 4 comments 0 points Most recent by Mickel.Rmeily Reporting and Analytics for ERP -
Security Reporting: Who Logged in and When and did whatSummary: Content (required): We need to report on the following areas: Who logged in/out and When? What actions the user has done? Which Pages the user accessed? Which T…
-
Backend table for Payment process request statusSummary: Need to fetch payment process request status from backend Content (required): Hi There, we are building a report where in the customer needs the payment process…
-
What is the difference between Order Date and Creation Date?Summary: Content (required): What is the difference between Order Date (Time folder) and Creation Date in Procurement - Purchasing Real Time subject area? As per the ana…
-
AP Check print BIP report output to be printed from 2 different printers using PCL .Summary: Actually, we have a requirement on AP Check print report in which the page 1(contains the Cheque) which needs to be printed from printer 1 and other pages must …