MSserver1 is in ADMIN after a restart
At the time of restart some times few Managed Servers will be in Admin State. At the time we have to check logs login to the particular server Go to…
Read MoreApache Redirection
We will get request from SEO for apache redirection redirect 301 url will provide by the SEO/dev team. Login to server sudo as root Go to /etc/httpd/conf take backup…
Read MoreHow to add Jar files to JDeveloper
In this post we are going to discuss how to add jar files to JDeveloper. First we need to download required jar file, after that you need to follow the…
Read MoreUnable to delete the BPA, which is in “Incomplete status”
Issue Description: Unable to delete the Blanket Purchase Agreement whose header details created. However, no line details are created. Error Message: This action is not allowed. Errors were encountered while…
Read MoreFixed Assets Invoice Cancel SQL script
Overview: This query is use to extract fixed assets invoices which is cancelled in Oracle Application R12. SELECT hou.name Org_Name, xep.name Entity, asp.segment1 Vendor_number, asp.vendor_name, assa.vendor_site_code, aia.doc_sequence_value voucher_number, aia.invoice_id Invoice_id,…
Read MoreScript To Cancel Or Delete Work Confirmation In Oracle Apps R12
Overview: This Datafix script is used to delete the work confirmation and the associated receipt data. In this script it will reduce the amount/quantity delivered for the work confirmation in po…
Read MoreAPI to Update Supplier Payment Terms
We will be discuss about the api to update vendor payment terms update in ap_suppliers. This is the standard API to update vendor details in ap_suppliers. ========================================================================== Step1:- Create the…
Read MoreSupplier Deactivate through API
This document explain how to deactivate supplier through API. SET serveroutput on; DECLARE p_api_version NUMBER; p_init_msg_list VARCHAR2(200); p_commit VARCHAR2(200); p_validation_level NUMBER; x_return_status VARCHAR2(200); x_msg_count NUMBER; x_msg_data VARCHAR2(200); lr_vendor_rec apps.ap_vendor_pub_pkg.r_vendor_rec_type; lr_existing_vendor_rec ap_suppliers%ROWTYPE; l_msg VARCHAR2(200); p_vendor_id NUMBER; BEGIN — Initialize apps session fnd_global.apps_initialize(1234, 50833, 200); mo_global.init(‘SQLAP’);…
Read MoreCHANGE ORDER MADE ON THE REQUISITION STUCK IN PENDING STATUS
Issue: Unable to raise a Change Request as the earlier change raised is not completed and stuck in “Pending” status Solution: Practical Guide To Troubleshoot Requisitions, PO’s or Releases Stuck…
Read MoreScript to update the recoverable Tax
Script to update the recoverable Tax Introduction: Script to update the recoverable Tax. Cause of the issue: In PO Migration from one unit to another unit, the data of Recoverable…
Read More