Oracle EBS – PO Report with Bursting
Oracle EBS – PO Report with Bursting https://doyensys.com/wp-content/uploads/2024/01/oracle-ebs-po-report-with-bursting.doc
Read MoreQuery to get FA Mass Additions Details
SELECT DISTINCT fma.book_type_code, fma.posting_status, fma.description, fcb.segmnet1 major_category, fcb.segment2 minor_category, fma.fixed_assets_units, fma.fixed_assets_cost, (select segment3 from fa_locations where location_id=fma.location_id) location, fma.date_placed_in_service, fma.asset_number, fma.asset_key_segment1, fma.asset_key_segment2, invoice_number, po_number, vendor_number, queue_name, invoice_date, payables_cost, depreciate_flag,…
Read MoreQuery to get Asset Remaining Life
SELECT DISTINCT fb.asset_number, fab.book_type_code, (SELECT CASE WHEN decode(faab.conversion_date, NULL, faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.prorate_date)), faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.deprn_start_date)))<=0 then 0 ELSE decode(faab.conversion_date, NULL, faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.prorate_date)), faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.deprn_start_date))) END FROM apps.fa_books faab, apps.fa_deprn_periods fdpp, apps.fa_additions_bfbb WHERE faab.asset_id=fbb.asset_id AND…
Read MoreChanging Display Name in Oracle Apex Navigation Bar
Overview In Oracle APEX , the navigation bar is a component that allows users to navigate through different pages or components within an application. The navigation bar provides a user…
Read MoreRedirecting to a popup screen using JavaScript With Parameters
Oracle APEX (Application Express) empowers developers to build robust web applications with ease. JavaScript, being an integral part of modern web development, can be seamlessly integrated into Oracle APEX applications…
Read MoreHow to create dynamic quick picks for page items in Oracle APEX
1.Overview This document explains about how to create dynamic quick picks for page items in Oracle Apex. 2.Technologies and Tools Used The following technology has been used to dynamic quick…
Read MoreOracle APEX Application Availability Using PL/SQL
Overview : The objective is to enhance Oracle APEX Application Availability through the implementation of PL/SQL code, ensuring uninterrupted and reliable operation by monitoring, managing, and responding to potential factors…
Read MoreEmpowering APEX Applications: Exploring New Page Item QR Code Generator in Oracle Apex 23.2
Overview A new page item introduced in APEX 23.2 is the QR Code Generator. This brings QR code generation native to APEX, previously only possible using third-party libraries. The page…
Read MoreHow to Handle Client Secret Expiry in Azure Authentication for Oracle APEX
Overview : The primary objective of this content is to guide users on how to handle client secret expiry in Azure Authentication for Oracle APEX. Specifically, the content provides step-by-step…
Read MoreExploring the new Combo box item In APEX 23.2
Overview The new combo box in Oracle APEX 23.2 introduces exciting possibilities for building dynamic and user-friendly applications. They are akin to the classic select list and Popup LOV, but they…
Read More