BI Cloud Connector
Discussion List
-
Unable to find PVOs related to MSC(Planning Table)Summary: Hello, We need PVOs for following(Fusion) tables in BICC, as we couldn't find these in Data Lineage Sheet. If anyone has any idea on how to get those or any doc… -
How do you delete BICC UCM filesSummary: For data security, once the UCM files have been generated and the data has transferred to destination using BICC, how do we get the UCM content deleted. Content… -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Duplicate lines in PVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVOIn the Oracle Business Intelligence Cloud Connector (BICC) Console, the Support Incremental option is enabled under Manage Job for FscmTopModelAM.FinExtractAM.GlBiccExtr…Jaydeep_Chaudhari_1802 63 views 6 comments 0 points Most recent by Hbsampa General Ledger & Intercompany
-
BICC: GL journal approval workflow dataHello All, I didn't find any PVOs for GL journal approval workflow data…. I am aware of writing BIP report, but this option is very least preference. Wondering is there …
-
BICC: Last Extract Date for PVOs aren't set if Extract Schedule is failedI've JOB which contains 57 PVOs... Noticed the following behaviour when one of the PVOs is failed. The Last Extract Date for PVOs aren't set. It's set only if the Extrac…
-
BICC: Extract is failing with Error while fetching rows from serverWhen we run the following PVO in full extract it's failing due to huge data as row counts are 208,699,447. FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalD…
-
Is there a way to reset a PVO in a particular job from DB or any REST API or any other way in BICC ?We are looking to reset a PVO in a specific job by any other options like REST or other API or DB. We don't want to perform from the BICC page. If there are any inputs o…
-
BICC PVO having attribute columns for PJC_EXP_ITEMS_ALLFrom the R113 PVO mapping document the BICC equivalent of PJC_EXP_ITEMS_ALL = FscmTopModelAM.PjcCapitalAM.ProjectAssetLineDetailPVO. Looking at the metadata and a sample…
-
What are the standard Smart View reports available in Oracle ERP Cloud?Hi, What are the standard Smart View reports available in Oracle ERP Cloud? Such as for Cash Management we have the Cash Forecast and Cash Position Report which could be…Janitha Perera 27 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 13 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP
-
I'm new to BICC - any PVO advice?I hope this is the right community. I couldn't find one specific to BICC. My background is in integration platforms such as OIC and BizTalk, so working with the Fusion &…Todd Hensley 53 views 2 comments 0 points Most recent by Todd Hensley Reporting and Analytics for ERP -
PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blankSummary: PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blank files even after reseting to full extract Content (please en…
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 42 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
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 …
-
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 72 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… -
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
-
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 26 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 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
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 194 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 24 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 393 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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… -
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…