BI Publisher
Discussion List
-
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…User_KOLMZ 1.1K views 7 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
BIP Report Bursting for L1 and L2 ManagersSummary BIP Bursting Report for L1 and L2 ManagersContent Hi Team, I am using a single Data Model and 3 Templates(for 3 different Jobs ). I am using two columns to pull …Anjan Polimera 32 views 2 comments 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM -
Embed BI Publisher Report on Account PageSummary We need to embed a custom BIP Report on Account Page which gives info to users on unpaid customer invoices. I have created a report based on AccountID as paramet…Umang Gupta 32 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales
-
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece…Mike Burnett 49 views 10 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Combine Data tables in Data model as one similar to Union AllSummary Is there a way to combine tables in the Data Model which is similar to Union All? For example creating another table where they call all the table in the Data Mo…Mark kristan De los Reyes 36 views 4 comments 1 point Most recent by Denise Izzi Reporting and Analytics for HCM -
Passing a Dashboard Variable to all BI reports on dashboardSummary Passing a Dashboard Variable to all BI reports on dashboardContent Hi All, I am preparing a dashboard to show multiple charts / reports embedded. I would like to…
-
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi ExpertsSelect LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. B… -
How to delete an asset with Change in Cost Bonus rule tagged to the asset?Summary How to delete an asset with Change in Cost Bonus rule tagged to the asset?Content Hi Experts, Any suggestions on "How to delete an asset with Change in Cost Bonu…
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 25 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 26 views 0 comments 3 points Most recent by Pavel Buynitsky-Oracle Reporting & Analytics for Sales
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 42 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for HCM
-
Do we have any sql to identify the recruiting hirerarchy details?Summary Do we have any sql to identify the recruiting hirerarchy details?Content Would like to know if we have any sql for recruiting hierarchy details (like recruiting …
-
Fusion HCM BIP report completed with errorSummary Fusion HCM BIP report completed with errorContent Hi Everyone, When attempting to run a fusion hcm BIP report Online (not schedule) the following error occurs. E…Dhanuka Chamal 530 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Cloud Financials on Macbook / Mac OSSummary Is Oracle Cloud Financials supported on Macbooks/MacOS?Content Hi, I'm posting to find out what level of support is offered for Cloud Financials on Macbooks/MacO…Rehan Yusuf 91 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
SQL for sub-ledger to Cash Management TablesContent Hi, I am trying to develop a report that will give me detail from the cash management CE_ tables joined to the GL subledger tables ( xla_ae_lines, xla_ae_headers…User_2025-02-10-15-12-48-631 801 views 4 comments 1 point Most recent by User_2025-02-10-15-12-48-631 Payables, Payments & Cash Management -
Document Record notification customizationContent Hello, we would like to modify a note in the email notifications sent when a Document Record with attachments is assigned to a user. If a user creates a new docu…
-
In which tables can I find the budget balances?Content Hi, I need to know which tables Review Budgetary Control Balances uses, or in which tables I can find the following information: Tables I have already reviewed, …Edisson Gabriel López 73 views 2 comments 1 point Most recent by Edisson Gabriel López Budgetary Control
-
Adjustment Only Ledger vs. Balance LedgerContent Our company needs to create a new legal entity with Primary (GAAP) and Secondary (tax) ledgers. Our existing legal entity was set up using Data Conversion Level …User_2025-01-25-04-50-08-084 43 views 1 comment 2 points Most recent by Madhavj General Ledger & Intercompany
-
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a…
-
What-If analysis report calculating the new depreciation wrongly for NBV methodSummary What-If analysis report calculating the new depreciation wrongly for NBV methodContent Hi Experts, I ran the What-if analysis report for the given asset. Asset C…
-
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver…User_2025-02-11-08-39-07-186 56 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
BIP Report with stacked Bar chart not showing all dataContent Hello, We have created a BIP report with stacked bar chart. But it is not showing all data. I have attached screenshot document here. There is 1 filled requisiti…Ananya Sadhukhan 50 views 2 comments 0 points Most recent by Ananya Sadhukhan Reporting and Analytics for HCM
-
Oracle Procurement withholding tax problem - sqlSummary Oracle Procurement withholding tax problem - sql - see no tax code at line location, but populated norec / rec tax at distribution levelContent Hi, this is a sql…User_2025-02-10-15-12-48-631 15 views 0 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP