BI Cloud Connector
Discussion List
-
IssueSQL query to fetch rows from a BICC PVO created/updated after a certain dateWhat would be the syntax of an IssueSQL query to fetch data from a BICC PVO (eg. FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstPeriodicAvgCostsExtractPVO) with where c…Neha Aishwarya 85 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Need BICC PVO which lists Items details with Item ClassAre there any BICC PVOs that lists Item Class as part of Item details. We are able to get most of the Item data from "FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemEx…Suman D 406 views 1 comment 0 points Most recent by Hari Kurra-Oracle Reporting and Analytics for SCM
-
bicc povSummary: We are trying to extract data using BICC. We need to know whether : 1) BICC POV s can be joined together to get the desired data 2) We can create our own POVs W…DebjaniRoy 42 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
BICC Extract Schedules vs Job SchedulesSummary: Hi, I would like to create a pipe line between BICC and data warehouse to extract Financial Data I wonder what the difference and use case is for one or the oth…Daniel Sobotka 23 views 2 comments 0 points Most recent by Goutham PPM Reporting and Analytics for ERP
-
BICC VO for PAY_COSTS linking to XLA tableSummary: We are looking for a BICC VO that links the PAY_COSTS Table with XLA tables. This VO should bring in the segment details. Currently we are using PAY_XLA_COSTS_V…Conor Murnane 53 views 4 comments 0 points Most recent by Conor Murnane Reporting and Analytics for HCM
-
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
PVOs with one to one relationships to base tablesSummary: Hi, We are building a Lakehouse on databricks using PVOs as source. Since PVOs are a combination of base tables together it is some time harder to get the data …Rajat N 23 views 1 comment 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for SCM
-
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…Sushmitha G 281 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
Using BICC with UCM - Expected CostSummary: I am intending to use BICC (Business Intelligence Cloud Connector) in combination with UCM as an external Storage. What are the costs I can expect related to th…FusionAnalyst_95 156 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
lineage document for SCM AND PPMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…user4177158 5 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Rounding in RTF Template FormulaDear All, I am attempting to round the total of X/Y numbers in a sum, but it's not working using the RTF template. This is my formula: I need to round this equation (cu…George Mattar 133 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for ERP
-
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr…
-
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…Jahnavi-Oracle 24 views 2 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for SCM -
How to see the list of ESS Jobs scheduled using BICC and UCMSummary: How to see How to see the list of ESS Jobs scheduled using BICC and UCM and their start time Content (please ensure you mask any confidential information): Vers…joelroshan92 66 views 6 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…Maddipati Ajay Kumar 12 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 107 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
We couldn't find the PVO for the GL Account segment value attributes from PVOSummary: We couldn't find the PVO for the GL Account segment values attributes like Summary Flag. Account type from PVO. Please help us which PVO has those details. Cont…Siva Kumar Viswanadhuni 22 views 6 comments 0 points Most recent by Siva Kumar Viswanadhuni Reporting and Analytics for ERP
-
need to connect oracle data from php or via MS power bi to retrieve dataSummary: need to connect oracle data from php or via MS power bi to retrieve data Content (required): need to connect oracle data from php or via MS power bi to retrieve… -
How to get FND_FLEX_VALUES and FND_FLEX_VALUES_VL via BICCSummary: FND_FLEX_VALUES and FND_FLEX_VALUES_VL not available in BICC Content (please ensure you mask any confidential information): Hello…we are in BICC version Oracle …Jay Chandran 299 views 6 comments 0 points Most recent by Sreeram Tadepalli Reporting and Analytics for SCM
-
How to write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report…Koteswararao Yenikepalli 96 views 3 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find…
-
Which PVOs in the BICC console we need to pull to access the below tablesHi Team, Could you please help to provide, which PVOs in the BICC console we need to pull to access the below tables? HZ_ROLE_RESPONSIBILITY HR_OPERATING_UNITS FND_SETID…Shashi Kumar 44 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can I change the default attributes of a BICC extraxt file stored in UCM?Summary: I'm creating 2 extracts of BICC sourced from the same PVO for 2 different purposes, this is creating files with the same name. I need to download the files and …Octavio Aguirre 15 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Purpose of BICC Incremental Prune time in MinutesSummary Look for real world advice, or best practice use of setting BICC Prune timeContent Hi, We are just starting to use BICC to extract incremental data from Fusion F…User_NQABC 803 views 3 comments 1 point Most recent by Varun Jain-Oracle Reporting and Analytics for ERP
-
Need PVO for description column corresponding to avespdescid ID column - EFFBPricing__AttributesSummary: Need PVO details for description column corresponding to avespdescid ID column Content (please ensure you mask any confidential information): Hi Team, We need t…Jahnavi-Oracle 46 views 1 comment 0 points Most recent by Cornel Melinte-Support-Oracle Reporting and Analytics for SCM
-
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
BICC Mapping documentSummary: HI Team Please provide me the latest BICC View Object Mapping Sheet link Content (please ensure you mask any confidential information): Version (include the ver…SYARABOLU 33 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
movement request auto approval table in oracle fusionSummary: movement request auto approval table in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using,…KOTTHURI ASHOKBABU 26 views 2 comments 0 points Most recent by KrishnaV Reporting and Analytics for SCM
-
Regarding connectivity between BI Reports and OIC (PaaS)Hi team, Currently we are having few BI reports which call OIC services as data sources. All these connections are secured via basic auth. Since we are currently using O…