Java applets taking too much time to load 11:30:00 AM Open Control Panel Open Java Goto Advance Settings Find "Perform certificate revocation checks on" Select "Do not che...Read More
API to assign External Bank Account to Supplier -Instrument- in Oracle Apps R12 7:43:00 PM 1: /* 2: API to assign External Bank Account to Supplier (Create Instrument) in Oracle Apps R12 - iby_disbursement_setup_pub 3: ...Read More
Check and validate GL Account 7:35:00 PM 1: declare 2: v_seg_array Fnd_Flex_Ext.SegmentArray; 3: v_num_of_segments NUMBER; 4: v_cci...Read More
Simplified and Touch-Friendly User Interface in Oracle E-Business Suite. 4:11:00 PM Simplified and Touch-Friendly User Interface in Oracle E-Business Suite. In Oracle 12.2.4 and above ...Read More
FNDLOAD Folders Script 1:39:00 AM To Download folders: FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct file_name.ldt FND_FOLDERS NAME="%You...Read More
XML Publisher issues : Error No: 53 2:12:00 AM XML Publisher issues Oracle BI Publisher > Preview > PDF/EXCEL Get Error: Error No: 53 Desc: File not found Please confirm ...Read More
Get unsuccessful users login Oracle EBS R12 11:51:00 AM SELECT * FROM fnd_unsuccessful_logins a where a.user_id =0 and trunc(a.attempt_time) = trunc(sysdate) ; Read More
Resetting Purchase Orders stuck in Pre-Approved status 1:31:00 PM Problem: Some purchase orders are stuck in the " Pre-Approved " status. How do I reset these purchase orders? How To Reset ...Read More
adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file. 2:03:00 PM$ <RUN> adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file. So...Read More
ADOP failes (Clean a previous Session) 11:00:00 PMCase: Checking for existing adop sessions. Session Id : 2 Prepare phase status : NOT APPLICABLE Apply phase s...Read More
How to recreate Oracle Inventory 10:19:00 PM$ export PATH=$PATH:$ORACLE_HOME/OPatch $ opatch lsinv Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corpora...Read More
R12.2 Adop Does Nothing, Online Patching 10:18:00 PM Oracle ADOP do nothing and Hangs. Case: adop do nothing when run. Solution: Login by root user and run below command: c Make sure that the ...Read More
Where do concurrent request log files and output files go, Oracle 12.1 12.2 12:15:00 PM SELECT LOGFILE_NAME, OUTFILE_NAME ,a.request_date ,a.lfile_size/1024/1024 lfile ,a.ofile_size/1024/1024 ofile ,b.user_concurrent_program...Read More
Get Oracle 12 payment XML output, Custom payment template 3:05:00 PMGet Oracle 12 payment XML output. Use the following query to get XML Output for payment to modify the payment template: Q1:- SELECT docume...Read More