Supplier Contact Import Using FBDI – Oracle Fusion
This blog describes the step by step process of Supplier Contacts migration in Fusion Application using File Based Data Import. Using this process we can create Contact of Suppliers and…
Read MoreScript to Find Lower Threshold Tax slab Vendors Registered Details
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 MoreQuery to Extract GSTIN Number
This 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 MoreSupplier Site Update
This 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 MoreSynchronization of AD tables FND_NODES, ADOP_VALID_NODES and FND_OAM_CONTEXT_FILES in 12.2 when adop fails
Issue : Autoconfig was failing in EBS R12.2 during cloning Error Faced : Directory: <EBS_BASE>/fs#/FMW_Home/webtier/perl/bin/perl -I <EBS_BASE>/fs#/FMW_Home/webtier/perl/lib/5.10.0 -I <EBS_BASE>/fs#/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I <EBS_BASE>/fs#/EBSapps/appl/au/12.0.0/perl -I <EBS_BASE>/fs#/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /<EBS_BASE>/fs#/inst/apps/<SID_hostname>/admin/install txkGenADOPWrapper.pl INSTE8_APPLY 1 SQL> SQL> Connected.…
Read MoreCreating Dependent Parameter in Fusion BI Report
If 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
ORA-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
ORA-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
ORA-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 MoreTo find the user process_id from EBS Front End R12
Navigate 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 More