inventory cogs account generator n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Inventory COGS Account Generator PowerPoint Presentation
Download Presentation
Inventory COGS Account Generator

Loading in 2 Seconds...

play fullscreen
1 / 10

Inventory COGS Account Generator - PowerPoint PPT Presentation


  • 135 Views
  • Uploaded on

Inventory COGS Account Generator. John Peters JRPJR, Inc. john.peters@jrpjr.com. 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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Inventory COGS Account Generator' - abra-mcpherson


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
inventory cogs account generator

Inventory COGS Account Generator

John PetersJRPJR, Inc.

john.peters@jrpjr.com

slide2
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

John Peters, JRPJR, Inc.

typical error situation
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:

John Peters, JRPJR, Inc.

slide4
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->

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.

Warning: Invoice creation aborted

End of Processing Invoice Line ID: 1658510

Invoice Line ID: 1658510 Status: FAILURE

John Peters, JRPJR, Inc.

basic summary of the problem
Basic Summary of the Problem
  • The Inventory COGS Account Generator does not pre-populate most of the item attributes in the workflow.

John Peters, JRPJR, Inc.

how to debug this error
How to Debug This Error
  • Change the following profile options:
    • Account Generator:Purge Runtime Data = NoThis keeps the Account Generator data around in the OraApps tables after a process has run.
  • Optionally
    • Account Generator:Run in Debug Mode = YesThis 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 don’t initially turn this on.

John Peters, JRPJR, Inc.

slide10
My contact information:

John Petersjohn.peters@jrpjr.com http://www.jrpjr.com

  • Additional reference papers can be found at:http://www.norcaloaug.org

http://www.jrpjr.com

John Peters, JRPJR, Inc.