Category 129
Discussion List
-
Need help on getting correct YTD_DEPRN (YTD Depreciation) and DEPRN_RESERVE (Depreciation Reserve)Summary: Can someone pls provide inputs on where can we find correct base table and column for YTD Depreciation and Depreciation Reserve for a specific Asset and Book wi… -
permissions to access reports and analytics catalogSummary: Cloud ERP R13 Content (please ensure you mask any confidential information): I have a user with BI Administrator but when trying to access Tools > Reports and A…Service Desk Claremont 380 views 4 comments 0 points Most recent by Service Desk Claremont Reporting and Analytics for ERP
-
How to reorder columns in xpt templateSummary: How to reorder columns in xpt template Content (please ensure you mask any confidential information): Hi Team, We have created xpt template and we need to re-or…Nidhi Chhajed 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Auto Refresh a BIP ReportSummary: How to refresh a BIP report after a certain period of time? Content (please ensure you mask any confidential information): HI, We want to show a report on a Dis…Zahid Rahim 86 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Order Management Extension to copy Inventory Organization from Original Sales Order to RMASummary: Customer needs to copy warehouse information from the original sales order when creating a referenced RMA but we couldn't do it using pretransformation rules. I…
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 4.8K views 19 comments 0 points Most recent by Adi Salomons Oracle-Oracle Reporting and Analytics for ERP
-
ExternalReportWSSService runreport data is inconsistentSummary: When we call a HCM report which has employee info, the contact details info-the phone number value is coming inconsistently. Sometime it gives a empty/null valu…KarthikeyanPK 32 views 2 comments 1 point Most recent by KarthikeyanPK Reporting and Analytics for ERP
-
Shared SCM ReportsDoes anyone have a monthly total spend report that they might share? OTBI or SQL code? CoVicky P 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OACHi All, Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OAC. Thanks & Regards, Keerthana SekarKeerthana Sekar 81 views 8 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Fusion to SFTP - File got corruptedSummary: By bursting query we are transferring a fusion report to SOA SFTP. But in SOA SFTP the files seems to have missing lines. i.ie., Fusion report has 18k lines in … -
BLOB in sql query datamodel, how to display readable values?Summary: In BI in a datamodel, how to display in readable format a BLOB value? select adhocschedule from fusion.request_history This value only displays: ��¿¿ ¿dgodard22 101 views 4 comments 0 points Most recent by Rajesh Kumar Gunda Reporting and Analytics for ERP
-
Sql query to get PO Change Order line Details.Summary: Required sql query to get following PO Change Order line Details. Columns: Attribute Change From and Change To Content (please ensure you mask any confidential …Praneeth Nalluri 564 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Unresolved Account Permission getting added to BI catalogue in oracle ERP after deployment.Summary: we are migrating the BI Data model and Report along with folder structure to higher environment in ERP cloud, we are facing issue where an "unresolved account" …Praveen Kumar P 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…
-
Emailing an OTBI Analyses does not send data for prompt selectedSummary: OTBI Prompt data selected does not match data when emailed. Detailed overview: I have a prompt built into an Analyses report, that enables a manager to select t… -
can we do the page personalization on the invoice type lov in the create payment pageSummary: can we do the page personalization on the invoice type lov in the create payment page, in fact we want to remove two option from the default LOV that is Manual …Subrato Gupta-Oracle 11 views 2 comments 0 points Most recent by Subrato Gupta-Oracle Reporting and Analytics for ERP
-
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 43 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP
-
ExternalReportWSSService in SOAP UI does not give correct BIP Report responseHello All, I am facing issue in OIC New Hire Integration between Oracle HCM Cloud and Ceridian Dayforce. In OIC Service, SOAP API call(ExternalReportWSSService) to BIP R…Taruna Sharma 81 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
AP_HOLDS_ALL record deleted from the tableSummary: Hi All, we are trying to build a dashboard for AP invoices and related holds. During some tests, we notices that some record in the table ap_holds_all disappear…
-
Prompts not in reportSummary: When editing a migrated report I am unable to see the Prompt function for specific dimensions. Content (please ensure you mask any confidential information): Ve…Brooke Deacon 21 views 1 comment 0 points Most recent by Dave Roberts_-Oracle EPM Platform and Freeform
-
How to handle data access security in Custom BI ReportsSummary: We have the requirement to restrict data in custom BIP reports based on business unit access for the user in Fusion. For example, if report is built for 'XYZ' b…
-
When I prints checks in AP, the first page starts a little higher than remaining pagesSummary: We have to print AP checks to a check stub. So we prepared the rtf. But in the pdf version, the first page always starts a bit higher than remaining pages. All …Bindu Jayakumari 11 views 1 comment 1 point Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to change the output format of the JAVA type ESS Job from .csv to .xmlI have a ESS Job of JAVA Type in Oracle Fusion having output in .csv format, User want the .xml format anyone have any idea how could I change the format?Damoder Chitti 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is it possible to use multiple letters in the 'begins with' filterSummary: We have some OTBI reports that we use an agent to schedule and they have gone over 25k rows so now they are not including the full data set (currently 44k rows)…CarolineH 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI with Deep Link Sample Report for Purchase OrdersSummary: Hi, we have a requirement to enable drill feature on Purchase order number in the OTBI report. Clicking on PO number should enable to navigate to the Applicatio…
-
How to print previous period in smart view reportsHello All, I need to print the account value for current period and previous period. In FRS we have the relative period function that helps us print the pervious period.…ShitalRamteke 1 view 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Page is not available after Click Launch Financial Reporting Web StudioSummary: Page is not available after clicking Launch Financial Reporting Web Studio Content (required): I Went through the following path to do and adjustment in Grids a…Mohamed Ramees 21 views 5 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL.DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL. The DFF's are BI Enabled. But these DFFs do not appear in the BICC extract Data Store. Can you ple…
-
Is it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i…Luis Orihuela 11 views 3 comments 0 points Most recent by Luis Orihuela Reporting and Analytics for ERP