How to set your user, responsibility, etc in PL/SQL to work with APPS functionsThis blog post covers a fairly simple PL/SQL block that allows you to initialise your APPS environment from within PL/SQL allowing you to do things like run concurrent requests.Language (NLS_LANGUAGE and NLS_TERRITORY)The most important thing to start with is to make sure that your language and the current APPS configured languages and territory are the same in your session as they are on the server. You only need to do this step if you are looking onto a server...
Thursday, October 13, 2011
Turning on Incremental Refreshing of Key Flex Field (KFF) data in Noetix.This blog post covers turning on the Incremental Refresh "manually". Noetix provide a Concurrent Request that you can run what will work in almost all circumstances - unfortunately our site was one where it wouldn't run due to a independent value set that should have had some values in being empty.NOTE: You *must* have initialised the APPS environment (calling APPS.FND_GLOBAL.APPS_INITIALIZE) in order for this to work. See Initialising the APPS Environment for my blog post...
You're always being told not to hard-code values into your code (and they're right BTW). This blog post gives instructions on creating a table/ package combination in order to allow settings to be saved/ loaded from within PL/SQL.The first step is to create a table to store the values;create table XXC_SYSTEMSETTINGS( setting_section VARCHAR2(80) not null, setting_name VARCHAR2(80) not null, setting_value VARCHAR2(240) not null, setting_type VARCHAR2(8) not null);alter table...
Thursday, October 6, 2011
This blog post describes a remedy for the issue which prevents Report Builder 3 from working with a Report in SharePoint integrated mode that has been migrated to SharePoint from a different server.At the moment Microsoft has no solution for this issue (other that "don't use Report Builder 3).NOTE: The exact problem that this blog post is showing you how to fix is detailed in another post here.Background/ SetupThe first step in fixing this problem...
This blog post (copied across from the original Knol) describes the "textfile-search-and-replace" windows application I've developed. It's far from complete but it is open-source so you download the source and change it yourselves if you want or just work with changes other people have made.Please feel free to report any bugs or feature requests via the "code.google.com" link below.NOTE: Check out other "textfile-search-and-replace" posts (clicking...
This blog post gives a brief overview of a dataset issue when attempting to work with a report which has been migrated from it's existing Reporting Server into a SharePoint Integrated Mode server.The report works when you run it but when you open it in Report Builder 3 and attempt to edit the dataset you get an error. 1. Duplicating the IssueGo to a report you have migrated from another document library;Trigger the pop-up menu and select "Edit in...
Tuesday, October 4, 2011
This blog post covers use of a fairly simple script to drop any invalid views in the NOETIX_SYS schema that should not have been already removed by the regenerate process (i.e. where a view shouldn't be there at all rather than having just failed to build correctly).The script (callable from XU6) is;@utlspon xu6_drop_unused_invalid_views_updbegin dbms_output.put_line('See 110930-000002 Invalid Views under NOETIX_SYS Schema'); dbms_output.put_line('-------------------------------------------------------'); dbms_output.put_line('Remove...
Subscribe to:
Posts (Atom)
