Rma Cogs PDF

Download as pdf or txt
Download as pdf or txt
You are on page 1of 72
At a glance
Powered by AI
The document discusses upcoming Oracle webcasts on cost management topics and provides details on attending the COLLABORATE conference in Denver.

Some of the webcast topics mentioned include COGS accounting and EBS upgrades from version 11.5.10 to 12.1.3.

The COLLABORATE conference will take place from April 7-11, 2013 in Denver, Colorado and will include nearly 1000 educational sessions and an exhibitor showcase with over 250 vendors.

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Future Advisor Webcasts


Day, Date, 2004 time p.m. ET VOICE STREAMING ENABLED Teleconference Access:
North America: xxxx Teleconference Access: International: xxxx US & Canada: (866) 627-3315 Password: Advisor
Toll Number: +1-706-758-7972 Global Toll-Free: 1148600.1 Password: Oracle CST

Upcoming live webcasts and recent recordings..

VCP Webcast Calendar/Archive Doc ID 837233.1 Oracle Webcast Schedule/Archive Doc Id: 740966.1

What Cost Management advisor webcast topics do YOU want to see presented in 2013? Click here to let us know.

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

<Insert Picture Here>

COGS Accounting from RMA Perspective


Ramya Balasubramanian, Software Engineer Devaraju Holenarasipur, Sr. Principal software Engineer

Safe Harbor Statement


The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracles products remains at the sole discretion of Oracle.

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

<Insert Picture Here>

COGS Accounting from RMA Perspective


Ramya Balasubramanian, Software Engineer Devaraju Holenarasipur, Sr. Principal software Engineer

AGENDA
Presentation and Demo approximately 60 - 75 minutes Q&A Session maximum 15 minutes
Web attendees can ask questions via Q&A panel Phone attendees can ask questions via Q&A panel or phone

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Who to ask?

3 Send

your question

Q&A panel

type your question here

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

your question pops-up here

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

ATTENTION AUDIO INFORMATION


Voice streaming/Audio broadcast is available. For full audio access, please join the telephone conference.

Teleconference Connect details: 1. Conference ID: 2. International dial in: +44 (0) 1452 562 665 3. List with national toll free numbers is available in Note 1354453.1 Note: You can view this info anytime using WebEx menu from your WebEx-Session : Select Communicate --> Join Teleconference.

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Program Agenda

Introduction to Revenue COGS matching COGS Dataflow RMA Setup & Flow Various RMA Scenarios and their Accounting Entries Summary Of RMA Accounting Troubleshooting - Revenue COGS Diagnostics Not a bug Scenario Recommended Patches Q&A

10

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Introduction to Revenue COGS Matching


COGS should be recognized only when the revenue is actually earned. Till the time the revenue is earned, COGS is deferred. The Basic Principal is that COGS and Revenue should be recognized

in the same Period and in the same Ratio


At any given point in time, the ratio of deferred COGS to COGS should

be same as the ratio of deferred Revenue to Revenue.

11

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Deferred COGS DATA flow


SO Header SO Line Pick Release Ship Confirm
RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL & RA_CUST_TRX_LINE_GL_DIST_ALL OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

WSH_DELIVERY_DETAILS & MTL_MATERIAL_TRANSACTIONS

MTL_MATERIAL_TRANSACTIONS

Invoicing & Rev. Recognition

R.O.M.T

CST_COGS_EVENTS & CST_REVENUE_COGS_MATCH_LINES

C.R.R.I G.C.R.E

CST_REVENUE_RECOGNITION_LINES

CST_COGS_EVENTS & MTL_MATERIAL_TRANSACTIONS

12

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Understanding Return Material Authorization


Process Flow for Return Material Authorization.

13

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Setup required for RMA flow


1. Item Setup

2 Transaction type Return flow

14

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -1- Referenced RMA


Order Book SO Issue Rev Rec Cogs Rec RMA (Referenced)

Oe_order_lines_all

15

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 1 Referenced RMA


Mtl_Material_Transactions

Mtl_Transaction_accounts

16

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 1 Referenced RMA


