People and Culture Blog

streamlabs chatbot gif video commands

Top Streamlabs Cloudbot Commands You can also use this feature to prevent external links from being posted. Timers are commands that are periodically set off without being activated. You can…

Read More

Oracle Fusion Middleware: Connecting Applications for Seamless Workflow

In the ever-evolving business technology landscape, seamless connectivity between applications has become a critical determinant of success. This is where Oracle Fusion Middleware steps in, as the crucial bridge that…

Read More

Send an email (with attachement) using Oracle PLSQL

Send an email (with attachement) using Oracle PL/SQL create or replace procedure SEND_EMAIL_WITH_TXT_ATTACH ( PVA_SENDER varchar2, PVA_RECEIVER varchar2, PVA_SUBJECT varchar2, PVA_MESSAGE varchar2, PVA_TEXT_FILE varchar2, PVA_DIRECTORY varchar2 /* Database Object */…

Read More

Checking The performance & Advantage of using BULK COLLECT

SET SERVEROUTPUT ON DECLARE TYPE t_bulk_collect_test_tab IS TABLE OF bulk_collect_test%ROWTYPE; l_tab t_bulk_collect_test_tab; CURSOR c_data IS SELECT * FROM bulk_collect_test; l_start NUMBER; BEGIN — Time a regular cursor for loop. l_start…

Read More

Service Contract line price Adjustment Issue while modified the prices user manually.

Use the okc_price_adjustment_pub.create_price_adjustment API with appropriate input values to effect the adjusted prices manually.

Read More

Service Contract Header amount total field is not affected while user manually update the price or quantity in line level.

Use the oks_auth_util_pvt.check_update_amounts API to refresh the header amount after the line level modifications.

Read More

Service Contract Interface – Billing schedule issue where the amount field was not showing at stream level.

Parameter p_billing_sch needs to be passed as E instead of T to the API Create_Bill_Schedule API.

Read More

PO Promise Date/Need By Date Automation Based on Date Entered

This Blog is used to automate PO Promise Date/Need By Date Based on Date Entered in PO Line level/Shipment level by using Form Personalization Please follow the steps as per…

Read More

Oracle EBS – Query to get MultiOrg Info

————————————————————————————– Oracle EBS – Query to get MultiOrg Info ————————————————————————————– ————– Execute the below query into EBS database.—————————————- SELECT mp.organization_code org_code, org.organization_id org_id, org.NAME org_name, hl.location_id, hl.location_code, hl.address_line_1, hl.address_line_2, hl.address_line_3,…

Read More

WEBADI for Asset upload in EBS

web-adi-fa-loading-process     This document will explain how user can upload fixed asset using web Adi process.  How to Effectively Upload Data To Oracle Applications With Web ADI 

Read More