BI Publisher
Discussion List
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …SireeshaJaladi 357 views 9 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP -
Is there a delivered report on percentage of candidates that turn down offers for specific positionsSummary: Job offer rejection rate for fiscal year. Content (required): I have a report request for % of candidates that turn down job offers for specific positions. If a…
-
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…
-
AR Aging for PBCS IntegrationSummary: We need to integrate customer Aging data from Oracle fusion to Oracle PBCS . We have customer as a dimension in PBCS. When I tried to customize "Collections Agi…
-
What is MRC compliant in Fusion Reporting?Summary: How to check if the reports built is MRC compliant or not Content (required): Version (include the version you are using, if applicable): Code Snippet (add any …Priyanka_Ghosh 33 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Tool to extract query from CatalogSummary: Do we have any tool or any libraries which can be used to extract the Dataset (queries) from the DM catalog? or option to create DM programmatically based on th…sailesh_cloudare 32 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
How can I Archive multiple BI Publisher Data Models & Reports into one .xdo (catalog) file?Summary: How to archive multiple BIP reports in OTBI? Content (required): I believe it should be possible to archive multiple data models and reports into one .xdo file … -
Add Report to Manage Invoice Screen and have it be dynamicSummary: We are looking to add a report to the Manage Invoices screen and have the results of the report be specific to the invoice we are on. Content (required): We hav…Jennifer Tavino 89 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Dynamic page orientation change from portrait to landscape in a single RTF templateSummary: Dynamic page orientation change from portrait to landscape in a single RTF template Content (required): Requirement is to change the Page orientation conditiona…Lakshmi Bandlamudi 157 views 2 comments 0 points Most recent by Lakshmi Bandlamudi Reporting and Analytics for ERP
-
Report is taking 17 minutes for 1M record using burstingSummary: Report is taking 17 minutes for 1M record using bursting Content (required): Hi Expert, We have build a report to extract ledger balance and the report is havin…
-
Why are SOAP webservices reading sample data of a BI report with Excel layout?Summary: SOAP services - reading data from a BI report, with Excel data: date fields are taken from the sample data (report excel layout) and not from the report output … -
How to get the last instance of BIP report where delivery status = S & use it in FSCM Data sourceSummary: How to get the last instance of a BIP report where delivery status was successfull for a particular parameter and use that detail in Data Source Applicationdb_F…
-
Font mismatch between RTF template and PDF outputSummary: Font mismatch between RTF template and PDF output Content (required): Hi Experts, We developed a custom template for the PO PDF report. We found font mismatchin…Venkatesan 208 views 9 comments 0 points Most recent by Rajesh Singh Reporting and Analytics for ERP
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 331 views 0 comments 3 points Started by Bernadette Dorris Reporting and Analytics for ERP
-
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 …
-
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…
-
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 13 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 42 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 21 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 540 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 58 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 31 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
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 51 views 4 comments 0 points Most recent by Mickel.Rmeily Reporting and Analytics for ERP -
How can I edit parameter in standard ESS job?Summary: I want to edit (hide/remove/default to a specific value) the parameters of a standard ESS job. Please share steps to do it Content (required): Version (include …Priyal Pareek 587 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP