Reports
Discussion List
-
I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any… -
TIMEZONE Display on the report field - UTC Timezone to EST TimezoneSummary TIMEZONE Display on the report field - UTC Timezone to EST TimezoneContent Hi Experts, I am using the OTBI Analysis (Payables Transactions Real Time) to create a… -
How to read a tab delimited data using querySummary: I have a text file which have data separated by tab. I need to split that into multiple columns. How i can write a query to achieve this. any idea please. Conte…
-
Sql query issueHi All, We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should sh…Dona Das-Oracle 21 views 3 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for ERP
-
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
How to create drill down charts in Oracle BI Publisher (BIP) Reports?Summary: How to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables? Content (please ensure …
-
How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…Kristelle 13 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How to write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report…Koteswararao Yenikepalli 96 views 3 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 128 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP
-
XLAFSNAPRPT job nameHi, I need to find the job name (ex: for XLAFSNAPRPT, job name is Create Accounting). Is there any table that store this information or it is only MetaData (xml) ? Thank…M. Tonghioiu 21 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Report on Income Tax, Social Security Tax etcHi we have a requirement to report on Income Tax, Social Security Tax, Statutory financial statements (Balance / Income / Cashflow), Statistical Report for LATAM countri…
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 154 views 8 comments 0 points Most recent by Satyam Roy Reporting and Analytics for ERP
-
Set BIP folder/report permissions by RoleSummary: I'm trying to set the permissions on a folder in Reports & Analytics based on Application Role. The specific role I want to use doesn't appear in the list of va…Lisa D 21 views 4 comments 0 points Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP
-
Lead times reportsSummary: The client is asking me for two reports, and I can't find anything standard. Could you confirm for me? The reports are: Standard report that evaluates the agree…Santiago Fazio 12 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 14 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Is there a definitive date that Financial Reporting Web Studio will be discontinued?We were informed that Financial Reporting Web Studio will be shutting down at some point in 2024. Is that accurate? Is there a date set for discontinuing FRS?Steven Woods 11 views 2 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
Help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.Summary: Greetings, i need some help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM. Content (please ensure you mask any confidential inform…
-
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br… -
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…Steph96 11 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…Jennie Wortman 198 views 3 comments 3 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
How to install oracle report builder to read legacy reportsHi All, we are in process of decommissioning r12 as we have moved into cloud. For reporting purpose we need some of the custom, standard rdf reports and their underlying…Kasthuri Haridass-Oracle 2 views 0 comments 0 points Started by Kasthuri Haridass-Oracle Reporting and Analytics for ERP
-
How to get size of file running in ESS jobSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…joelroshan92 2 views 2 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP
-
Unusual behavior of OTBI report -Not displaying 'invoice amount' and 'discountable amount'Hi Team, We have OTBI report which displays invoice discount information. After 24A we are observing it is not displaying 'invoice amount' and 'discountable amount' for …Kalpesh Salunke-Oracle 21 views 6 comments 0 points Most recent by Kalpesh Salunke-Oracle Reporting and Analytics for ERP
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide…Varun Dhondea 44 views 3 comments 0 points Most recent by Syed_Ibrahim Reporting and Analytics for ERP -
Regarding connectivity between BI Reports and OIC (PaaS)Hi team, Currently we are having few BI reports which call OIC services as data sources. All these connections are secured via basic auth. Since we are currently using O…
-
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 206 views 10 comments 0 points Most recent by Dilip.Murugan-Oracle Reporting and Analytics for ERP
-
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t…Abdur Rehman 21 views 2 comments 0 points Most recent by Abdur Rehman Reporting and Analytics for SCM
-
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 96 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for ERP -
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…Ankit_Bhadja 35 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP