To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Backend tables or SQL query to know "Manage Enterprise Scheduler Job Definitions"Summary: Hi Team, We are unable to find the tables or SQL query to get the data under the task "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, S… -
Is it possible to store both US and Local Legal Entity Identifiers in Oracle?Summary: Our business team would like to know if it's possible to store multiple registration numbers for an Entity in Oracle. Content (please ensure you mask any confid… -
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 …
-
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…
-
Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…
-
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…
-
scheduled proccessess in Fusion: need to fetch data for 2023 yearSummary: I have a request to provide a list of all processes which were executed in the Fusion system in 2023y Cotent (please ensure you mask any confidential informatio… -
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
Error detail information in import journal execution reportSummary: In the process of creating a custom report for import journal execution report, we are unable to fetch the data for error status. We are able to fetch data for …
-
How to set parameter in BICC job payload from SOAP UI to set the extract date ?We are calling BICC job from OIC for a particular PVO ,it gives us incremental data every time. Is there a process to reset it to full extract in every run. -
Can I change the default attributes of a BICC extraxt file stored in UCM?Summary: I'm creating 2 extracts of BICC sourced from the same PVO for 2 different purposes, this is creating files with the same name. I need to download the files and …
-
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…
-
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?
-
ERP Secured ViewsSummary List of secured views to secure ERP data in BIP reportsContent Could you please let me know how can we secure data in datamodel for Financials data? We couldn't … -
Fin and SCM list views oracle BIPHI Team We need the Secure list views in Oracle ERP SCM and FIN modules as we need to use them in developing the custom BIP's. Regards Praveen
-
Role/Privelege for Explain Plan from SQL Query on data modelOne of our Reporting analyst user is getting an error that occurs when attempting to generate an Explain Plan from a SQL query on his reports. "Error Msg = ORA-01039: in…
-
Purpose of BICC Incremental Prune time in MinutesSummary Look for real world advice, or best practice use of setting BICC Prune timeContent Hi, We are just starting to use BICC to extract incremental data from Fusion F…
-
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… -
Calling Sub template -IssueSummary: calling Subtemplate from main template is working fine for one user and is giving error from another user. Content (required): We have created a custom job to r…
-
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…
-
how to link to tables AP_INVOICES_ALL and POZ_SUPPLIER_REGISTRATIONS ?????Summary: i try to create bi publisher report ( report aging supplier ) i want to select supplier name and supplier number how i can ? Content (please ensure you mask any…
-
How to Stop Duplication of Billed Amount in AnalysisSummary: I am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense repo… -
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 …
-
BICC Mapping documentSummary: HI Team Please provide me the latest BICC View Object Mapping Sheet link Content (please ensure you mask any confidential information): Version (include the ver…
-
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…
-
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu… -
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 …
-
What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table?Summary: What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table? What is the use of this table in FAW? Content (required): MAYO Clinic Version (includ… -
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…
-
Getting corrupt XLS output for more than 100KB output.Summary: Report Name : AR Debtor Aging Report - MIRA Real estate.xdo Report Path : /shared/Custom/Transactional Reporting/Receivables/BI Publisher/Debtor Aging Template …Soare Oldrich Alexandru-Oracle 11 views 0 comments 1 point Started by Soare Oldrich Alexandru-Oracle