BI Publisher
Discussion List
-
Issue with a date column in customized Asset Register report in Oracle FusionHi, We customized the Fixed Assets "Asset Register" report. There's a date column whose logic is as below. (SELECTTO_DATE(TO_CHAR(fcp.end_date, 'MM-DD-YYYY'), 'MM-DD-YYY… -
Need sql query to join between subledger and fixed asset and asset invoicesSummary: We are pulling the general and sub-ledgers for fixed assets and asset invoices in order to create a custom BI report for fixed asset reconciliation. Since we ar…
-
What are the calculations or processes inside &L_DEPRN_SUMMARY of Asset Register Report?Hello, We are investigating an unexpected behavior which cause an issue and some discrepancies in our reporting. We need to know what is the content of the lexical, &L_D…
-
Is there a way to manage assets in multiple currencies?Summary: Is there a way to manage assets in multiple currencies? If the reporting currency is USD and the local currency is IDR, assets are registered in USD, but there …
-
Issues with customizing Journal Entry Reserve Ledger Report / ESS JobSummary: Issues with customizing Journal Entry Reserve Ledger Report / ESS Job Content (please ensure you mask any confidential information): We are encountering report …
-
PVO and Oracle Base Table for Fixed Assets approvalsWe have approval hierarchies enabled for Fixed Assets, for that to reflect in BI report we need related PVO & Base table which I am not able to find it anywhere. Please …
-
PVO and Oracle Base Table for Project approvalsSummary: We have approval hierarchies enabled for Projects Module, for that to reflect in BI report we need related PVO & Base table which I am not able to find it anywh…
-
Enquiry on usage of FA extract tables for developing BIP reportsWe have a requirement to develop BIP reports. We already have the FA extract process run post every period close. Wanted to check the feasibility of using FA extract tab…
-
How to link xla_distribution_links with fa tables to get the catchup depreciationSummary: How to link xla_distribution_links with fa tables (Depreciation, Transactions, Adjustments) to get the catchup depreciation (link other than event_id) to find d…
-
Referencing parent and parent of parent xml data for bip templateSummary: I want to call a parent two and three levels up from my main for-each statement. How do I achieve this? Content (required): This is my xml layout My code is bas…
-
How can we Restrict Users to Access data on OTBI/UI, particularly to those projects they assigned ?Summary: We have created a Custom Role to the Senior Projects Managers to view access on OTBI from """How Can Non Project Managers Access Review Project Performance Dash…
-
JournalEntryReserveLedgerSummary: I am trying to customize the report Journal Entry Reserve Ledger and when I am trying to save the data model (JournalEntryReserveLedgerDm), I am getting pop up …JATIN_SINGHAL-Oracle 11 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Need query to get asset details as mentioned in the summarySummary: Hi, There is an asset which is placed in service in Jan-24.Suppose there is an amount adjustment done in Aug-24 to the asset and in oct-24 life in months adjust…
-
Privilege or Duty role to run any Custom or seeded ESS JobSummary: Privilege or Duty role to run/submit any Custom or seeded ESS Job. I am aware it is present in Application Implementation Consultant Role. Content (please ensur…V P Aravind 162 views 2 comments 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
SQL Query for Fixed Asset YTD DepreciationSummary: Hello, We have a customized Oracle BI Publisher Report for Fixed Asset's YTD Depreciation. Our business requirement is that : When an asset is fully depreciated…
-
Hide Custom ESS Job Parameters LOV Seach FieldsHello, As the client requirement, we create a Custom ESS Job to run a BI Publisher Report. For this report, we need a few parameters, and for two of these parameters, ex…
-
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia…
-
Mass addition approval notification is not showing details of assets in the groupSummary: We are uploading multiple assets with ADFDi. When the approver is getting the approval notification part of mass approval, he is able to see only the total amou…
-
FA to GL Reconciliation Report at Asset Category (Capital Asset Rollforward Report)Hi Team We are building a custom report to reconcile FA cost and Accumulated depreciation balances between FA and GL, at the Asset Category level.. We are facing few cha… -
Display location segment Value description in FA OTBI ReportSummary: Hi, in the 3 subject areas related to FA, only we can see the location segment code. we have a requirement to display the code description as well. but I cannot…
-
Fixed Asset Clearing Account Reconciliation ReportSummary: Hi, The business users have a critical audit requirement to identify the reconciled and unreconciled balanced in their FA Clearing Accounts. Debit entries to th…
-
Do we have unplanned depreciation report in Fusion Fixed assets ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PL Karthick Ramanathan 11 views 3 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
How to place the extract of a job sets which is using a seeded report "Asset Cost Reserve Report".I have created a job sets which will be running in parallel using the same report, but with different parameters. The only delivery channels present are Fax, Printers, E…
-
Fixed asset Subledger report - providing the location information of an assetSummary: We are in a need of a Fixed asset Subledger report - providing the location information of an asset and tying to a general ledger for a given period - is there …Dhruvjoshi23 21 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
Printing Asset barcode on RFID label form Oracle Fusion by using Zebra RFID printerSummary: We got a requirement to print a barcode on RFID label using Zebra printer for new assets. Let us know whether this is achievable or not in oracle fusion.
-
Solution for Fixed Asset Rollforward (Asset and Tax Books)Summary: My Company has put a lot of effort and resources into developing a Fixed Asset rollforward in Oracle, which is a standard fixed assets report utilized across al…
-
"Asset Cost and Reserve Report" csv extract size limit exceedingHi Team, I had scheduled "Asset Cost and Reserve Report" once for a single country and for a single period. The delivery channel is email. I'm getting the below error: D…Prakhara 122 views 5 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Property Tax Report - Unable to modify Asset State ParameterSummary: Hi , PFB details - 1) We want to pass 'All' Values in Asset State Parameter of Property Tax Report. However, by default there is no option to select 'All values…
-
How to transfer the extract of a job set which is using a seeded report "Asset Cost Reserve Report".I have created a job set which will be running in parallel using the same report, but with different parameters. The only delivery channels present are Fax, Printers, Em…
-
Report to reflect latest asset locationSummary: Report pulling through a line per location, even if it was updated Content (please ensure you mask any confidential information): We currently have an OTBI repo…