My Oracle Support Banner

ReIM GL Posting With 4 Decimal Places For INCOME_LOCAL_CURRENCY When The Currency Is Configured For 2 (Doc ID 3040320.1)

Last updated on AUGUST 08, 2024

Applies to:

Oracle Retail Invoice Matching Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.

Symptoms

ReIM GL Posting with 4 Decimal Places for INCOME_LOCAL_CURRENCY ,when the Currency is configured for 2 decimal places.

Steps to Recreate:

CURRENCY_COST_DEC in CURRENCIES and IM_CURRENCIES table is 2.

1. Create a Purchase Order (PO).
2. Create a merchandise invoice.
3. Execute pre-payment of the invoice - this automatically triggers the invoice posting in AP tables (no need to run Reimposting).
4. Create PO shipment and receive the shipment.
5. Match the invoice.
6. Run Reimposting.

When running Reimposting, because the invoice was previously paid, it posts via the ReIM GL interface (IM_FINANCIAL_STAGE).

Observed that AMOUNT values are getting posted as per the IM_CURRENCIES configuration, with all the amount aggregation precision per currency code set to 2 decimal places.
However, INCOME_LOCAL_CURRENCY is getting posted with 4 decimal places, and the same is being posted in CFIN as well.

This discrepancy results in a GL balance issue when importing the ReIM journal entries to Cloud Financials.

Changes

 

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
Changes
Cause
Solution
References


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