How to Upgrade Tax Link 7 to 9 in Oracle E-Business Suite

How to Upgrade Tax Link 7 to 9 in Oracle E-Business Suite

 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