E1: 42: Sales Update (R42800) Missing Cycle Billing Journal Entry On Direct Ship Order With 2 Or More Lines (Doc ID 2896059.1)

Last updated on NOVEMBER 22, 2022

Applies to:

Symptoms

When there is two or more lines on a Direct Ship (SD/OD) Sales Order, Sales Update (R42800) only creates one of two AAI 4231 Deferred Revenue Debit Entries, leaving the Sales Update Batch out of Balance by Sales Amount of one of the lines.

Steps to Reproduce:

1. Created a two-line Direct Ship (SD) Sales Order
   1. Line 1.000 has an Extended Amount of 48.80, Extended Cost of 54.65
   2. Line 2.000 has an Extended Amount of 420.00, Extended Cost of 58.02
2. After Ship Confirm (P4205), the client ran Cycle Billing (R49700). Report PDF shows the following journal entries are created.
   1. Deferred Revenue (AAI 4231) Credit -48.80 (first item)
   2. Deferred Revenue (AAI 4231) Credit -420.00 (second item)
   3. Deferred COGS (AAI 4221) Debit 54.65 (first item)
   4. Deferred COGS (AAI 4221) Debit 58.02 (second item)
   5. Unbilled A/R (AAI 4232) Debit 468.80 (sum of two items)
   6. Inventory (AAI 4240) Credit -112.67 (sum of two items)
3. After Invoice Print (R42565) run Sales Update (R42800). Report PDF shows the following
   1. AAI 4231 Deferred Revenue Debit for +48.80 was created
   2. AAI 4231 Deferred Revenue Debit for +420.00 is MISSING

Changes

Cause

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