My Learning

Define audit group Security>Audittrail>Groups see documentation for more info Note: When you first create the audit group the group status will be 'Enable Requested'  this will automatically be changed to 'Enabled' once th e  AuditTrail Update Tables concurrent request is run Define columns to be audited Security > AuditTrail>Tables Enable auditing for schema owners Security > Audittrail>install Enable ‘AuditTrail Activate’ profile option Submit the AuditTrail Update Tables concurrent request If Request fails with   “Fatal error in fdasql, quitting Fatal error in fdacv, quitting Fatal error in fdaupc, quitting “ check this out  Fatal error in fdasql

Each time autoconfig is run it creates a folder under [inst_top]/admin/out/ . The name of folder is the the date and time of autoconfig run in the mmddhhmi format , This contains resote.sh script with many other files including  context_file. On running autoconfig it automatically creates a folder with different files for that autoconfig run. After autoconfig run If you find something wrong( like application is not accessible because of last modification) stop the application tier services and go to the relevant autoconfig folder and run restore.sh script to restore previous autoconfig configuration. The restore.sh will not actually restore the context_file but this will restore all the settings prior to this autoconfig run.(if you had a faulty configuration before, of course restore.sh will restore only those configurations) After restore.sh is run start up the services(don't run autoconfig), access the application, check the modifications and correct the modifications caus...

Void option on Payment actions screen is disabled while trying to void a payment. Oracle application R12(12.1.3) The payment is done for a prepayment and the prepayment is already applied to a standard invoice. Oracle actually restrict voiding a payment for a prepayment already   applied to an invoice To void the payment  Go to prepayment applications and unapply any invoices applied Query for the invoice to which you have applied the prepayment (now the invoice should have new distribution line and status must have changed to ‘Needs revalidation’) Validate the invoice and create accounting Go back to payment screen and query the payment you want to void Click the Actions Button Void check box should be enabled now

Accessing oracle application 11i 11.5.10.2 on IE8, works on both XP and windows 7 If you try to access oracle applications 11i 11.5.10.2 forms on IE8 it installs jinitiator but when the form link is clicked to open the form explorer just closes abruptly. oracle recommends upgrading to Sun JRE native plugin (Oracle JInitiator 1.3 for E-Business Suite 11i - Forms version 6.0.8.x [ID 552692.1]) The workaround to get it working on IE8 is this way go to Oracle Java Archive website and download Java SE Runtime Environment 6u13 (jre-6u13-windows-i586-p.exe) Install the JRE 6u13 (jre-6u13-windows-i586-p.exe) After installation has finished successfully copy the jvm.dll from java jre 6u13 installation directory (C:\Program Files (x86)\Java\jre6\bin\client) to the jinitiator direcotry (C:\Program Files (x86)\Oracle\JInitiator 1.3.1.21\bin\hotspot) Rename the the old jvm.dll file in the (C:\Program Files (x86)\Oracle\JInitiator 1.3.1.21\bin\hotspot) directory Now open exp...

OS: OEL 5.7 Application : R12.1.3 DB 11.2.0.3 adcfgclone on dbtier fails with RC-00110 - error displayed on terminal RC-50014: Fatal: Execution of AutoConfig was failed Raised by oracle.apps.ad.clone.ApplyDBTechStack - from ApplyDBTier_%.log file Post cloning process of dbtier with adcfgclone kept giving me this error RC-00110: Erro occurred while relinking of ApplyDBTechStack    The log files was showing the error : Autoconfig could not successfully instantiate the following files Adcrdb.sh INSTE8 RC-50014:   Checked the location shown in the log file and found the file was available   /u04/oracle/ERPCLONE/db/tech_st/11.2.0/appsutil/install/ERPCLONE_bkp Digging further showed me  that the script autoconfig complaining about  “adcrdb.sh”   is not available on the target system $db_home/ appsutil/template direcotry . I don’t know how it got missed from copying the source to target ! bash-3.2$ pwd /u04/oracl...

Retiring   asset showed this error “Set up the retirement convention for this retirement date” The prorate daily calendar was not entered for the current financial year, once we entered the program completed successfully