Wrong Information Is Showed In Chilean Payables Purchase Ledger (Doc ID 2005928.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for the Americas - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Chile Payables


Wrong information is showed in Chilean Payables Purchase Ledger

Expect to see the correct information in the report


The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - 12.1.3
2. Path: Other -> Requests -> Run
3. Run the Chilean Payables Purchase Ledger (ZXCLPPLR.rtf 120.26.12010000.12 - latest version)

Arguments
------------
P_REP_CONTEXT_LVL_MNG='2000'
P_REP_CONTEXT_ENTITY_NAME='23280'
P_ACCT_PERIOD_FROM='JUL-14'
P_PRINT_COMPANY_INFO='Y'
P_REPORT_NAME='ZXCLPPLR'
P_REGISTER_TYPE='ALL'
P_PRODUCT='AP'
P_ACCOUNTING_STATUS='ACCOUNTED'
P_INCLUDE_AP_STD_TRX_CLASS='Y'
P_INCLUDE_AP_DM_TRX_CLASS='Y'
P_INCLUDE_AP_CM_TRX_CLASS='Y'
P_INCLUDE_AP_PREP_TRX_CLASS='N'
P_INCLUDE_AP_MIX_TRX_CLASS='N'
P_INCLUDE_AP_EXP_TRX_CLASS='N'
P_INCLUDE_AP_INT_TRX_CLASS='N'

When there are some invoices which contain voided lines, this report fails when try to get a net value,
so it shows an incorrect amount in the Amount field.

The issue occur only for invoices which contain voided lines, matched to PO or not.

The issue has the following business impact:

This report should be sent to the Government, so any delay can cause penalties.

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