Category 129
Discussion List
-
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m…Alex Glose 12 views 4 comments 0 points Most recent by James McBride Reporting and Analytics for ERP -
Custom Role to Run FRS Reports in OTBIHello, Is there a custom ERP Self Service role that can be created to allow users to be able to view and run FRS reports in OTBI? Or does it have to be a full ERP licens…Erik Nicholson1234 14 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
How to concatenate elements with same name in etext templateSummary: How to concatenate elements with same name in etext template Content (please ensure you mask any confidential information): We are working in etext template for…Nidhi Chhajed 171 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
Does anyone know about what X-invoices format? or ZUGFeRD format? how we can adapt with RTF TemplateCurrently we are using RTF Format template for invoices, and we are sending Invoice details in PDF. But recently Germany business users asking the invoices details in ZU…Srikanth Doodapaka 42 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
Payables Trial Balance ReportSummary: I've set up a role so GL Users can run this report but when they do it errors with a permissions issue. Is it right only Payables Managers can run this report, …JohnG 27 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Employee Location not visible in custom report output for certain usersSummary: We have created a program that extracts all the posted journals for a set of accounts. In our implementation, Employees are stored as parties for making payment…Anand Balasubramanian 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…Shahid Qureshi 64 views 7 comments 0 points Most recent by James McBride Reporting and Analytics for ERP
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 2.7K views 11 comments 0 points Most recent by Harshitha S Motagi Reporting and Analytics for ERP
-
cashflow statement report querySummary: Hi All, Does any one have 'Cashflow Statement Report' query?? if you have could you please share. Thanks in Advance. Content (please ensure you mask any confide…Amarnath Podaralla 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
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 1 view 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 207 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 22 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 4.5K 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 21 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 I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, but would like to know if this is still relevant for the latest versions of Orac…
-
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 24 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 42 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 301 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 502 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 ease ensure you mask any con…Jude Franco 42 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management