BI Publisher
Discussion List
-
need a custom report query on AssetsSummary: i need a specific join between asset source lines to po lines and receipts and the link between fa_mass_Additions and rcv_shipment_headers Purchase Order → Rece… -
query to get asset number under transaction information at subledger levelThanks in Advance !
-
Unable to fetch asset financial detailsWe need to fetch Current Cost, Original Cost, Net Book Value, Depreciation Reserve, YTD Depreciation, In Service Date from Asset Inquiry > Details > Financial screen. Un… -
How to add dependent Parameter in Custom ESS job setSummary: Content (please ensure you mask any confidential information): Hi, We have created a custom ESS Job set which has three jobs in serial: FA Exception Report (Job…
-
Displaying PO Line and Receipt Number in Asset After PO Receipt Mass AdditionWe have a requirement to track purchase orders in detail, including the PO receipt, from the mass addition asset process. We executed the standard program "Transfer Rece…
-
Journals for mexico reportI am trying to run Journals for Mexico report . every time i run the report it is STATUS shows retrying. it is not producing any output. Can anyone tell me in the parame…
-
Unable to fetch accounting information from asset transactions screenHi, We have a requirement to fetch accounting information for an asset transaction for a particular class. We need to understand the links in between to create a BI repo…
-
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…
-
Beginning Balances for a few Entities (Segment1 from GL) is not there in FA_BALANCES_EXTRACT TableBeginning Balances for a few Entities (Segment1 from GL_CODE_COMBINATIONS) is not there in FA_BALANCES_EXTRACT Table when we filter on basis on those entities we aren't …
-
SQL Query to Link Maintenance Work Order Asset to Fixed AssetDear all, Could anyone please share the SQL query to link the maintenance work order asset to the fixed asset? Thanks and best regards, George Mattar
-
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…
-
Is there a way to filter the result of OTBI Report?Summary: I am creating Asset OTBI Report to capture the assets that registered with past dates since there is no standard report is available. I have created OTBI below …Karen Ito-Oracle 1 view 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Asset RegisterSummary: Looking for SQL query or OTBI report to get Project Segment (CoA) wise Asset Register Report. Balancing Segment, Cost Centre and Natural accounts are visible in…
-
How can we output the "Entered Period" for Expensed Asset in customized BIP?In the Document below, it shows that the Entered Priod in Fixed Assets can be output from XLA_AE_HEADERS.PERIOD_NAME or XLA_AE_HEADERS.EVENT_DATE. However, when it comes…Nao-Oracle 11 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
Last login of service accountSummary: I would like to find when a particular service account last logged in either through UI or through Webservice or both in Oracle ERP Fusion. Is there any SQL que…
-
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 471 views 3 comments 0 points Most recent by alexey.shtrakhov Fusion Applications Administration
-
Asset - manually enter invoice number not in table fa_asset_invoices.Summary: How to query asset that was entered manually. Invoice number,po number that was entered manually isn't populating in fa_asset_invoices so is there another way t…
-
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…
-
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 17 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…Madhan NM 161 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
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…