Category 129
Discussion List
-
wrong postSummary:Version (include the version you are using, if applicable): 24D -
previous parameter coming in the View attribute column of the next parameterSummary: Previous parameter names come in the View attribute column of the next parameter , Attached screen shot shows the issue Content (pl https://us.v-cdn.net/6034893…Jude Franco 41 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 21 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Supplier data model missing a column in displaySummary: The tax ID column is missing in a custom data model for one user. Content (please ensure you mask any confidential information): I created a data model (SQL que… -
Accounting Period is coming null in General Journal ReportSummary: Accounting Period is coming null in General Journal Report Content (please ensure you mask any confidential information): No Version (include the version you ar…User_OFP2B 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to get deep link in Excel Template on a particular field in BI ReportWe are trying to get a deep link as a hyper link on a particular column in Excel Template in oracle fusionLakshmiVanarasi 172 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Missing time in JrnlHdrPostedDateTime column of FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVOWe use FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO to extract journal lines. The time part (hour, minute, and second) in both JrnlHdrPostedDate and JrnlHdrPostedDat…SHAHRAM SALAMI 31 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Error when generating report, unsupported output format XLSXWe've received an error on one of our reports. Error message is the following: "Output failed. [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=158261] oracle.xdo.servlet.data.D…Francisco Carrillo-Robles 211 views 3 comments 0 points Most recent by Ajay Sharma Reporting and Analytics for ERP
-
accounting asset inquirySummary: Hello everyone, I am making a report from which I need to obtain the following value from the box in red. I can't find the table in which I can locate those val… -
how to exclude our custom application data from being picked by Account Analysis Report?Summary: Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each …
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…hannah_barry 7.8K views 7 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Invoice Print Template Translation to Arabic Language converts Amount and Date also in ArabicSummary: Invoice Print Template Translation to Arabic Language converts Amount and Date also in Arabic Content (please ensure you mask any confidential information): We …
-
Is it possible to develop BI report to fetch data from VBCS pageSummary: Is it possible to develop BI report to fetch data from VBCS page Content (please ensure you mask any confidential information): Hi All, Is it possible to develo…
-
Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columnsSummary: Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address f…PSehgal2388 11 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Report to get employee's default expense accountSummary: Hi, Can you please suggest if OTBI report is possible to develop to get employee's default expense account? If Not can you please share any SQL query which can …Ninja 919 views 3 comments 0 points Most recent by Aravindkumar Shah Reporting and Analytics for ERP -
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 545 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 21 views 2 comments 0 points Most recent by Nathan CCC 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 5.2K 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 41 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 12 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 111 views 4 comments 0 points Most recent by Rajesh Kumar Gunda 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
-
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 51 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP