ORA-20001: System Error: Procedure sort_segment_order at Step 40
ORA-20001: System Error: Procedure sort_segment_order at Step 40 DECLARE lc_employee_number per_all_people_f.employee_number%...Read More
Top Ten Unix Commad
Command Top Ten Unix Commad Description 1. ls ls ls -alF Lists files in current directory List in long format 2. cd...Read More
Enable close Button in Oracle forms R12
In Program units You will have APP_CUSTOM Package Change the code in procedure as required to close_window of APP_CUSTOM package to handle...Read More
How to Change SYS and SYSTEM Passwords
To change the SYS and SYSTEM passwords, perform the following steps: 1. Log into Oracle as internal or sysdba $ sqlplus / as sysdba 2. Type...Read More
CST: Accrual Load Data Purge
CST: Accrual Load Data Purge (Doc ID 1613969.1) SOLUTION Development has provided a concurrent request via Patch 17904883 :R12.BOM.C for th...Read More
Using adop hotpatch oracle 12.2.4
Example: unzip -q p20049475GENERIC.zip -d /fs_ne/EBSapps/patch adop phase=apply patches=20184781 hotpatch=yesRead More
API to create Bank information in Oracle R12
/* This is API to create Bank information in Oracle R12 */ DECLARE xx_output VARCHAR2 (1500); xx_msg_dummy VARCHAR2 ...Read More
Get Segment Description Oracle R12
SELECT SUBSTR(gl_flexfields_pkg.get_description_sql( :chart_of_account_id,:segment_number,:segment_value),1,500) segment_desc from dual /Read More
API to Create AP Supplier Site
API - pos_vendor_pub_pkg.create_vendor_site DECLARE l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type; lc_return_status ...Read More
Select Suppliers Details in R12
How to select Suppliers Details in R12: SELECT asp.vendor_id , asp.segment1 "Supplier Num" , asp.vendor_name "Supplier Name...Read More
Subscribe to:
Posts
(
Atom
)
![adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file.](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUxid_Sb9eyRWrrKKq6Yg7q6wZplrat_BiTw_ZH5keN-a-FH5yjkFKRmV8UQva_5I3Ui4FiK7Ty_CHoV7STcTw4BB6gSUyYfgm-utHaKJ3tGq3T2VPm6BWuGh1oBtutNA3iKG4h0w-xNm1/s72-c/oracle-dba.png)
