Showing posts with label
Script
.
Show all posts
Showing posts with label
Script
.
Show all posts
How to Upload Data into FND_LOOKUP_VALUES Using Oracle R12 API
›
SET SERVEROUTPUT ON SIZE 1000000 SET ECHO OFF SET VERIFY OFF SET DEFINE "~" SET ESCAPE ON DECLARE XROW ROWID; --You cant dire...
Oracle EBS R12: Insert Lookup Data into FND_LOOKUP_VALUES with API
›
SET SERVEROUTPUT ON SIZE 1000000 SET ECHO OFF SET VERIFY OFF SET DEFINE "~" SET ESCAPE ON DECLARE XROW ROWID; --You cant dire...
Oracle EBS Script for resetting password
›
-- oracle apps reset password from backend DECLARE p_change BOOLEAN; v_user VARCHAR2(400) := 'Support'; v...
Oracle EBS Active User and Person name list Query
›
SELECT fu.user_name, fu.user_id, fu.EMAIL_ADDRESS, (select hr.FULL_NAME from PER_PEOPLE_F hr where fu.employee...
Oracle EBS Audit Query
›
Query 1 – List of Oracle Forms Last Modified during the period under review SELECT a.form_name "Form Name", b.user_form_...
Parameter wise Concurrent Program Find
›
SELECT v.request_id, v.program, v.requestor, (Select FULL_NAME from per_all_people_f where EMPLOYEE_NUMBER = v.requestor) request...
Oracle R12 Form personalization List Script
›
-- Query to list form personalization in oracle apps SELECT DISTINCT ffc.sequence, ffc.form_name, ffc.function_name, ffc.de...
Oracle R12 AP Payment status Transmitte script
›
-- Find the payment_instruction_id form below script SELECT payment_instruction_id PaymentInstructionID, payment_instruction_status...
Oracle R12: AP: Expense Report Export Process or Rejects Query
›
--Expense Reports on Oracle iProcurement select * from ap_expense_report_lines_all where amount is null and report_header_id in ( select re...
Oracle R12 employee update script hr_assignment_api.update_emp_asg in HRMS
›
--Employee Expense Account update and Assignment CREATE TABLE xx_emp_code_comb_tbl ( emp_code VARCHAR2(30 BYTE), emp_full_name ...
API to create Code Combination and get CCID
›
----API To Create Bulk GL Code Combinations DECLARE l_ledger_name VARCHAR2(300)DEFAULT 'JGTECH_INDIA_PRIMARY_LEDGER'; l_st...
How to Get Application User Login Session Details
›
---Get Application User Login Session Details Oracle R12 SELECT SUBSTR( d . user_name , 1 , 50 ) User_Name , a. pid Process_ID ,...
How many concurrent program Running R12
›
Select fcr.request_id,fcp .* FROM apps.fnd_concurrent_requests fcr , apps.fnd_user fu , apps.fnd_concurrent_programs fcp , apps.fnd_co...
Oracle PL/SQL to XML Report Generate
›
---Package/Procedure to generate XML report CREATE OR REPLACE PACKAGE apps.XXJG_PRD_WISE_RPT_PKG AS -- +===================================...
›
Home
View web version