My Oracle Support Banner

Incorrect Expenses In Obligations And Custom Entries (Doc ID 2981090.1)

Last updated on OCTOBER 20, 2023

Applies to:

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

Symptoms

On : 19.3 , Trade Mgmt - Obligations

ACTUAL BEHAVIOR
---------------
[MFCS]-[REIM] Incorrect expenses in obligations and custom entry.
In the import module, detecting an inconsistency in the amounts of the incremental expenses, that is to say, in the first step when the purchase orders are created, the estimated expenses are correct according to the calculation made by the system.

The information that arrives to the table INVC_NON_MERCH is not the correct one.

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

1. Create an import PO's : 3 PO's for 3 different locations.
2. The PO's should have same items.
3. Create a transportation for purchase orders by entering same 'Vessel / Voyage/Estimate-date' for all 3 PO's. (Meaning all 3 PO's comes in same transportation).
4. Finalize the transportation, During finalization provide 'Custom Entry' name. (say WAL-CE1) .
5. Open manage custom entry screen and in 'custom-detail' screen accept all manifest-quantities for all 3-PO's and save the changes.
6. Receive one of the PO out of 3-PO's created.
7. Create obligation at 'Trans.Container' level.
8. Let say the total Obligation as : 444 $ and it is for 2 components (Agent/ buyer agent) : 200 and 244 to be distributed. Save the changes it will create an invoice.
9. Notice that the invoice for 'INVC_NON_MERCH' table for 3 invoices created for 3 PO/locations the calculation is random
10. Customer expectation is that it should create one invoice for the amount entered : 444.

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


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