BI Publisher
Discussion List
-
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 23 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 24 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 37 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 500 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 93 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 774 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 71 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 30 views 1 comment 1 point 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 48 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 51 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
-
How Can we import Gl Balances from legacy to Oracle Fusion?Summary How Can we import Gl Balances from legacy to Oracle Fusion?Content Hello All, Can you please let me know what are the ways to import GL account Opening Balances … -
Asset register report not updating the amounts modified in the applicationSummary Entered unplanned depreciation for some assets, posted and accounted those assets, however when extracting Asset Register or another BIP report the changes are n… -
Fixed Asset Summary ReportSummary FA Balance Summary Report for QTD and YTD by Asset CategoryContent Hello, We have a requirement of a Fixed Asset Summary report which shows the trial balances by… -
need query to get link between grants-->awards-->projects to gl_code_combination tableSummary need query to get link between grants-->awards-->projects -->project budgets-->working versions-->period accounts to gl_code_combination tableContent need query …User_2025-02-11-22-16-56-998 1.5K views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Is it possbile to extract the SQL's wirtten in BI Publisher?Summary Is it possbile to extract the SQL's wirtten in BI Publisher?Content We would like to know if there is any option to export all the custom sql's written in BIP. T…GTS Narayanen 44 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
SETSTAT is something that isn’t supported by AWS. How to solve?Summary Trying to deposit a file on a FTP but getting errorContent Hello, we need to deposit a file on an FTP of our partner. I'm using Oracle HCM BI. The configuration …Nicola Petri 26 views 1 comment 0 points Most recent by Hari Arumugam Reporting and Analytics for HCM