ITPub博客

转载几篇关于供应商导入的文章供应商导入简例------------------------------------------------------------------------------------------------------------------------------------------------------------------------Oracle ERP最佳技术实践之AP模块供应商数据导入参考------------------------------------------------------------------------------------------------------------------------------------------------------------------------Vendor InterfaceExisting and new

1) Check value of  profile option :AR: Enable Debug Message Output, it should be set to Yes 2) Run the following select statement to determine where the log will write to : select value from v$parameter where upper(name) = \'UTL_FILE_DIR\' this returns something like : VALUE -------------------------------------------------------------------------------- /usr/tmp, /usr/tmp, /u01/oracle/mc3yd213/db/tech_st/11.1.0/appsutil/outbound/mc3yd213_bej301441, /usr/tmpThe above is just an examp

The Script to list of its customer (party), account, site, address, collector, and other related information. SELECT ---------------------------------------------------------- -- Party Information ---------------------------------------------------------- hp.party_number "Registry ID", hp.party_name "Party Name", hp.party_type "Party Type", DECODE(hp

 * Purchasing:Purchasing Responsibility > Setup > Financials > Accounting > Control Purchasing Periods  * Inventory:Inventory Responsibility > Accouting Close Cycle > Inventory Accounting Periods  * GL:General Ledger Responsibility > Setup > Open/Close  * AP:Payables Responsibility > Setup > Calendar > Accounting > Accounting Periods  * AR: Receivables Responsibility > Control > Accounting > Open/Close Pe

AutoInvoice in Oracle Apps R12 AutoInvoice is a powerful, flexible tool you can use to import and validate transaction data from other financial systems and create invoices, debit memos, credit memos, and on–account credits in Oracle Receivables. You use a custom feeder program to transfers transaction data from an external system into the AutoInvoice interface tables. AutoInvoice then selects data from the interface tables and creates transaction in Receivables. Receivables rejec