If the SO Issue and RMA happens on the same day, following accounting entries are created. Debit Credit SO ISSUE DCOGS INV COGS Rec COGS DCOGS RMA INV DCOGS DOGS COGS If the SO Issue and RMA happens on different day, only one accounting entry is created. Debit Credit RMA INV COGS Reference:ER14559549 - COGS ACCOUNT GENERATED DIFFERENTLY BASED ON COGS EVENT DATE

17

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

17

Case -2- Un Referenced RMA


Order Book SO Issue Rev Rec Cogs Rec RMA (Un Referenced)

Oe_order_lines_all Sales Order issue

18

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -2- Un Referenced RMA

Oe_order_lines_all Unreferenced RMA

19

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -2- Un Referenced RMA

Mtl_Material_Transactions SOI & Cogs Recognition

Mtl_Transaction_Accounts SOI & Cogs Recognition

20

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -2- Un Referenced RMA

Mtl_Material_Transactions RMA Receipt

Mtl_Transaction_Accounts RMA Receipt

21

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -2- Un Referenced RMA


In case of Un Referenced RMA, RMA accounting hits only COGS account Debit Credit
SO ISSUE COGS RMA DCOGS COGS INV INV DCOGS COGS

Queries:
SQL> select reference_line_id "om_line_id from oe_order_lines_all where line_id=&rma_line_id; SQL> select trx_source_line_id rma_line_id from mtl_material_transactions where transaction_id=&transaction_id; /* Use RMA Receipt */

22

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

22

Case -3- SOI and RMA Qty same


Order Book SO Issue Rev Rec RMA (Referenced) COGS Rec

SO Issue Quantity =1 and RMA Quantity=1

Sales Order Issue RMA

Debit DCOGS INV

Credit Inventory DCOGS

23

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -3- SOI and RMA Qty same

24

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -3- SOI and RMA Qty same

There will be a COGS transaction line in MMT for 0 Quantity. Hence there will not be any Distributions created in MTA.

25

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case -3- SOI and RMA Qty same

CST_COGS_EVENTS

26

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

26

Case 4- Referenced RMA with Item cost Variation


Order Book SO Issue Rev Rec COGS Rec RMA (Referenced)

In Standard Costing Organization Item cost at the time of sales order issue is 10 and Item cost at

the time of RMA is 12. Debit Credit Sales Order Issue DCOGS(1 Qty) Inventory(1 Qty @ $10) COGS recognition COGS (1 Qty) DCOGS (1 Qty @$10) RMA INV(1Qty@ $12 ) DCOGS (1Qty @ $10) DCOGS(1 Qty) COGS (1Qty @ $10)

27

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 4- Referenced RMA with Item cost Variation


Mtl_Material_Transactions @Sales Order Issue

Mtl_Material_Transactions @ RMA

28

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 4- Referenced RMA with Item cost Variation


Mtl_Transaction_accounts

29

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 4- Referenced RMA with Item cost Variation


In Case of Average costing, FIFO, LIFO, the Sales Order Issue is hit at the current Average cost. RMA cost will be decided based on whether it is referenced or unreferenced Eg. Current avg cost as on 11-JAN - $10, Then SO ISSUE - $10 Current avg cost as on 15-JAN - $15 If a Referenced RMA is done on 15-JAN Treated as Cost Owned Transaction- $10 If an Unreferenced RMA is done on 15-JAN- Treated as Cost Derived transaction - $15

30

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

30

Case 5- SO Issue and Partial RMA


Order Book SO Issue Rev Rec RMA (Referenced) COGS Rec

Sales order = 3Qty (spilt into 2 and 1). RMA for 1 qty.

Sales Order Issue RMA COGS recognition

Debit Credit DCOGS(3 qty) Inventory(3 qty) INV (1qty) DCOGS (1qty) COGS (2 qty) DCOGS (2 qty)

31

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 5- SOI and Partial RMA


Mtl_Material_transactions

Mtl_transaction_accounts

SOI is for 3 qty, RMA for 1 Qty and COGS Recog done for 2 Qty (3-1)
32 Copyright 2013, Oracle and/or its affiliates. All rights reserved. Confidential Oracle Internal

Case-6- Ship Only Order Type and RMA


