My Oracle Support Banner

11i: AP: 'Financial Tax Register Process' Is Running Long For One Legal Entity (Doc ID 2793487.1)

Last updated on OCTOBER 07, 2021

Applies to:

Oracle Payables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

"Financial Tax Register Process" is running significantly longer.

The performance degradation is noted only when report is executed for one particular (legal)entity.

Trace files show the following outstanding SQLs

The "Financial Tax Register Process" key server-side API package body AP_TAX_POPULATE (Source file aptxpopb.pls) current version is 115.27 / 115.46


EXPECTED BEHAVIOR
-----------------------
'Financial Tax Register Process ' is running faster

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into Oracle Applications using Payables reponsibility
  2. Open the Standard Request Submission (SRS) screen
  3. Run "Financial Tax Register" concurrent, when prompted to enter the Parameters, enter:
    • Reporting Level = Legal Entity
    • Reporting Context = [Enter a particular Legal Entity]
  4. Notice it runs significantly longer when executed for that particular legal entity.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.