Unable to access Diagnostics through Oracle forms

Unable to access Diagnostics through Oracle forms

Reference of action: open form choose help>diagnostics>forms personalization and receive "Your responsibility does not have permissions. Contact System Administrator".

Changed: 'FND: Diagnostics' and 'Utilities:Diagnostics' to Yes on site level.

Found that above profiles were disabled on responsibility level "US Quality Super User".  Which has Issue
For now "Help > Diagnostics > Examine" should be accessible for any user.
We can setup this access for any specific user also 

Purpose and usage of Tax Rate Variance Account

Purpose and usage of Tax Rate Variance Account.

Tax Rate Variance reflects the tax variance between the invoice and the PO distributions due to difference in tax applicability.

Tax Rate Variance is normally computed for the Non recoverable portion of the Tax. It is computed in two cases:

a) When there is a difference in the Tax amount of the PO and Invoice.

For Example: PO# 122046

Lines Amount: 14.49

Tax Amount: 1.16

Total Amount: 15.65

-----------------------------------

AP invoice# 135324

Item Amount: 14.49

Freight Amount: 14.62

Tax Amount: 0

Total Amount: 29.11

Tax Rate Variance: 1.16

In this case, Tax is calculated on PO# 122046 which is 1.16. But, on invoice there is no tax calculated. Hence, the Tax Rate Variance account recorded the difference in tax amount 1.16.

b) When there is a difference in the Taxes computed (for instance an extra tax calculated on Invoice and the same did not exist in PO).

For Example: On PO# 121985

Lines Amount: 57.62

Tax Amount: 4.60 (State Level Tax: 2.30 + County level Tax: 2.30)

Total amount: 62.22

----------------------------------------

On AP Invoice# FJ17597

Item Amount: 57.62

Freight Amount: 13.71

Tax Amount: 5.70 (State Level Tax: 2.85 + County Level Tax: 2.85)

Total Amount: 77.03

Here the applicable tax rate is 4 and State Level and County level tax is calculated in following way.

Tax for Items+Freight (57.62+13.71) = 71.33 * 0.04 = 2.85

If tax is calculated only for Freight: 13.71 * 0.04 = 0.54

Difference of Total tax and Freight Tax (2.85 - 0.54) = 2.31 which has 0.01 difference from the tax on PO.

Hence, Tax Rate Variance account has recorded the tax variance amount on Invoice Distributions as 0.01.

@Article Submitted  by Amrutha

WORKLIST PROXY - PURCHASE REQUISITION APPROVAL

WORKLIST  PROXY -  PURCHASE  REQUISITION  APPROVAL

Worklist Access is used to grant another user proxy access to approve requisitions on behalf of an Approver.  Access can be granted for a specific period or indefinitely.  The proxy user will only be able to view and take action on notifications for purchase requisition approvals.  Requisitions can be rejected, approved, or reassigned to a different user to take action.  A proxy user will be restricted from approving or re-assigning a requisition they submitted to prevent the approval process from being bypassed in Oracle.

A secondary proxy user is recommended if the user being granted access for approvals also submits

purchase requisitions that require approval by the Approver.

To Grant Proxy Access To A Worklist:

1.  Go to the 'Notifications Summary' selection on the main Navigator menu

2.   Choose the 'Worklist Access' link on the lower left hand side of the Notifications screen

3.   Select the 'Grant Worklist Access' button

Name: Selection on the left will default to 'All Employees And Users'.  In the field to the right use the search function to select the user being granted Worklist access

Description: Title the proxy "PO Req Approval -  Enter Name Of Usef'

Start Date: Enter the start date the user will be granted proxy access

End Date: Enter the end date the user will be no longer be granted proxy access.  Leave this field blank to grant the user indefinite proxy access

Grant Access To: Enable the option 'Selected Item Types'.  Move the choice 'PO Approval' from Available Item Types to the Selected Item Types section

4.   Select the 'Apply' button

To grant proxy access to additional users select the 'Grant Worklist Access' button and repeat the steps. Choose the 'Close Window' link in the upper right section of the screen when done to return to the main menu.

worklist:

1.  Go to the 'Notifications Summary' selection on the main Navigator menu

2.   Select the 'Switch User' button

3.   Select the Approver's Worklist to be accessed

4.   Select the 'Apply' button

 

Work list Notifications for requisition approvals should now be visible.  Open the link for each notification, review the information, and select the appropriate action button to Approve, Reject, or Reassign.

Choose the 'Close Window' link in the upper right section of the screen when

What do the transaction mode (like transaction_mode = 8) numbers mean in the pending transactions table (MTL_MATERIAL_TRANSACTIONS_TEMP)?

What do the transaction mode (like transaction_mode = 8) numbers mean in the pending transactions table (MTL_MATERIAL_TRANSACTIONS_TEMP)?

Goal

What do the transaction mode numbers mean in the pending transactions table (MTL_MATERIAL_TRANSACTIONS_TEMP)?

Solution

The pending transactions can be found in the pending transactions form available from Inventory > Transactions > Pending Transactions or by looking directly in the pending transactions table (MTL_MATERIAL_TRANSACTIONS_TEMP).  The transaction modes have the following meanings:

Transaction Mode Number / Description

NULL or 1:  Online Processing

2:  Concurrent Processing

3:  Background Processing

8:  Internal Processing (Not visible in the pending transactions form)

Explanation

Here is an explanation of each:

NULL or 1:  Online Processing

Online processing is used by the Oracle Applications to immediately process records. This does not require that a concurrent program be run. The Transaction Manager does not process transactions marked for online processing.

2: Concurrent Processing

Transactions marked as concurrent transaction mode are processed by a dedicated transaction worker to explicitly process a set of transactions. The Transaction Manager does not process transactions marked for concurrent processing.

3: Background Processing

Interface transactions marked for Background processing will be picked up by the transaction manager polling process and assigned to a transaction worker. These transactions will not be processed unless the transaction manager is running.

8:  Internal Processing

Transaction mode 8 is not a mode normally visible to the user as it is used for internal processing.  Transactions with this mode are not visible in the Pending transactions form. Transaction_mode of 8 is used internally to identify if records came from the interface table to the pending table or came directly into the pending table.

** If you find stuck transactions with a mode of 8, you should log a Service Request with Oracle Support to get assistance processing these records.  This is often caused by transactions that exist both in the transaction open interface and in the pending transactions table.  In such a case, the transaction open interface records would be removed and the pending transactions would be processed by resetting the transaction mode to 3: Background Processing.

Identification

The following script can be used to identify the corrupted records in case the duplicate scripts do not return any data:

SELECT msi.segment1, tmp.PROCESS_FLAG, tmp.LOCK_FLAG,

tmp.TRANSACTION_MODE, tmp.ERROR_CODE, tmp.transaction_quantity,

to_char(tmp.transaction_date,'dd-mm-yyyy hh24:mi:ss')

FROM mtl_material_transactions_temp tmp, mtl_system_items_b msi

WHERE transaction_mode = 8

AND tmp.inventory_item_id = msi.inventory_item_id

AND msi.organization_id = &organization_id