Order Book(Ship Only ) SO Issue COGS Rec RMA (Referenced)

Ship Only Item attributes for OM and Invoicing:

33

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case-6- Ship Only Order Type and RMA


In the order line choose the item type as ship only

34

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case-6- Ship Only Order Type and RMA


Transaction details

35

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case-6- Ship Only Order Type and RMA


SO ISSUE:

COGS Recognition:

RMA:

Reversal Entries:

36

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case-6- Ship Only Order Type and RMA


Debit DCOGS COGS INV DCOGS Credit Inventory DCOGS DCOGS COGS

Sales Order Issue COGS recognition RMA

In case of Ship Only Orders, once the line is closed, it insert a line in CRRL table with Potentially_unmatched_flag as U. Once the Generate COGS rec program is run Potentially_unmatched_flag becomes NULL and COGS trx is created in MMT and CCE tables.

37

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 7 Referenced RMA in ATO flow(100% Rev Rec)


Create Config Item Create Final Assembly Ship Confirm Revenue Rec Cogs Rec RMA Receipt (Ref)

ATO (Parent Assembly)

Optional Class1

Optional Class 2

Item1

Item 2

Item 3

Item 4

38

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 7 Referenced RMA in ATO flow(100% Rev Rec)


Order Line Details(OE_ORDER_LINES_ALL):

39

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 7 Referenced RMA in ATO flow(100% Rev Rec)


Mtl_Material_Transactions

Note: COGS recognition and RMA transactions are created across periods.

40

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 7 Referenced RMA in ATO flow(100% Rev Rec)


Sales Order Issue:

Transaction Type Sales Order Issue

Debit DCOGS

Credit Inventory

41

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 7 Referenced RMA in ATO flow(100% Rev Rec)


COGS Recognition:

Transaction Type Cogs Recognition

Debit COGS

Credit DCOGS

42

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 7 Referenced RMA in ATO flow(100% Rev Rec)


RMA Receipt:

Transaction Type RMA Receipt

Debit INV

Credit COGS

43

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 7 Referenced RMA in ATO flow(100% Rev Rec)


Cst_Cogs_Events

Summary of Accounting Entries: Transaction Type Debit Sales Order Issue(period 1) DCOGS COGS recognition(period 1) COGS RMA (period 2) INV Note: The accounting entries are created in the same way irrespective of the item type.
1 2 3 6

Credit Inventory DCOGS COGS


Event Type Description Sales Order Issue RMA COGS recognition RMA Place holder

44

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 8 - Referenced RMA in ATO flow(50% Rev rec)


Config ATO Item Ship Confirm 50% Rev Rec Cogs Rec RMA Receipt (Ref)

Setups to perform 50% rev recognition: Account Receivables(N)-> Setup-> Transactions-> Accounting Rules Define accounting rule for 50% deferral.

45

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 8 - Referenced RMA in ATO flow(50% Rev rec)


Order Management Super User(N)-> Setup-> Transaction Types In the line type workflow, under finance tab, choose the above

accounting rule

46

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 8 - Referenced RMA in ATO flow(50% Rev rec)


Summary of Accounting Entries: Debit Sales Order Issue COGS recognition RMA DCOGS COGS (50%) INV (50%) Credit Inventory DCOGS (50%) DCOGS (50%) COGS (50%)

47

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 9 SO ISSUE and RMA across periods


Order Book SO ISSUE Rev Rec RMA Receipt (Referenced) Cogs Rec

Sales Order issue and RMA Line Details

Oe_Order_lines_all

48

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 9 SO ISSUE and RMA across periods


Mtl_Material_Transactions

Note:1.Sales order issue for 3 Quantities created on 31-Dec-2012 . 2.Ran Revenue Recognition on 31-Dec-2012. 3.RMA Receipt for 1 Quantity created on 02-Jan-2013. 4.Ran Collect Revenue recognition and Generate cogs on 03-Jan-2013.

49

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 9 SO ISSUE and RMA across periods


Cst_Cogs_Events

Cst_Revenue_Recognition_lines

50

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 9 SO ISSUE and RMA across periods


Mtl_Transaction_Accounts

Reference:ER 12548020

