CST_MARGIN_SUMMARY Margin Analysis Load And Margin Analysis Report

(Doc ID 2402419.1)

Last updated on MAY 23, 2018

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Qn1:Margin Analysis Load Run (CSTMRGLD)
Margin Analysis Report with Order Management (CSTROMMA)
Purge Margin Analysis Run (CSTCMDEL)
  
Q1: Purge Margin Analysis Run (CSTCMDEL)
  Purging a Margin Analysis Load Run (Cost Management User’s Guide pp 14-40)
  You can purge only those previous margin analysis load runs which are not continuous.
  Margin Analysis Load Runs created with Oracle Order Management installed are
  continuous and cannot be purged.
  To purge a margin analysis load run:
  1. Navigate to the Purge Margin Analysis Run window.
  2. Enter the load name to purge.
  Questions:
  Is the Load Name the same as the Build Name? What indicates continuous or not?
  
Q2: Margin Analysis Load Run

 What tables are populated? What build is created? It looks like the old builds are updated?
The only tables I found were: cst_margin_summary, cst_margin_build, and cst_margin_temp (which seems to be identical to cst_margin_build)

*** What happens if the from date used to update the report already exists? Example: If 15-FEB-2018 is used as the from date when the data in the CST_MARGIN_SUMMARY includes date range 15-FEB-2018 to 28-FEB-2018 and option is Increment? The only Load Option I have is Increment – looks like the Refresh Load Option is disabled.

*** Are the same builds used for both reports: Margin Analysis Report (CSTRMRGA1) and Margin Analysis Report with Order Management (CSTROMMA) – New?

*** Is the overlap referencing the receivables interface table? If so, how is this handled when invoiced?
  
Q3. Margin Analysis Report with Order Management (CSTROMMA)
  What tables and builds does this report run against?
 
Q4: What are row_type (1,2,3,4,5)
Origin (1,2,3)
Can't find a reference for these and I am looking at an entry in the CST_margin_Summary table

Q5: Which has two sources Invoice and CR-Invoice for the same sales order on two different GL_dates
  with one crediting the earlier entry.

Q6. Also, what is the difference in source CR-INVOICE and RMA-INVOICE?

Q7. Looks like the Parent_rowid from the INVOICE source corresponds to the parent_rowid
  from the COGS source but some also correspond to the parent_rowid for the CR-INVOICE source.
  Is this when the invoice is credited within the same period?
 

Solution

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