Inventory COGS Account Generator

1
Inventory COGS Account Generator

• John PetersJRPJR, Inc.
• john.peters_at_jrpjr.com

2

• I am covering the Inventory COGS Account
  Generator
• Item Type INVFLXWF
• Display Name Inventory Cost of Goods Sold
  Account
• Run by the concurrent program Create
  Intercompany AP Invoices, short name INCIAP
• This is not the OM COGS Account Generator
• Item Type OECOGS
• Display Name OM Generate Cost of Goods Sold
  Account
• Run by the concurrent program Interface Trip
  Stop, short name WSHINTERFACE

3
Typical Error Situation

• Run the concurrent program Create Intercompany
  AP Invoices which completes with error.
• In the log file you will find something like the
  following

4

• Processing invoice line, ID 1658510
• Get if OM is installed
• ap.lineType is 1
• shipOrgId is 2 sellOrgId is 335
• newAccountingFlag 0
• trxFlowHeaderId is 88
• Getting the Sales Order Information
• global-gt
• soOrderType ... 1192
• soHdrId ....... 729052
• soLineId ...... 1498805
• soCustId ...... 12902
• sellOrgId ..... 335
• itemId ........ 13543
• Call inv_workflow.call_generate_cogs
• l_gl_ccid is 73928
• Message Dictionary couldn't open the ORA-20002
  3136 Item 'INVFLXWF/1765269' cannot be accessed
  while synchronous process in progress.
• application message file. Message Dictionary
  Error- A file pathname could not be constructed
  for the application ORA-20002 3136 Item
  'INVFLXWF/1765269' cannot be accessed while
  synchronous process in progress.
• . This error often indicates that the
  Application Basepath (e.g. FND_TOP) or
  Subdirectory (APPLMSG) environment variables do
  not have a valid value.

5
Basic Summary of the Problem

• The Inventory COGS Account Generator does not
  pre-populate most of the item attributes in the
  workflow.

6
How to Debug This Error

• Change the following profile options
• Account GeneratorPurge Runtime Data NoThis
  keeps the Account Generator data around in the
  OraApps tables after a process has run.
• Optionally
• Account GeneratorRun in Debug Mode Yes This
  generates Account Generator messages which
  usually dump to the log file of the program
  running it. This can by itself cause problems at
  times so dont initially turn this on.

7
Query up the Account Generator Process
8
(No Transcript)
9
(No Transcript)
10

• My contact information
• John Petersjohn.peters_at_jrpjr.com
  http//www.jrpjr.com
• Additional reference papers can be found
  athttp//www.norcaloaug.org
• http//www.jrpjr.com