Category 129
Discussion List
-
Burst to multiple destinationsSummary: Burst to multiple destinations Content (please ensure you mask any confidential information): Hello - We use Fusion BIP application for ERP. I wanted to know if… -
Receivables Sales VAT Register for Italy ended in error without outputSummary: Dear All, I ran Receivables Sales VAT Register for Italy and Purchase VAT Register for Italy but they ended in error Content (please ensure you mask any confide… -
Budgetary Control Analysis ReportSummary: Control Budget parameter search does not return all project numbers in the Oracle seeded BI Publisher report Content (required): We have a user that runs the se… -
Custom report for Invoice approval workflow detailsSummary: Custom report for Invoice approval workflow details Content (required): Hi All, We got a requirement to develop BI report to show AP Invoice approval details li… -
OTBI how to assign roleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Somchat Wattanaponwadee-185289 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 71 views 3 comments 1 point Most recent by Renganathan V Reporting and Analytics for ERP -
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…Sesha Sailini 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Not able to execute report from "Financial Reporting Center"Hi, I have developed a custom report and able to generate the data without any issue if i run from "Report And Analytics" but report execution is failed from "Financial …Madhu A 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Trending FRS Report to exclude 13th Period?Summary: How to exclude 13th Period in Fusion FRS Report? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snip…Prakash.Malmarugan 111 views 6 comments 0 points Most recent by Kenney Reporting and Analytics for ERP -
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 61 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
OTBI Analysis Subject Area to Extract Employee Data for Customer CreationSummary: What subject area(s) can be used to extract a list of Employees created in HCM who have not yet been setup as Customers in Receivables? Content (please ensure y…Francine Gemora 21 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
OTBI GL Subject Area: 'General Ledger - Journals Real Time' unable to find the 'Approval Date'Summary: Hi All, While developing OTBI report for General Ledgers, We are unable to see the 'Approval Date' for the journal in 'General Ledger - Journals Real Time'. Kin…Venkat_P-Oracle 101 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Sample query for Project BudgetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
I couldn't find the user entities that included the work structure dataSummary: I used HCM extract to extract person assignment and work structure data, but I couldn't find the user entities that included the work structure data (position,l…Salma Mohamed Salem 41 views 1 comment 0 points Most recent by Simona Chircu - Support Oracle-Oracle Reporting and Analytics for ERP -
OTBI Remove All Rows SummarySummary: Content (please ensure you mask any confidential information): When exporting an OTBI analysis in the format of xlsx, the last row is a merged and centered tota… -
How to add Hyperlink in Footer of RTFSummary: Hi team, We have defined a lookup where we are storing links, from the data model we are fetching xml tags and using it in rtf to dynamically change link. when … -
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha…
-
-
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ?Sandeep Nihalani 117 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…Oracletechnofunctional 191 views 4 comments 0 points Most recent by Adarsh.Kumar Reporting and Analytics for ERP -
Custom FolderSummary: We have created a folder named "Reports " - it is not in the custom folder - will this folder be preserved when doing an upgrade or do we need to put all custom…Vinayak Walse-Oracle 61 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
HFRS - How to generate Date Format for a report Dimension - Accounting Period on report HeaderSummary: We have a requirement where the HFRS Report header needs date format of the Accounting Period. Content: Our Accounting Period Format is MMM-YY and this is a Dim…Shefali Lakhani 131 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
General journals - transaction IDSummary: Hi all - within OTBI is anyone able to let me know where I can find a transaction ID or a global GL transaction number or similar? I'm trying to add it into an …Christopher McDermott 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use…VivekKandasamy-Oracle 54 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Oracle Analytics Cloud (OACS) Training for a BeginnerSummary: Oracle Analytics Cloud Training for a Beginner Content (please ensure you mask any confidential information): Hello, Can anyone recommend training or resources …Lola Kassim 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I … -
Image in BI Publisher template spills into attachment when sent to e-mail outputSummary: Image in BI Publisher template spills into attachment when sent to e-mail output Content (please ensure you mask any confidential information): In BI Publisher …Robert of STAU 41 views 7 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Need to convert string into hash valueHi, I need to convert 'AKEBSTEST-700(2.1)' string into hash value i.e '561956564' using sql or Plsql. Is any function we can use to convert this value.vikram khengare 32 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Transactions coming from external systemsHi We are defining lets say a tax rate 20% and not mentioning whether its inclusive or exclusive at the setup level. If transactions are coming from interfaces, is their…