BI Cloud Connector
Discussion List
-
Unable to find Job Requisition & Offer DFFs in PVOsSummary: We are looking for the PVO(s) that shows the Job Requisition and Job Offer DFFs (IRC_REQUISITIONS_DFF & IRC_OFFERS_DFF). We have been unsuccessful viewing this … -
About OTBI, BI and EXTRACTSummary: Use cases for OTBI, BI and EXTRACT. When we use Extract, when we use BI and when we use OTBI Content (please ensure you mask any confidential information): Hi T…
-
how to extract data from a PVO using BICCCI need to extract data from FscmTopModelAM.FinGlJrnlEntriesAM.JournalHeaderExtractPVO to a file or at least to query this table. ( I need to do a count over a column to …
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.3K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin…Valerio Curzi 25 views 7 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Employee Active Payroll balance reportSummary: Employee Active Payroll Balance Report Content: We have a requirement to include New Mexico Workers' Compensation for both Employee and Employer in the Employee…
-
issue query filter BICCSummary: We're trying to filter specifc data from VO at BICC , but log returns query error at where clause. Content (please ensure you mask any confidential information)…Hbsampa 88 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
How to disable logon using username and password in Oracle ERP, EPM and OCICan someone please provide the insights on the below query We need help to understand options around security, namely:- Can we disable the ability to log on using a user…Sheshan Ukkalkar 94 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP -
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…MDge 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to upload sftp private key in oracle b2b console, what we need give in the private key fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sindarapu 11 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
Experience with Fivetran BICC integration with Oracle Cloud HCMWe are looking for an integration tool to support us with the data ingestion from HCM to support our analytics team to extract and analyze HR data. I want to hear your f… -
How to call pages from different moduleSummary: Hi All, I am working on a Idea to call pages from different modules. Here is how it should work Navigation>Order Management>Manage fulfilment lines. On this pag…Manohar Cheelangi Swamy 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Extract DFF/EFF for Transfer Orders/Sales OrderSummary: Hi, We have a reqiurement to extract the DFF and EFF information for Transfer Orders and Sales order using BICC. We could able to find the below PVOs for extrac…Yash Jain 422 views 16 comments 0 points Most recent by Neha Aishwarya Reporting and Analytics for SCM
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 31 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Request for Information on Managing Budget Versions Approver details in fusion TablesSummary: I am currently working on a requirement to display the approver's name and the submitted person’s name for budget versions in our Grant Management system. Howev…Chetan Yeola 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Setup connection/API from Fusion reports to Azure data warehouseSummary: Hi Team, Any suggestions on sending the data from Fusion reports (OTBI/BIP) to our internal Azure data warehouse without using a flat file method of SFTP. Any o…
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 246 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
WorkRelationshipPVO missing DFFsSummary: WorkRelationshipPVO is missing DFF's such as PDS_INFORMATION% and PDS_INFORMATION_DATE% columns from PER_PERIODS_OF_SERVICE. We are using DFF's to populate cust…
-
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?Pedro Bacic 22 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Guidance for selecting PVOs for BICC extractSummary: We are using Oracle Business Intelligence Cloud Connector (BICC) to extract transactional data & load it into external tables using Informatica Cloud Services. …
-
BICC PVO missing information in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVOSummary: BICC PVO FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO doesn't have information related to IncomeTaxId even if in source table POZ_SUPPLIERS_P…
-
BICC 24 Version BICC Mapping DocumentSummary: Please share the Rel13_24.x_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx.zip Mapping Document Content (please ensure you mask any confidential information):…SYARABOLU 435 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…Sainatha B 21 views 1 comment 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Why do I get an SQL timeout limit error after 30 mins after 24D upgrade.Summary: Why do I get an SQL timeout limit error after 30 mins for one of the custom BIP report even though one of the other custom report with same properties and setti…
-
Inquiry: Attaching XSL-Based XML Output to PDF in Oracle Print Transaction ReportSummary: The Print Receivable Transaction seeded job is currently generating PDF output for customers. A new requirement has been raised to build an XSL-based XML output…