People and Culture Blog

Supplier 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 More

Script 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

Script to update the PO Attachment from Back End

Script to update the PO Attachment from Back End  Introduction: Script to update the Purchase Order Attachment from the back end. Cause of the issue: The Purchase Order Attachments are…

Read More

Submit PO Output for Communication Report from Back end

Submit PO Output for Communication from Back end Introduction: Script to Submit the PO Output for Communication Report from the back end. Cause of the issue: In PO data Migration…

Read More

Query to find the Onhand Qty Stock Details for Non-Serial Items

Script to Extract the Onhand Qty Details for Non-Serial Items  Introduction: Script to Extract the Onhand Qty Details for Non-Serial Items. Cause of the issue: In PO Migration from one…

Read More

API to Update the Terms and Condition in PO

API to update the terms and Condition details in PO from back end Introduction: API to update the terms and Condition details in PO from back end. Cause of the…

Read More

Credit check Functionality in EBS

credit-check-process credit-check-process

Read More

Analysis of Customer wise Items count of sales orders based on period

This query is to analyse the type of items that a customer is buying in specific period through out his orders. In the below example we have taken only the…

Read More

Using pivot option in sql and naming aliases

This is a simple SQL Query used to show how the pivot option is used. Here in this example the columns JAN, FEB and MAR would be having single quotes…

Read More

CONTEXT FILE PARAMETERS TO BE CHANGED FOR SSL(HTTPS) IN R12.2

Stop the application services. 2. Take backup of the context file 3. Run Autoconfig. 4. Start the Application services. 5. Evaluate the Instance is working as desired.   CHANGED PARAMETERS…

Read More