People and Culture Blog

10 лучших вариантов размещения в Осло, Норвегия

The landlord has been waiting for us in the house. When we arrived, she was very enthusiastic about introducing us to the interior of the house. The facilities https://rehabliving.net/ inside…

Read More

Query to find Third Party Registration

Query to find Third Party Registration SELECT DISTINCT TRIM (TO_CHAR (b.registration_number)) gst_num INTO lv_gst_num FROM jai_party_regs a, jai_party_reg_lines b WHERE 1 = 1 AND a.party_reg_id = b.party_reg_id AND a.party_type_code =…

Read More

APPLYING WELOGIC PACTH FOR R12.2 VIA COMMAND

                             ORACLE WEBLOGIC SERVER (WLS) 10.3.6.0.7 — 10.3.6.0.191015:                     …

Read More

Order Creation Using API

Script to OE_ORDER_PUB.PROCESS_ORDER ( Sample Script  Create Sales Order ) Script PROCEDURE xx_bdg_so_interface ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) IS v_api_version_number NUMBER := 1; v_return_status VARCHAR2…

Read More

Remove Options from the Interactive Grid Row Action menu

1. Overview This document talks about how to remove the options from the interactive grid action menus. 2. Technologies and Tools Used The following technologies have been used to achieve…

Read More

Auto New Line Generation in Interactive Grid

1.  Overview When using Interactive grid, sometimes user don’t want to go with add row button for a new row generation. On those cases, this document shows, how to generate…

Read More

ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, line 536 ORA-29283: invalid file operation

Description: The oracle OS user does not have the appropriate privileges on the OS directory, or if the path specified in the database does not match to an actual path,…

Read More

CREATING DATABASE SCHEDULER JOBS

Description: Scheduler jobs are the automated process handled by the database scheduler in oracle. It will run the scheduler jobs in a specific server time intervals like daily , weekly…

Read More

Responsive Report

1. Overview Responsive Reports can be created in Oracle Apex Classic Reports. Standard Oracle APEX which shows the tabular format of the dataset doesn’t support the responsiveness as the device…

Read More

How to check what current IDLE_TIME is set at in 11g ORACLE DATABASE

The Idle Time Resource Usage setting limits the maximum idle time allowed in a session. Idle time is a continuous inactive period during a session, expressed in minutes. Long-running queries…

Read More