Category 129
Discussion List
-
Find all emails sent by OracleSummary: Find all emails sent by Oracle Content (required): Hi, An email should've been sent to a user once he did the reception in Oracle but it seems he didn't receive…Antoine.Kaiber 310 views 1 comment 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Deeplink to GL Journals from OTBISummary: Hi All, Trying to implement the deeplink in OTBI to GL Journals. No Subject area in OTBI has jeBatchId column. Validate this in Fusion OTBI Data Lineage Mapping…ArunKumarDammalli 132 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
How t get login detail report in oracle fusionSummary: Content (required): Dear All How we can generate login report in oracle fusion for all the users , with Date , Time , user Name etc.. Version (include the versi…Shameer Muhammed P M 212 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
The BIP Excel layout returns no dataSummary: I downloaded a data sample from the data model, added the fields to Excel (creating a XDO_Metadata sheet). The template with the sample data looks fine: But whe…
-
Request for Oracle User Access ReportSummary: Hi all, Thank you in advance for your help and support. I have a question regarding Oracle user access. Is it possible for us to extract a report that provides …Paul Younes 32 views 2 comments 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How can a User view scheduled OTBI reports monthly?Summary: I removed the BI Author & BI Administrator role from a custom role for a user - leaving only the BI Consumer role within this custom role. User is not able to v…Akbar Ahmed 41 views 2 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Where can I find the list of native reports that exist in OTBI for purchase contracts?Hello colleagues, I need to know if there is a document that specifies those native or standard reports that Oracle offers, if you have a document with this information …Fernando Chavez 21 views 2 comments 0 points Most recent by Fernando Chavez Reporting and Analytics for ERP -
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…Abhilash K - Deloitte USI 57 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 318 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
Is the Oracle Analytics Cloud Professional Government is specific to the Government Cloud?Summary: Trying to determine its applicability to city government. Content (required): Is the Oracle Analytics Cloud Professional Government is specific to the Governmen…
-
How to pass 10K records in IN clauseHi, I would like to pull journal information for 10K batches. I have 10K journal batches in the csv file and need to pull journal information(creation date, category, et…
-
How long are the report jobs and outputs retained on the server?Summary: How long are the BIP Report Jobs and output files are retained on the server? Content (required): N/A Version (include the version you are using, if applicable)… -
Getting remittance message columns in OTBI before payment is madeWe want to create a report which we can use to check whether all payment details are filled correctly for large batches of payments before creating them, to prevent down… -
Table that holds ESS Job Display nameSummary: Hi We are trying to create a bip to fetch ESS job details. we looked into ess tables for display name but looks like they store only short name. fusion_ora_ess.…Susmitha R 2.1K views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to provide read only access on all fusion tables (not cloud app pages) for a user accountSummary: We have a requirement from external auditor to provide them with the access of read only , able to query and get exact counts ( just the counts and not the real…
-
Customizing Journal Workflow and Invoice Workflow Notification in ERP Fusion CloudSummary: We have a requirement to customize the notifications from Workflow from Journal approval/Invoice Approval. We wanted to add a table to show the list of approver…Abhilash K - Deloitte USI 23 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Project Detail not showing up in Subject Area: Financials - Asset Transactions in FAWSummary: In Fusion Analytics Warehouse: Subject area: Financials - Asset Transactions: when we are pulling Asset Detail: Asset ID, Asset Number and Asset Name with Proje…Nilanjan Biswas-Oracle 11 views 0 comments 0 points Started by Nilanjan Biswas-Oracle Reporting and Analytics for ERP -
How to map one parameter value to the multiple columnsHi, I have a table like as mentioned in the screenshot. I would like to pull the rows based on the parameter value. Data Model Query select * from supplier where usage1 …
-
Dynamic Legal Entity Name heading in FRS ReportSummary: Hi All, Can we have company or legal entity name derived dynamically in FRS reports based on selected legal entity at page level? Thanks, Content (required): Ve…
-
Customize 'Usage Metrics Drill-Through Report'Summary: Customize 'Usage Metrics Drill-Through Report' Content (required): We need to be informed if it's possible to customize the 'Usage Metrics Drill-Through Report.…Pablo AR 42 views 1 comment 0 points Most recent by Caio Zioli-Oracle Reporting and Analytics for ERP
-
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 397 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…
-
Issue SQL against PVOSummary: Is it possible to issue SQL against a data store extract PVO like "FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO" Content (required): Version …Rohith Thomas 75 views 2 comments 0 points Most recent by Rohith Thomas Reporting and Analytics for ERP -
Supporting Details Option Not Displaying On ReportsSummary: Upon setting the "Supporting Details Option" to display after the Parent member for my report, I am unable to see the supporting details when viewing my report …
-
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 31 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 33 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 93 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 166 views 2 comments 0 points Most recent by Lakshmi Bandlamudi Reporting and Analytics for ERP