Abotts Partners with singapore based tech giant to help migrate their public sector customer from Sybase to SQL server.
Abotts partners with NYPL to integrate with their partner libraries.
Upworks Inc partners with ABOTTS to build their Oracle Cloud Infrastructure (OCI) and migrate their custom applications to OCI.
Abotts Inc Partners with Gnorth consulting to deploy exadata and ODA for a large public sector customer.
Tax Link 7 to 9 Upgrade
For Oracle E-Business Suite
Patch Execution Order
Follow this exact sequence:
- O2C Patch (Initial Release)
- O2C Patch (Latest Release)
- P2P Patch
- O2C Recon Patch
- P2P Recon Patch (if applicable)
- RTAID Patch
Pre-Requisites
- Ensure application services are running.
- Execute from the correct application tier.
- Use the appropriate patch file system (if online patching is enabled).
- Take a backup/snapshot before starting.
- Convert shell scripts to Unix format before execution.
- Grant execute permissions where required
O2C Patch Installation
Extract Patch
tar -xvf <patch_file>.tar
Prepare Files
chmod -R 755 db
find . -type f -name “*.sh” -exec dos2unix {} \;
Install Database Objects
cd db/install
sqlplus apps
@install_patch.sql
Review installation log files for errors.
Install Application Objects
cd apps/fndload
chmod -R 755 .
./fnd_upload_obj_tax_link.sh
Verify log files for successful upload.
P2P Patch Installation
Repeat the same process:
- Extract patch
- Set permissions
- Convert scripts
- Run database installation script
- Upload application objects
- Validate logs
If prompted for optional historical updates, proceed only if required.
O2C Recon Patch Installation
Extract & Prepare
tar -xvf <recon_patch>.tar
chmod -R 755 db
find . -type f -name “*.sh” -exec dos2unix {} \;
Install Database Components
cd db/install
sqlplus apps
@install_patch.sql
If prompted for configuration inputs, provide values according to your environment standards.
Upload Application Components
cd apps/fndload
chmod -R 755 .
./fnd_upload.sh
Validate log files.
P2P Recon Patch (If Applicable)
Follow the same pattern:
- Extract
- Prepare
- Install DB components
- Upload application objects
- Verify logs
Skip if not applicable in your environment.
RTAID Patch Installation
Extract & Prepare
tar -xvf <rtaid_patch>.tar
chmod -R 755 db
find . -type f -name “*.sh” -exec dos2unix {} \;
Install Database Components
cd db/install
sqlplus apps
@install_patch.sql
Review installation logs carefully.
Upload Application Objects
cd apps/fndload
chmod -R 755 .
./fnd_upload_trtaid.sh
Validate log output.
Post-Upgrade Validation
Run:
SELECT component, release
FROM tax_link_version_history
ORDER BY install_date DESC;
Ensure all components reflect upgraded versions.
Final Validation Checklist
- Confirm no errors in log files
- Restart services if required
- Test AR invoice processing
- Test AP invoice processing
- Validate O2C reconciliation
- Validate P2P reconciliation
- Confirm RTAID processing