Problem: Traditional batch processing setups often face resource inefficiencies, as they are provisioned statically, leading to underutilization during low-demand periods and potential bottlenecks during peak times. Manually adjusting resources is…
Read MoreProblem: In a rapidly evolving and dynamic IT environment, managing complex infrastructure configurations across various projects and environments can be daunting. A monolithic approach to Terraform scripts may lead to…
Read More Execute the below query into EBS database. SELECT line, empty, pricing, item, from_date, TO_DATE, total, uom, attirubute, org FROM (SELECT ‘NL’ line, ” empty, ‘INTERCOMPANY PRICING’ pricing, item.segment1 item,…
Read MoreOracle EBS – PO Report with Bursting http://staging.doyensys.com/wp-content/uploads/2024/01/oracle-ebs-po-report-with-bursting.doc
Read MoreSELECT 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 MoreSELECT 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 MoreOverview 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 MoreOracle 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 More1.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 MoreOverview : 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 More