51

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Case 9 SO ISSUE and RMA across periods


Summary of Accounting Entries: Debit Sales Order Issue RMA COGS recognition DCOGS ( 3 Qty) INV ( 1 Qty) COGS (3 Qty) DCOGS (3 Qty) Credit Inventory ( 3 Qty) DCOGS ( 1 Qty) DCOGS (3 Qty) COGS (3 Qty)

52

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Summary of RMA Accounting


Case 1: Referenced RMA (SOI-> Rev Rec-> COGS rec-> Ref RMA) Transaction Type (Done on the same Day)
SO ISSUE COGS Rec RMA

Debit
DCOGS COGS INV DCOGS

Credit
INV DCOGS DCOGS COGS

Transaction Type (Done on a different day)


SO ISSUE COGS Rec RMA

Debit
DCOGS COGS INV

Credit
INV DCOGS COGS

Case 2: Unreferenced RMA (SOI-> Rev Rec-> COGS rec->Un Ref RMA) Case 3: SOI and RMA quantity are same. (SOI-> Rev Rec->Ref RMA-> COGS Rec)

Transaction Type
SO ISSUE COGS Rec RMA

Debit
DCOGS COGS INV

Credit
INV DCOGS COGS

Transaction Type
SO ISSUE RMA COGS Rec

Debit
DCOGS INV No Accounting

Credit
INV DCOGS No Accounting

53

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Summary of RMA Accounting


