BI Cloud Connector
Discussion List
-
Oracle ERP Cloud - Data Extraction via BICCHi - We are building a cloud data warehouse using data from Oracle SCM Fusion Cloud 22d using Oracle Business Intelligence Cloud Connector (BICC) for data extraction usi… -
Translation in PAY_MESSAGE_LINESTeam, We have a requirement to display the payroll error message name and message text. We are using PAY_MESSAGE_LINES to get the details. But this table has only Englis…
-
"HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" Does not give latest LE namesSummary: We are not able to get latest LE name from this "HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" , is there any Synch job that can be run to synch…Pooja Naganalli-Oracle 41 views 3 comments 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM -
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
PersonProfileItemPVO Issue post 23D, what's changed to impact this?Summary: We have a nightly extraction that retrieves delta data. Since 23D was applied the extraction is retrieving all data, causing timeouts due to the volume it is tr…Rebecca Hawker 12 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM -
Where to find historical data in BICC PVO'sSummary: Need to pull historical person info from PVO's in BICC Content (please ensure you mask any confidential information): Our business has set up an integration bet…SeanWesche 173 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Not able edit the OTBI reports for developed by others usersSummary: Not able edit the OTBI reports for developed by others users. Can you please suggest Content (please ensure you mask any confidential information): Throwing an …Linga Murthy 11 views 5 comments 0 points Most recent by Linga Murthy Reporting and Analytics for HCM
-
Someone Deleted the Custom folder from my Username. Is there any way to find the IP address or HOSTSummary: Someone used my credentials to login into UAT POD and Deleted the whole custom Folder. Is there any way to find the IP or Host of the user so that I can find wh…VarunMittal01 12 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to deliver BI Report output to share point locationSummary: Is it possible to create a share point connection in BI administration so that BI Report output can be delivered directly to share point location.
-
Replacement for FscmTopModelAM.ItemCostDailyAM.ItemCostDailyPVOSummary: With the loss of data availability for this PVO in 24A (see Document 2998181.1 (oracle.com)) our PECSV files are coming back with 0 rows, i.e. the table is no l… -
Custom Schedule Reports,BICC extract and Custom HCM Extension also impacted on emps to workers apiSummary: I have concerns regarding emps to workers api change, Below objects also impacted or not Custom scheduled reports? BICC extracts? Custom HCM Extensions? Content…mohityagyik 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
In Maternity Leave - Absence Type Balance is not Showing for the EmployeeSummary: Created a Maternity leave with Qualification Plan. But Absence Type Balance i am not able to see the number of balance days. -
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 554 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
Run Payroll Costing Report flow relation with Payroll Costing Report Extract?Hi All, I'm trying to understand if there is any relation between Run Payroll Costing Report flow and Payroll Costing Report Extract? My requirement is to modify Payroll…
-
What is the BICC PVO (View Object) to extract data for pay_bank_accounts?Summary: I would like to extract bank accounts number from personal payment method. Examples of PVO are HcmTopModelAnalyticsGlobalAM.CompensationAM.PreSalaryPVO, HcmTopM…Babatunde Ayodele 154 views 3 comments 0 points Most recent by Babatunde Ayodele Reporting and Analytics for HCM
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 185 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 292 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 316 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
unpaid reason lookupHi Experts - In Collections we have "Unpaid Reason" List . Can you please help me with the lookup so I can add more values? -
Person address data not displaying for user - BI reportSummary: I created one BI report and it has SSN and person details including address. When I ran the report, it shows all the details. When user ran it, the address fiel…Peoplesoft 32 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
-
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…User_2025-11-21-00-15-21-711 1 view 2 comments 0 points Most recent by User_2025-11-21-00-15-21-711 Reporting and Analytics for HCM
-
Do we have BICC PVOs for ERP’s Audit logs?The client has enabled Audit in the ERP Cloud as per regulatory requirement. I would like to understand if we got these audit logs in PVO's for BICC extraction. Can you …Keerthana Rajagopal-Oracle 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Is there a size limit to extract data from Fusion ERP?Summary: We will extract data out from Fusion ERP using BIP, BICC to Data warehouse. Is there a data limit? Will Oracle charge for outbound (egress) traffic? Content (pl…Jie Shen 182 views 3 comments 0 points Most recent by Madhavi.Godbole Reporting and Analytics for ERP
-
How to get row count from PVOs in BICC?Summary: We have been asked to verify that the # of rows we have pulled out of Oracle via BICC is correct. When we attempt to do a COUNT(*) against some PVOs, we are get… -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
How to get 'Email From Address' in query?Hi, Can someone help me to get the 'from email address' configured in BI server by sql? Regards, NivyaNivya Mathire 61 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM