BI Cloud Connector
Discussion List
-
Need to fetch the grade, grade step and grade rate at the employment level using BI reportSummary: Hi all I need to fetch the grade, grade step, and grade rate whichever assign to the person, but in my query, I am getting multiple grade steps assigned to the …Deepak Bhatt 2.9K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po… -
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…Antony P Patrick -Oracle 113 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to pull data in Power BI from Oracle Fusion/ATP TablesSummary: How to pull data in Power BI from Oracle Fusion Content (please ensure you mask any confidential information): We are looking to pull data in Power BI from Orac…Abhishek Sinha 111 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Matrix Manager Missing in BICC ExtractWe are using BIACM Extract (PVOs) to expose HCM data to PowerBI. Based on the document Rel13_21.x_BICC_HCM_Database_Mapping_with_ViewObjects, we understand that the PVO …Sahil Kathuria 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
What are the options to have read only capabilities to BICC (BI Cloud Connector) in OracleWhat are the options to have read only capabilities to BICC (BI Cloud Connector) in OracleVarun R 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 71 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Extracts General Ledger Cube Balances - Error out as QUERYRESULTLIMITHi, From EPM application, ESS job "Extracts General Ledger Cube Balances" is called, which error out as below. Kindly let me know how to fix this issue. Error: Execution…Bharath Kumar Madupuru 526 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
BICC DFF extract sales order header and linesNeed to extract Sales order header and line data from tables DOO_HEADERS_ALL and DOO_Lines_ALL. I am able to get this using BICC extract into UCM server. But DFF columns…Alok K Gupta 231 views 10 comments 0 points Most recent by Aniket Jadhav Reporting and Analytics for SCM
-
abcdabcdShyam Rajbhar 11 views 2 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Getting the error 'ORA-31011: XML parsing failed' when calling the SAAS report through webserviceSummary: I am getting the below error when calling the SAAS report through webservice call from my pl/sql procedure. 400 Bad Request 400 Bad…
-
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…Srilatha Boddu 31 views 6 comments 0 points Most recent by Srilatha Boddu Reporting and Analytics for ERP
-
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 21 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Missing time in JrnlHdrPostedDateTime column of FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVOWe use FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO to extract journal lines. The time part (hour, minute, and second) in both JrnlHdrPostedDate and JrnlHdrPostedDat…SHAHRAM SALAMI 31 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 5.3K views 19 comments 0 points Most recent by Adi Salomons Oracle-Oracle Reporting and Analytics for ERP
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 52 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP
-
DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL.DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL. The DFF's are BI Enabled. But these DFFs do not appear in the BICC extract Data Store. Can you ple…
-
Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extractSummary: Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extract. Lot of BI enabled DFFs are not available in Doc ID 2463485.1. For ex…MohanPothuri 55 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
can not find new option under file menu in FRS to create a batch in BI cataloguecan not find new option under file menu in FRS to create a batch in BI catalogueSaikat1 13 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Oracle BICC Frequency options checkSummary: Hi , Oracle BICC has feature to schedule the data extract job with recurrence frequency of Hourly, Immediate, Daily, Weekly and Montly. However our client needs…
-
Handling Double Quotes in BICC Data ExportsSummary: Handling Double Quotes in BICC Data Exports Content (please ensure you mask any confidential information): I am encountering an issue with my BICC export proces…
-
Is Oracle able to send HL7 "messages" or just HL7 format " ?Summary: Is Oracle able to send HL7 "messages" or just HL7 format " ? Content (please ensure you mask any confidential information): Version (include the version you are…
-
scheduled report not getting data in output filewe have scheduled a report on daily basis to the SFTP folder using the destination while scheduling reports. Reports are scheduling but not showing data in the output ge…Dara Nagasai 104 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
CUPS Server Printer Setup in ERP BIPSummary: Hi Team, we have below requirement and need to understand. Can some one please help on this. The print server has been installed in Azure with the CUPS service …PrasadN 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Date and Timestamp Datatypes from metadata for PVOSummary: We are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata). However, some columns are labeled a…Alex25 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Why is the content server not opening correct document for maintenance work definition attachment?Summary: In the Manage Maintenance Work Definitions screen, each maintenance work definition code has an operation with an attachment. This is the .txt file that contain…
-
How can I replicate data from a pivot table in an RTF report (BI Publisher)?I have a report for transaction build using BI publisher what is giving is the customer X is shown just once with multiple transaction what i want is to have the custome…Omran Zeaiter 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
What subject areas and query should I use to get AR Aging report based on BICC Extractts?Summary: I know the AR Aging report is complex with joins to XLA tables, hz tables, ar_payment_schedules, and other ra/ar tables. We are trying to generate the AR Aging …
-
BI Cloud Connector (BICC) - Not all columns selected by default in PVOSummary: By default, not all columns are enabled in PVOs (This can be noticed when we enable a PVO in a BICC job). - Is there any logic used to choose the default column…