Case4: Referenced RMA with Item Cost Variation (SOI-> Rev Rec-> COGS rec-> Ref RMA) SO and RMA quantity: 1 Item Cost at the time of sales order is $10 Item Cost at the time of RMA is $12 Case 5: SOI and Partial RMA (SOI-> Rev Rec-> Ref RMA-> COGS Rec) SOI for 3 Quantity and RMA for 1 Qty. Case 6: Ship Only Order Type and RMA (SOI -Ship Only-> Rev Rec-> COGS Rec-> Ref RMA) Case 7: Referenced RMA in ATO Flow(100% Rev Rec) (Create Config ATO Item->Book Order>Auto Create Assembly-> SOI-> Rev Rec > Cogs Rec-> Ref RMA SOI and COGS in Period 1 RMA in Period 2 Transaction Type Debit
SO ISSUE COGS Rec RMA DCOGS(1 Qty @ $10) COGS(1 Qty) INV (1 Qty @ $12)

Credit
INV (1 Qty @ $10) DCOGS(1 Qty @ $10)
DCOGS(1 Qty @ $10) COGS(1 Qty @ $10)

DCOGS(1 Qty @ $10)

Transaction Type Debit


SO ISSUE RMA COGS Rec DCOGS(3 Qty) INV(1 Qty) COGS(3-1 = 2 Qty)

Credit
INV(3 Qty) DCOGS(1 Qty) DCOGS(2 Qty)

Transaction Type Debit


SO ISSUE COGS Rec RMA DCOGS COGS INV DCOGS DCOGS COGS INV

Credit
INV DCOGS DCOGS COGS

Transaction Type Debit


SO ISSUE COGS Rec RMA

Credit
INV DCOGS COGS

54

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Summary of RMA Accounting


Case8:Referenced RMA in ATO Flow(50% Rev Rec) (Create Config ATO Item->Book Order->Auto Create Assembly-> SOI-> Rev Rec(50%) -> Cogs Rec-> Ref RMA Transaction Type
SO ISSUE COGS Rec RMA

Debit
DCOGS COGS(50%) INV

Credit
INV DCOGS DCOGS(50%) COGS(50%)

Case 9: SOI and RMA across periods (SOI -> Rev Rec->Ref RMA-> COGS Rec SOI for 3 quantity RMA for 1 quantity SOI in Period 1 and RMA & COGS in Period 2

Transaction Type
SO ISSUE RMA COGS Rec

Debit
DOCGS(3 Qty) INV(1 Qty) COGS( 3 Qty)

Credit
INV(3 Qty) DCOGS(1 Qty) DCOGS(3 Qty)

DCOGS(3 Qty)

COGS(3 Qty)

Entries need to be for 1 Qty. - ER: 12548020

55

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Debugging COGS issues


COGSDIAG.sql -------------------- Execute COGSDIAG.sql for any Sales Order you wish to troubleshoot using 'Run Script' command (or) run individual queries as per requirement. The SQL returns rows for all tables related to COGS Recognition from OM, AR, Inventory and Costing. View a Sample Output here - Sample Output

Reference: MOS DOC ID: 1307906.1- COGS Dataflow and Diagnostics

56

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

COGS Diagnostics How to Interpret


1. Check the Creation date and Transaction Date 2. Check COGS_PERCENTAGE and PRIOR_COGS_PERCENTAGE

columns in cst_cogs_events Table. Transaction_Type Cogs_percentage


No COGS recognition

Prior_cogs_percentage 0 0 0 0 1

SO Issue RMA
Full COGS Recognition

0 0 0 1 1

SO Issue COGS Recognition RMA


Partial COGS recognition across Periods

SO Issue(Period 1) COGS (Period 1) COGS (Period 2) RMA (Period 2)

0 .25 .50 .50

0 0 0.25 .50

57

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

COGS Diagnostics How to Interpret


3. The Transaction_date in mtl_material_transactions table for COGS transaction depends on last_event_date in cst_revenue_recognition_lines(CRRL) table.
- When Collect Revenue Recognition Information program is run,

inserts a line in CRRL table. This is populated by AR code.


- This is nothing but the Revenue Recognition date.

This can be checked from ra_cust_trx_line_gl_dist_all table. Column name - GL_Date.

58

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

COGS Diagnostics How to Interpret


4.

SO_ISSUE_ACCOUNT_TYPE column in MMT decides whether DCOGS/COGS account to be hit.


Above column is populated by inventory Code. If its value is 2, then it indicates that the sales order issue is done in R12,

so DCOGS comes into picture.


If its value 1 then it indicates that the sales order issue is done in 11i. So

Cogs account is hit.

Reference:Bug 13576673 - COGS RECOGNITION LINES NOT GENERATED AND DEFERRED COGS BALANCE IN GL INCREASES

59

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

COGS Diagnostics How to Interpret


5. Event Types:

Event Type Code

Meaning

1 2 3 4 5 6

Sales Order Issue RMA COGS Recognition COGS Recognition % Adj COGS Recognition Qty Adj RMA Place Holder

60

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

COGS Diagnostics How to Interpret


Event Type 6 and 2: Scenario1: SO ISSUE =10 qty RMA =3 qty Event Type 6 Event qty is 10 Event Type 2 Event qty as -3 COGS Rec for (10-3) =7 Scenario2: SO ISSUE =10 qty RMA =3 qty Event Type 6 Event qty is 10 Event Type 2 Event qty as -3 RMA for 4 qty Event Type 6 Event qty is 7 (10-3) Event Type 2 Event qty as - 4

61

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

COGS Diagnostics How to Interpret


Event Type 4-> COGS Rec % Adj (SO ISSUE-COGS-RMA) SO ISSUE is done, RMA is created with 0% COGS - This means the collect revenue and generate cogs programs are not run yet. - To correct the backdated cogs trx, adjustment event 4 is created. Event Type 5-> COGS Rec Qty Adj(SO ISSUE-RMA-REV and COGS) SO ISSUE is done in the month of Jan. Rev rec and cogs rec is done on Apr. In Feb RMA is created and it is stuck in MTI. In order to adjust this backdated RMA, event type 5 is created.

62

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Not a Bug
1.Distribution does not get created for Cogs Recognition:
a. When the SO ISSUE qty and RMA Qty are equal and are in same or different period. [SO ISSUE > RMA > Cogs ] b. When the Item costs is "ZERO" In CRCML table, check the new_cost. It will be "Null". c. when both the cogs % and Prior Cogs % are same(0 or any value) in cst_cogs_events Table.

63

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Not a Bug
2.Manual AR invoices linked to SO are not considered for COGS recog:

Only invoices created through Auto invoice program are getting considered for COGS recognition.
This is not a bug, the matching between AR invoice and Sales Order

shipment is controlled by OM, if the AR invoice is not from OM, the link between AR and INV is not maintained. Reference :Bug 14823225 - MANUAL AR INVOICES LINKED TO SALES ORDER ARE NOT CONSIDERED FOR COGS RECOGNITION

64

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Recommended Patches:
Recommended to Apply the following Patches: R 12.0: CSTRCMVB.pls 120.37.12000000.51 - Patch 12779598:R12.BOM.A R 12.1.X: 14180892:R12.BOM.C - CSTRCMVB.pls 120.45.12010000.48 14656876:R12.BOM.C - CSTRCMVB.pls 120.45.12010000.64* Note:-

*Patch 14656876:R12.BOM.C has some issue with Dependencies.


Hence, its recommended to first apply Patch 14180892:R12.BOM.C and then apply 14656876:R12.BOM.C inorder to upgrade CSTRCMVB.pls

65

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

References
Oracle Cost Management User's Guide Release 12.1 DOC ID1528307.1, COGS Accounting From RMA Perspective

66

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

To ask a question on the phone line, select *1 on your phone. To ask a question online, use the Q&A area at the top.

Your question will be read aloud in the order received. Question can also be asked on the My Oracle Support Communities

67

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Visit My Oracle Communities


Collaborate with a large network of your industry peers, support professionals, and Oracle experts to exchange information, ask questions & get answers. Find out how your peers are using Oracle technologies and services to better meet their support and business needs. Exchange Knowledge Resolve Issues Gain Expertise

Visit the My Oracle Support Community now!! 1. 2. 3. 4. Log into My Oracle Support. Select the Community tab. Select the Enter Here button. Select the Community Name link under the E-Business Suite section of the My Communities Menu on the left side of the window.

68

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Cost Management Advisor Webcast Calendar (Doc ID 1167580.1)

69

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

April 7-11, 2013


Denver, CO http://collaborate.oaug.org
Over five exciting days, trade ideas with more than 5,000 like-minded attendees, network with Oracle Corporation and more than 250 top third-party providers in the Exhibitor Showcase and choose from nearly 1,000 educational sessions to attend. COLLABORATE provides the best opportunity to explore how you can get the most out of your existing products and learn about others that you can integrate into your environment. Date/Time
Sun. Apr. 7 2:30 pm - 3:30 pm Sun. Apr. 7 3:45 pm - 4:45 pm Mon. Apr. 8 11:00 am - 12:00 pm Mon. Apr. 8 5:00 pm - 6:00 pm Tue. Apr. 9 2:00 pm - 3:00 pm Wed. Apr. 10 8:15 am - 9:15 am Wed. Apr. 10 3:00 pm - 4:00 pm

Session
12975 12978

Session Details
Oracle E-Business: Take Control of Workflow with Workflow Analyzer! EBS Upgrades: Save time and money on your upgrade from 11.5.10 to 12.1.3 Get Proactive: Best Practices for a Faster, Smoother Oracle EBusiness Suite Period Close EBS Meet the Experts: Bring your questions, we will have experts, answers and resources to help you. EVERYTHING EBS PATCHING! Oracle E-Business: Oracle Payables: Have a smoother accounting period close 432.1 Get Proactive: Finding answers faster through MOS and communities.

Track
Financial Modules Application Strategy and Services Financial Modules

12969

12976 12973 12974 12972

Financial Modules Application Strategy and Services Oracle E-Business Suite Financial Modules

Not an OAUG member? Register today at www.oaug.org


70 Copyright 2013, Oracle and/or its affiliates. All rights reserved. Confidential Oracle Internal

THANK YOU

71

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

Are You Ready To Get Proactive?


Discover more about Get Proactive
https://support.oracle.com/CSP/main/article?cmd=show &type=ATT&id=1385165.1:DISCOVER

Avoid the unexpected Dont leave value on the table Lower overall organizational costs through preventative maintenance Reduce risks and maximize uptime Achieve resolution faster Streamline and simplify your daily operations Get even more through connection

ACT Get Proactive


Access proactive capabilities available for your products by visiting the product pages at My Oracle Support; Article ID 432.1

Contact the Get Proactive team


today for help getting started
[email protected]

72

Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Confidential Oracle Internal

You might also like