Why Duplicate Tax Accounting Lines Are Created by the 'Cost Accounting Creation' Process (CM_CSTACCTG) when the Landed Cost % Ext Amount Tolerance Is less than 100% (Doc ID 2000830.1)

Last updated on JANUARY 13, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 8.9 and later
PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
PeopleSoft Enterprise FIN Payables - Version 8.9 and later
Information in this document applies to any platform.
This Knowledge Document applies to Cost Management releases >= 8.9

Goal

Purchasing classifies Tax as Sales Tax. Cost Management books the accrual using the Sales Tax Cost Element. Accounts Payable books the Tax to Use Tax. Therefore, following a run of the 'Landed Cost Extract' process (LC_EXTRACT) Cost Management is creating Accounting Lines for the Use Tax Cost Element instead of updating the Accounting Lines for the Sales tax Cost Element.

In short, the 'Cost Accounting Creation' process (CM_CSTACCTG) is duplicating the Tax Accounting Lines.

The issue only occurs when the % Ext Amount Tolerance field on the 'Misc Charge/Landed Cost Defn' page (navigation: Set Up Financials/Supply Chain, Product Related, Procurement Options, Charges/Costs, Misc Charge/Landed Cost Defn) is < 100. If it is 100% it works fine.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms