inv cogs account generator.ppt
TRANSCRIPT
1/23/02 John Peters, JRPJR, Inc. 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
1/23/02 John Peters, JRPJR, Inc. 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:
1/23/02 John Peters, JRPJR, Inc. 4
Processing invoice line, ID = 1658510Get if OM is installed ap.lineType is 1shipOrgId is 2 sellOrgId is 335newAccountingFlag = 0trxFlowHeaderId is 88Getting the Sales Order Information
global->soOrderType ... 1192soHdrId ....... 729052soLineId ...... 1498805soCustId ...... 12902sellOrgId ..... 335itemId ........ 13543
Call inv_workflow.call_generate_cogsl_gl_ccid is 73928Message 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 abortedEnd of Processing Invoice Line ID: 1658510
Invoice Line ID: 1658510 Status: FAILURE
1/23/02 John Peters, JRPJR, Inc. 5
Basic Summary of the Problem• The Inventory COGS Account Generator
does not pre-populate most of the item attributes in the workflow.
1/23/02 John Peters, JRPJR, Inc. 6
How to Debug This Error
• Change the following profile options:– Account Generator:Purge Runtime Data = No
This keeps the Account Generator data around in the OraApps tables after a process has run.
• Optionally– Account Generator:Run 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 don’t initially turn this on.
1/23/02 John Peters, JRPJR, Inc. 7
Query up the Account Generator Process
1/23/02 John Peters, JRPJR, Inc. 8
1/23/02 John Peters, JRPJR, Inc. 9
1/23/02 John Peters, JRPJR, Inc. 10
• My contact information:
John [email protected] http://www.jrpjr.com
• Additional reference papers can be found at:http://www.norcaloaug.orghttp://www.jrpjr.com