Category 385
Discussion List
-
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…Sridher 216 views 10 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for ERP -
FDI is not accessible for some users only in some locations due to sign-on policy accessSome users that were supposed to have access to FDI cannot access the tool any more ( only for some locations) they still access our HRIS using their addresses IP but no…Ayoub Afrass_1 11 views 3 comments 0 points Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration -
Roles/access required to fetch the deletion group datawe are using the below query to fetch the deletion group detailsSELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_codeFROM EGP_DELETE_GROUPS edg, EGP_DELET…
-
ValueSetValuesPVOThe PVO = FscmTopModelAM.AnalyticsServiceAM.ValueSetValuesPVO shows up in BICC but not in FDI. The only 3 offerings this particular PVO is in are Financial/Incentive Com…JDC 49 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
We have a requirement to fetch the Pending change order amount for a particular projectWe are fetching the change order amount from 'Procurement- Pending change Orders Real Time' subject area but we are not getting the exact amount changed column. Kindly l…User_XWNJM 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
ItemClassExtractPVOBICC shows the pvo with full name = FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemClassExtractPVO as available in SCM offering but this PVO does not show up in data a…JDC 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Dashboard Prompt Not Visible to Users with Custom RoleWe have a folder named PLM Reports located under Custom Folder, which has security enabled for two roles: Custom BI Administrator – Full Control Report Enquiry Role – Re…Karthik Chedella 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Cycle count adjustmentI have to make an cycle count history report BU wise – for this I am using INV_CYCLE_COUNT_ENTRIES table, in the frontend when i am checking the data for Transaction Typ…Rajendra.12 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang…Ramsha Zameer 13 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Unable to see secondary ledger in FRS list of valuesWe have secondary ledger for Germany and Luxembourg, but the same are not available while selecting ledgers in FRS report.Hemanth Buccapatnam Tirumala 21 views 4 comments 1 point Most recent by Diksha0912 Reporting & Analytics for Fusion Service
-
Support for bank's latest ciphers -newSummary: We received below notification from bank side for the security guidelines related to payment file transfer from Oracle fusion to bank (SFTP) We've detected that…
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…Mike Pee 11 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting and Analytics for ERP
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …venkat chaladi 31 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Currently if the orientation is changes to 90 degree, it shows like below:Shreya Agarwal-Oracle 11 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
Supplier Address –Phone/Email Audit Tables/History Data (Old Values) in Fusion stores in which tableHi Team, Could you please help me with the below? I am trying to identify which Oracle Fusion table stores the audit/history data (old values) for Supplier Phone, and Em…
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
How to extract more than 65000 records per excel sheet with BIP ReportSummary: Hi, Using Excel template, we can get output in XLS, XML and CSV formats. With XLS, if we have more that 65K records, it will create multiple sheets. With CSV, w…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…Himanshu_Kumar 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 104 views 6 comments 0 points Most recent by Suneha .-Oracle Reporting and Analytics for HCM -
How to set comma as decimal separator in RTF Template in BIP Reports ORacle FusionI have a requirement to show the EUR format amount i.e. €1.234,00 in output of RTF template other than setting it at User Preference. I have already tried the EUR format…
-
Receivables - Transaction Real Time to Receivables - Standard Receipts Application Details Real TimeHi. We are tying to get this subject are (Receivables - Transaction Real Time TO Receivables - Standard Receipts Application Details Real Time), however data is not show…Krishna Kishore 21 views 0 comments 0 points Started by Krishna Kishore Reporting and Analytics for ERP
-
In which Subject Area Can I get Fields related to "Event" ObjectI need to fetch data related to the "event" object in OTBI Reports. However, I’m not able to locate the fields in OTBI. Can someone guide me on which Subject Area contai…srikanth gollapally 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Oracle Fusion Cloud Database Schema Export for AI contextI am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can prov…Grant Abbondanza 41 views 4 comments 3 points Most recent by Grant Abbondanza BI Publisher Learning Center
-
COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_valuesHi Guys Does anyone please have a list of what each attribute is in the COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values? Data Source : ApplicationDB_FSCM E.G. C…
-
Error adding PVO to BICCHave SR open—no useful response yet so looking for other response. Error adding an existing PVO in BICC shows this error " [BIACM0185] Error saving data store due to [BI…JDC 31 views 3 comments 0 points Most recent by Mark Di Ponio Reporting & Analytics for Fusion Service
-
PO PDF templateWe have created a custom PO PDF template for the customer The user is able to download any PO PDF when the document amount < = 999 $/Rs/Euro(Any currency) But for amount…Kinjal Patel-Oracle 41 views 2 comments 2 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service
-
Unable to update headcount as 1 for few employees using HDLHi, We are using HDL for updating the headcount of 48K+ records and have successfully updated for most of them however for 5 records we are getting error as "More than 1…Kapil 31 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
Help Needed: REST API Endpoint for Retrieving OTBI Reports in Oracle Analytics Cloud CRM DemoI am working with an Oracle Analytics Cloud environment integrated with Oracle CRM SaaS (demo instance at fa-etaq-dev13-saasfademo1.ds-fa.oraclepdemos.com). I want to us…srikanth gollapally 31 views 0 comments 0 points Started by srikanth gollapally Reporting and Analytics for ERP
-
Can we club multiple elements into one single line so that the payslip generated is not very long?We have a requirement where in we want the multiple elements (elements and their retros) to get clubbed in one single line along with their contributions summed up too. …Kanak Maheshwari 21 views 4 comments 0 points Most recent by Selva.N Payroll and Global Payroll Interface (GPI)