Free Trial
4 steps to get started:
- Register
- Download and install the xls4oracle tool
- Receive a free 30 day trial key
- Select any of the xls4oracle templatesLinks
Meta
Monthly Archives: October 2008
Version 3.0.2.184 – Minor improvements
Multiline load error count and error message corrected. Moved first save workbook to after cancel/continue descision. The log file will generate in csv file format. Excel For Oracle Applications
Posted in Revision History
Leave a comment
QP_MODIFIERS_PUB template V104
Added line types as template lines for: – update header – update line – update att – create modifier Line – create modifier – exclude on new lines – exclude on new Modifiers – create qualifier – create pricebreak – … Continue reading
Posted in Templates Development
Leave a comment
Version 3.0.0.180 – Improved performance and added functionality
Dataload: Code has been optimized – the performance of the generate mapping section is now performing around 10 times faster. Added comment on heading line: mapping info. The ‘OK’ button on the status form is now defaulted – so you … Continue reading
Posted in Revision History
Leave a comment
Developing the Pricelist Modifiers Template v1.0.3
The new v1.0.3 Pricelist Modifier template is now including examples on: – Creating header, qualifier(s) and lines – Updating header – Updating line – Updating attributes – Creating pricebreaks – Deleting attributes (excl. items) This template is currently free to … Continue reading
Posted in Templates Development
Leave a comment
Version 3.0.0.178 – Bug in SQL fixed
If an extracted column value was null the previous column value was replicated. Excel For Oracle Applications
Posted in Revision History
Leave a comment
Developing the load_user_resp_v102.xls
The v101 was not perfect so – I started from scratch: Executed the api script from sqlplus: SQL> @api FND_USER_RESP_GROUPS_API @api2 FND_USER_RESP_GROUPS_API @api3 FND_USER_RESP_GROUPS_API ASSIGNMENT_CHECK 0 @api3 FND_USER_RESP_GROUPS_API ASSIGNMENT_EXISTS 0 @api3 FND_USER_RESP_GROUPS_API INSERT_ASSIGNMENT 0 @api3 FND_USER_RESP_GROUPS_API LOAD_ROW 0 @api3 FND_USER_RESP_GROUPS_API … Continue reading
Posted in Templates Development
Comments Off
PLS-00123 – Program too large
When doing multi line loads, you can encounter the limit on the plsql script. If you encounter this, pls. try to reduce the script by removing text not part of the code. The system variable “mapping lset” should set to … Continue reading
Posted in Known Issues
Leave a comment
Developed a new template to delete pricing attributes
The requirement is to delete pricing attributes. To do this the data sheet need: List_header_id List_line_id Pricing_attribute_id The generated script look like this: — @”c:\temp\pricelis_modifiers_delete_6.sql” — Excel for Oracle Applications – 3.0.0.178 — Copyright 2008 (C) – Thomas Lundqvist Consulting — based … Continue reading
Posted in Templates Development
Leave a comment
Developing the Pricelist Modifiers Template
The template is calling the QP_MODIFIERS_PUB.PROCESS_MODIFIERS API. This API can create pricelist modifiers, modifier lines and qualifiers. The modifier header is a record structure, while the rest is plsql tables. The API works very much like the form interface, so … Continue reading
Posted in Templates Development
Leave a comment
Version 3.0.0.177 – minor updates
Status form’s text window is now readonly. Status form showing $row_commit and $final_commit. Excel For Oracle Applications
Posted in Revision History
Leave a comment