Category Archives: Applications development
This excel has all established table links in the R12 views. You can use this excel to figure out how to link between tables or figure out how customer_id is used. The excel is generated by reading view source on a R12 and extracting … Continue reading
If you expect to use output and/or log files… utl_file.fclose_all will generate an error: ORACLE error 20100 in FDPSTP Cause: FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, l0478628.tmp in the directory… Use utl_file.fclose(p_file) instead.
We are using the xls4Oracle, to update customer data, and it has been working fine in 11i and R12 (until last week…) I have identified the issue: – After apps initialize – the fnd_global.org_id = -1 The workaround for the … Continue reading
Create the readonly role Grant select on all tables and views, selectable from apps, to the readonly role Create the readonly users For each readonly user: Grant the readonly role and create logon triggers to alter schema to apps. Use policy … Continue reading
220.127.116.112 09-dec-2011: (development) 18.104.22.168 10-dec-2011: (development) 22.214.171.124 10-dec-2011: (development) 126.96.36.199 20-dec-2011: (development) 188.8.131.52 27-dec-2011: (development) 184.108.40.206 03-jan-2012: (development) 220.127.116.11 07-jan-2012: (development) 18.104.22.168 11-jan-2012: (development) 22.214.171.124 13-jan-2012: (development) 126.96.36.199 27-jan-2012: (development) 188.8.131.52 12-feb-2012: (development) 184.108.40.206 12-feb-2012: (development) 220.127.116.11 20-apr-2012: (development) 18.104.22.168 … Continue reading
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
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
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.
Pls. download xls4Oracle 22.214.171.124 or greater Pls read about the windows update: http://technet.microsoft.com/en-us/security/bulletin/ms12-027 UPDATE 31-aug-2012: Just got the windows update on my work laptop, and could not execute any xlam files… First: delete any *.exd files – on my work laptop it … Continue reading