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
-
PO PDF error printing attachments "Could not get data source connection for: FA_UCM_PROVISIONED"Summary: Getting error in PO PDF customization " "No such data source found in the data source config. Or you do not have access permission. Could not get data source co… -
Required Tables that stores min-max values for Replenishment planningSummary: As part of report development, we required min-max values for Replenishment planning. Please provide the details of tables that has to be used to derive the val… -
How to Insert/modify targets in main dashboard OTMSummary: Hi, I'm opening this ticket by suggestion from OTM CCC discussion: Is it possible to insert or update targets values in the main dashboard page? We have try to …
-
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …
-
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?
-
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Display modification in SmartView ad hoc analysisIn SmartView ad hoc analysis, I want to display hierarchies in a way where the parent value appears first, followed by the child value. How can I change this setting?
-
ScheduleSummary: 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 attach the report output into the notification of document of records approval.How to attach the report output into the notification of document of records approval.
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…
-
QUERY TO GET ESS JOB AND SCHEDULE JOB HISTORYSummary: 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 identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the… -
Can someone help on how to setup to print directly from Oracle to a network printer?Summary: We want to print some reports directly from Oracle. Is there a way to use a printer in the network to have the output of the report print to a printer? Content …
-
Keyboard Accessibility Tab Order in Oracle Analytics Cloud Fusion Data IntelligenceIs it possible to set a tab order for a Keyboard Accessibility requirement in Oracle Analytics Cloud part of Fusion Data Intelligence? It currently take 30 tabs to get t…
-
Table : ap_inv_aprvl_hist_all field "response" possible values meaning?Hi Guys I could not find anything on the web, I would be interested to know what some of the values in the "response" field in table ap_inv_aprvl_hist_all mean please an…
-
Time Lag when changes in Procurement appear in OTBIChanges made to PO's, Requisition do not appear immediately in OTBI but after a number of Hours? Is there a process that pushes through the Changes to OTBI?
-
Can someone please help me know the table names for the below PVO's?RSI GL Config Job TopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.FiscalPeriodExtractPVO FscmTopModelAM.Fin…
-
How to create a formatted CSV outputHi, The current CSV output format of any BIP Report Layout support only non-formatted CSV. Is there a possibility to get a formatted CSV as per the template designed, Pl…
-
How to keep search panel available when search result shows?Summary: How to keep search panel available when search result shows? Content (please ensure you mask any confidential information): Hi Experts, May I ask how to have th…
-
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…
-
How to export XML sample file from Purchase Order PDF data modelI am trying to export the XML from the standard Oracle Purchase Order PDF Data Model, so that I can import that XML Sample into the RTF Document (using the BI Publisher … -
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m… -
Is there a way to modify the configuration so that the link to its own cell is displayed?Summary: When downloading information from a report, clicking on the link of any of the cells always displays the link to the cell corresponding to the first row. Is the…
-
BICC and UCM Rest APIHi Team I wanted to extract the data from UCM using rest api and the data will be available over UCM by scheduling a job through BICC. I want to fetch the Id of the sche…
-
Configure Prompt acting like a nested query?Summary: How to configure Prompt acting like a nested query? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you to…
-
WSH_PICK_SLIP_RPT need information on this package which is used in Pick Slip ReportSummary: WSH_PICK_SLIP_RPT need information on this package which is used in Pick Slip Report. How to check columns and package information for this package Content (ple…
-
Currency field of a Requisition that is in "Procurement - Requisitions Real Time" subject area?Hi Experts, We are trying to come up with a report from the subject area of "Procurement - Requisitions Real Time", while I cannot find the correct currency code that is…
-
Empty fields are not displayed on the report output when exporting csvSummary: Empty fields are not displayed on the report output if it was Scheduled through Report and Analytics Content (please ensure you mask any confidential informatio…