This content has been marked as final. Show 5 replies
Could you please elaborate your exact requirement..
Basically this is what I am trying to achieve.
1. Create a staging table. The columns available for it are category_name, item_number, item_description, supplier, supplier_site, price, uom and currency.
So basically the user can load item details into the database from an excel sheet.
2. use the utl_file api, create an xml file called item_load.xml using the data in the staging table. this will create the xml file used to load items in iprocurement and save it in the database directory /var/tmp/iprocurement This part works great.
3. use the api fnd_request.submit_request to submit the concurrent program 'Catalog Bulk Load - Items & Price Lists'. This is where I am stuck. The process simply says pending or comes up with an error saying:
oracle.apps.fnd.cp.request.FileAccessException: File /var/tmp/iprocurement is not accessable from node/machine moon1.oando-plc.com.
I'm wondering if anyone has used my approach to load items before and if so, have they been successful?
noticed something, there is a profile option POR: Catalog Bulk Load Directory that is set to the value /tmp/
is this where I should be saving my xml files?
Yes.. As I noticed in our system, the profile value is directory path where the ItemPrice.txt files are stored when loaded through eContent Manager.
Also make sure that Incompatible programs related to 'Catalog Bulk Load - Items & Price Lists' are not running at the same time. Ex: Catalog Data Extract - Items. Even this scenario may cause the concurrent request to be in Pending mode till other Incompatible programs gets completed.
The concurrent program accesses the file from the middletier where the concurrent manager runs. Please check if any setting has changed. From the logs it is clear that "File /var/tmp/iprocurement" is not accessible by the concurrent tier.