Creating a New GST Location and Supplier Site
md120__create-gst-location-and-supplier-site-for-odisha
Read MoreData Guard New Features in Oracle 18c and 19c
Data Guard New Features in Oracle 18c and 19c Data Guard Oracle Data Guard ensures high availability disaster recovery and data protection for enterprise data Data Guard maintains these standby…
Read MoreNew Features in Oracle Database 19c
General Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs New ALTER SYSTEM statement clause FLUSH PASSWORDFILE_METADATA_CACHE Clear flashback logs…
Read MoreActive Inventory Item Query
SELECT ( SELECT organization_name FROM org_organization_definitions WHERE organization_id = msi.organization_id ) org_name, msi.segment1 item_number, msi.description item_description, msi.primary_unit_of_measure, –msi.item_type, ( SELECT flv.meaning FROM apps.mtl_system_items_b msb, apps.fnd_lookup_values flv WHERE lookup_type = ‘ITEM_TYPE’…
Read MoreGL TO AR DRILL DOWN QUERY
SELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry For”, gjjlv.je_source “Source”, gjjlv.je_category “Category”, glcc.concatenated_segments “Accounts”, nvl(gjjlv.line_entered_dr,0) “Entered Debit”, nvl(gjjlv.line_entered_cr,0) “Entered Credit”, nvl(gjjlv.line_accounted_dr,0) “Accounted Debit”, nvl(gjjlv.line_accounted_cr,0) “Accounted Credit”, gjjlv.currency_code…
Read MoreIG column validation
1. Overview This document will be helpful to validate the Interactive Grid column values without editing the IG region. 2. Technologies and Tools Used The following technology has been used to…
Read MoreHow to handle divisor is equal to zero error
While execution the query with arithmetic calculation exception will throw divisor is equal to zero error.In this situation we can use below logic. CREATE OR REPLACE FUNCTION divisorzero (p_divited NUMBER,…
Read MoreConcurrent programs run count Weekly breakup query
Pass the from and to date parameter. select USER_CONCURRENT_PROGRAM_NAME,REQUEST_DATE,CNTPERDAY,week_no, case when week_no=1 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_1, case when week_no=2 then sum(CNTPERDAY) OVER (PARTITION BY…
Read More12.2 Rapid Install Fails On Installing Web Tier Utilities With Error “Fatal Error: TXK Install Service”
APPLIES TO: Oracle Applications DBA - Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2] SYMPTOMS: 12.2 Rapid-Install fails while Installing Web Tier Utilities with below error: ++++++++++++++++++++++++++++++++++++++ Installing Web Tier…
Read MoreERROR: URL Validation Failed. The Error Could Have Been Caused Through The Use Of The Browser’s Naviation
APPLIES TO: Oracle HRMS (US) - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2] SYMPTOMS: When trying to open either the 'Disclose Veteran Status' or the 'Disclose Disability Status'…
Read More