Category Archives: News

xls4Oracle compability with Excel

The xls4Oracle tool is compatible with: Excel 2007 / 32bit Excel 2010 / 32bit xls4Oracle is unable run Excel 2010 / 64bit.  

Posted in Known Issues, News | Comments Off on xls4Oracle compability with Excel

R12 – Complete list of supported API’s

In R11 api’s was found in irep – in R12 api’s are found in the database. The “7417 Prototype scripts for API’s – R12” zip file is generated using the proto sql scripts from the sql4oracle.zip file. Extract was generated using … Continue reading

Posted in API, Applications development, Developer Scripts, News, R12, SQL | Comments Off on R12 – Complete list of supported API’s

xls4Oracle 4.0.1.104 released

Toolbar buttons updated – Is now: SQL, PLSQL & Setup. The icon navigates to the about tab on the about form New tab on the About form: Setup – that navigates to a new tab with new settings. The SQL … Continue reading

Posted in News, Revision History, xls4oracle | Comments Off on xls4Oracle 4.0.1.104 released

R12 migration procedure

For the migration of material statuses, we needed a procedure to update some of statuses. An Excel sheet with 13 status and all the flags and transaction types (allowed/disallowed) was base for the generation of a xls4Oracle generated load script. … Continue reading

Posted in Applications development, News, R12 | Comments Off on R12 migration procedure

xls4Oracle 4.0.1.92 released

The xls4Oracle 4.0.1.92 includes the following changes: – The xlam file is now in an installation package with certificate. NSIS used for creaton of the exe file. – sql function updated. A show hide columns function is added. Fetch into … Continue reading

Posted in News, xls4oracle | Comments Off on xls4Oracle 4.0.1.92 released

The xls4Oracle objects view

This view contains most objects in Oracle Applications. Use if for searching for customizations, forms, personalizations, workflow, value sets, profiles. If you can use FNDLOAD or WFLOAD the download and upload commands is generated for you.

Posted in Applications development, Developer Scripts, News, SQL, xls4oracle | Comments Off on The xls4Oracle objects view

New tool added: The xls4Oracle FIFO tool

Excel tool for FIFO Calculation:

Posted in News, xls4oracle | Comments Off on New tool added: The xls4Oracle FIFO tool

xls4Oracle 4.0.1.59 just uploaded

Posted in Dataload, News, Revision History, xls4oracle | Comments Off on xls4Oracle 4.0.1.59 just uploaded

xls4Oracle User Guide 4.0 just uploaded

download id="114" format="7" autop="false"]

Posted in News, SQL, xls4oracle | Comments Off on xls4Oracle User Guide 4.0 just uploaded

xls4Oracle – 4.0.1.52 – Just posted

Added new feature to refresh a sql sheet. The refresh will use the comment in the A1 cell to generate a new extract. When you press the xls4Oracle/sql button and the cursor is in a cell with an xls4Oracle comment … Continue reading

Posted in News, Revision History, SQL, xls4oracle | Comments Off on xls4Oracle – 4.0.1.52 – Just posted