R12: AP: AP ERV Lines Created With Incorrect Amounts
(Doc ID 3028532.1)
Last updated on JUNE 18, 2024
Applies to:
Oracle Payables - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Customer has Payables (AP) invoices that are interfaced to Projects.
Additional exchange rate variance (ERV) lines are created for AP distribution lines with foreign currency.
AP ERV Lines Created With Incorrect Amounts
The issue DOES NOT reproduce at will.
For better understanding, see the sample below:
Payables Invoice Number 25112511 (AP_INVOICES_ALL.invoice_num = 25112511 . AP_INVOICES_ALL.invoice_ID = 547658) has 4 distribution lines:
These invoice distributions got imported successfully to Projects. Data in Expenditure Inquiry form shows the following:
Notice the following:
1. The amounts of the 4 PA expenditure items match the amounts of Payables invoice distribution lines.
2. The BURDENED_COST and ACCRUED_REVENUE amounts are calculated correctly in Projects
3. Per customer, the Total BURDENED_COST and ACCRUED_REVENUE amounts should match, but they are not
(Total BURDENED_COST 229,549.48 <> Total ACCRUED_REVENUE 249,788.78).
4. The negative amounts of the 2 AP ERV lines are causing the difference in total BURDENED_COST and ACCRUED_REVENUE amounts.
| ACCOUNTING_DATE | LINE_TYPE_LOOKUP_CODE | BASE_AMOUNT |
| 01-Jan-2024 | ITEM | 221,702.60 |
| 01-Jan-2024 | ITEM | 25,524.24 |
| 01-Jan-2024 | ERV | -15,852.31 |
| 01-Jan-2024 | ERV | -18,25.05 |
These invoice distributions got imported successfully to Projects. Data in Expenditure Inquiry form shows the following:
| EXPENDITURE_ITEM_ID | RAW_COST | QUANTITY | BURDENED_COST | ACCRUED_REVENUE |
| 16239874 | 221,702.60 | 2297436.39 | 221,702.60 | 224,000.05 |
| 16239875 | 25,524.24 | 264499.84 | 25,524.24 | 25,788.73 |
| 16239941 | -15,852.31 | 0.00 | -15,852.31 | |
| 16239942 | -1,825.05 | 0.00 | -1,825.05 | |
| Total | 229,549.48 | 249,788.78 |
Notice the following:
1. The amounts of the 4 PA expenditure items match the amounts of Payables invoice distribution lines.
2. The BURDENED_COST and ACCRUED_REVENUE amounts are calculated correctly in Projects
3. Per customer, the Total BURDENED_COST and ACCRUED_REVENUE amounts should match, but they are not
(Total BURDENED_COST 229,549.48 <> Total ACCRUED_REVENUE 249,788.78).
4. The negative amounts of the 2 AP ERV lines are causing the difference in total BURDENED_COST and ACCRUED_REVENUE amounts.
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 |
| Cause |
| Solution |
| References |