Category Archives: Templates Development

Pls. comment on witch new templates you want.

QP_MODIFIERS_PUB.PROCESS_MODIFIERS – Qualifiers

Qualifiers on header level can be create in one API call but to create a qualifier on modifier level, you need to have a second API call, using the return values from the first API: DECLARE – copyright 2008 – … Continue reading

Posted in API, Templates Development | Comments Off on QP_MODIFIERS_PUB.PROCESS_MODIFIERS – Qualifiers

Stock Locator Load

In 11.5.10 the INV_LOC_WMS_PUB.CREATE_LOCATOR API fails. As far as I can see, it is the key flex field validation that newer succeeds, and I can not find any insert statements in the API package – I am putting this one … Continue reading

Posted in Templates Development | Comments Off on Stock Locator Load

Customer Load R12 is verified on the Vision database

The custome load has just been verified on the Vision Release 12 database. The Load_customer_v207.xls has 5 rows that load: organization account account relations addresses business purposes Only the customer data sheet and the ‘created by module’ on the mapping sheet … Continue reading

Posted in Templates Development | Comments Off on Customer Load R12 is verified on the Vision database

Updated template: Load Pricelist Modifiers

The Load Pricelist Modifiers template has been updated. The plsql will handle sheet value inputs – that will fill the ID’s for API. In order to load line qualifiers, the modifier line must exist, so a second API call was … Continue reading

Posted in API, Templates Development | Comments Off on Updated template: Load Pricelist Modifiers

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 | Comments Off on QP_MODIFIERS_PUB template V104

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 | Comments Off on Developing the Pricelist Modifiers Template v1.0.3

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 on Developing the load_user_resp_v102.xls

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 on … Continue reading

Posted in Templates Development | Comments Off on Developed a new template to delete pricing attributes

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 API, Templates Development | Comments Off on Developing the Pricelist Modifiers Template

Templates

Pls. suggest new templates or request a change of the priority for templates. This is current priority: Load AP invoices (interface tables) FA loads GL loads

Posted in Templates Development | Comments Off on Templates