Category 129
Discussion List
-
How to join INV_TRANSFER_ORDER_HEADERS with GL_JE_LINES to get period name?Summary: I am using INV_TRANSFER_ORDER_HEADERS,INV_TRANSFER_ORDER_lines table in my report to get transfer data but i want to run this report for particular month and ad… -
Fixed Assets To and From Period range parameterSummary: I'm editing a DM for a fixed assets report. My task is to create a "To Period" and "From Period", the issue is in the SQL no matter how I've written it in to be…
-
Hide Catalog Menu from OTBI reportSummary: we open a report from application by the following URL: https://xxxxxxx.oraclecloud.com/xmlpserver/Custom/xxxxx/SCM/Procurement/Purchase disbursement report/PO_…
-
submit multiple HCM Extract from OICWhen I submit multiple HCM extracts from an OIC flow using a while loop for incrementing (1 corresponds to extract 1, 2 to Extract 2 and so on), sometimes I get a SOAP f… -
Can we customize 'Yearly Withholding Tax Report for Italy' report ?Summary: There are 2 requirements as below To add a period parameter 2. To add a new field on the report (The report uses a global temporary table, so how to know inform…Ankit Parikh 3 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Extra blank page in the output from BI Publisher RTF template due to using page break to get multiBI Publisher - RTF Template Report Output - Extra Blank Page is getting generated at the end of the Output.Srini_Venkat 304 views 1 comment 1 point Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
A report that will show the Fusion Role's last update dateGood afternoon. I wonder if there's a Fusion Report that will provide the date when the Fusion roles were last updated? Let's say a specific role was updated by Oracle d…
-
How to stop/disable email bursting from BIP reports after P2T refreshSummary: Hi All, We have multiple custom BIP reports with email-bursting queries. When the P2T happens, we want to disable the email bursting from the custom reports. Si…
-
ERP BI Publisher - HTTP Data SourceWe are planning to use an external API as a data source in BIP within Oracle ERP Cloud. Can anyone confirm if "HTTP" as a data source will be de-supported in a future re…Rohit Varma - Architect 21 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
What is Public View Objects (PVO) and where can we use it?Summary: What is Public View Objects (PVO) and where can we use it? Can it be used in Data model for BI Publisher report? Also, can we see the SQL or logic behind this P…Karun Jain-Oracle 5.1K views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to find out columns with empty value in Oracle fusion table through query ?Summary: Hello... I want to make a query to get all blank column names from a Oracle fusion table…Kindly help me in writing the query. Thanks. Content (please ensure you…I am a learner 25 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reportsHi Guys https://us.v-cdn.net/6034893/uploads/XBAKK1LFAVL0/wp-fusionbipaudit-5459609.pdf I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, …
-
Is it possible to pull the approvers for Job Requisition Approval?Summary: We are trying to create a BI report to know with whom the Job Requisition Approval is pending with. We have used the below query to pull the details but when th…Raje 22 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ERP FDI - Report to identify potential duplicate payments in APThe customer is currently using ERP FDI Live and wants to implement a report to identify potential duplicate payments in AP. They have already searched in the list of Pr…Mauro Roberto Rodrigues-Oracle 46 views 3 comments 0 points Most recent by Mauro Roberto Rodrigues-Oracle Payables, Payments & Cash Management -
How to group by formatted date column AnalysisSummary: Hi, we create analysis to count PO created yearly, so create Analysis include bill-to-location, creation date columns ,we want to group by bill-to-location, cre…
-
Include Dynamic dates in File Name for Scheduled Custom ReportSummary: We are scheduling a weekly custom report to run each Tues night for the previous weeks' data (ie. Jun-17 thru Jun-25) Is it possible to include the date paramet…
-
ESS Jobs DashboardSummary: ESS Jobs Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple ESS jobs. Is ther…Parag Hiremath 335 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 1.1K views 6 comments 0 points Most recent by Pooja_hb-Oracle Reporting and Analytics for ERP -
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 518 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP
-
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 42 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 13 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 153 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 208 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.3K views 7 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP