This Query is useful to fetch the vendor details that are having certificates for lower Tax Deduction rates or Exceptional Tax Deduction case vendors. Script: SELECT vendor_name, pan_no, org_tan_num,…
Read MoreThis applies to India localization. To Extract the GSTIN number and pan number attached to the vendors. Script: SELECT distinct jprl.registration_number jprl.secondary_registration_number sec_registration_number FROM jai_party_regs jpr, jai_party_reg_lines jprl ap_supplier_sites_all apsa…
Read MoreThis API is to update the supplier site level details. This would not applicable to ap_vendor_pub_pkg.update_vendor_site_public( p_api_version => 1, x_return_status => lc_return_status, …
Read MoreIf you want to make any parameter dependent on other parameter in oracle fusion BI reports then below is the sample sql example provided while creating LOV for the dependent…
Read MoreORA-20001: Statistics Advisor: Invalid task name for the current user During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA…
Read MoreORA-00054: resource busy and acquire with NOWAIT specified or timeout expired The error is raised when the following statement is executed against the Oracle Database. SQL> truncate table WRI$_OPTSTAT_HISTHEAD_HISTORY; truncate…
Read MoreORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – new_DG_CONFIG Protection Mode: MaxPerformance Databases: new – Primary database newia –…
Read MoreNavigate to System Administrator–> Security –> User –> Monitor Note the User Name and Oracle Process ID Now run this sql as &PID=Oracle Process ID &USER_NAME=User Name SELECT SUBSTR(d.user_name,1,30) “User…
Read MoreCurrent Setup : Apex Version : Oracle Apex 5.0 Webserver : ORDS Running on Apache Tomcat 9 DB Version : Oracle 12.2 • Step 1: Download Apex 18.1 from Oracle…
Read MoreWe were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…
Read More