R12: PAXTRAPE: Transferring Expenditures from One Task to Another Gives "Please adjust this expenditure item in the source system because Automatic Offset Accounting is enabled and the adjustment will cause a change to the offset account". (Doc ID 2084561.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When transferring an expenditure item from one task to another in the same project using a non-seeded transaction source, the following error is returned:

"Please adjust this expenditure item in the source system because Automatic Offset Accounting is enabled and the adjustment will cause a change to the offset account"

The expenditure item is brought into projects through Transaction Import using a custom source with a system linkage of 'VI'.  The Automatic Offset Method in AP = Balancing.  According to the following, this should be possible if the CCID does not change:

PAXTRAPE - Adjusting Expenditure Items - Error: PA_INV_AUTO_OFFSETS_PAID (Doc ID 199898.1) and Bug 19297395 : CANNOT PERFORM TRANSFER OF EXP ITEM IN EXP INQUIRY WHEN AUTO OFFSET METHOD

The user guide also supports this functionality:

Oracle® Project Costing User Guide
Release 12.2
Part No. E48918-03

Automatic Offsets in Oracle Payables

If you enter invoices in Oracle Payables for more than one balancing segment, then you can use the Automatic Offsets feature to keep your Oracle Payables transaction accounting entries balanced. When you use Automatic Offsets, Oracle Payables automatically creates balancing accounting entries for your transactions.  When Automatic Offsets is enabled in Oracle Payables, you can make adjustments to supplier cost expenditure items in Oracle Projects under
the following conditions:

--When the Automatic Offset Method is Balancing, you can make an adjustment in Oracle Projects if the adjustment does not cause a change in the balancing segment value.

WORKAROUND
===========
They entered in a negative transaction just like the incorrect one to back out the expenditure item but want a fix moving forward



Cause

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