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 27, 2024

Applies to:

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
===========
Enter in a negative transaction just like the incorrect one to back out the expenditure item but want a fix moving forward

Cause

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