Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts

Wednesday, July 22, 2015

This months favourites



In case these aren't already in your bookmarks; here's six new ones that I've found useful...  I thought everyone had these but talking in the office today seems not..

https://www.screenr.com/ - instant screen recording
https://www.udemy.com/ - courses including Java, Swift, Oracle, etc - only buy when there is a sale on..
https://www.dropbox.com  Storage in the cloud  
http://www.it-ebooks.info  free IT books
https://www.filmon.com/group/uk-live-tv watch UK TV without a Proxy (outside the UK)

Friday, February 20, 2015

Mass Close Workflow Notifications



We will use personalisation on the work list table to show 1000 records at a time, rather than 25 per page which you can then use to close old FYI type notifications.

Steps

Set the following options to enable personalisation.

Use System Administrator Responsibility 
Go to Profile >  System
Enter your username in the user field and query back each of the following and set as shown:

1              FND: Personalization Region Link Enabled Yes
2              Personalize Self-Service Defn Yes
3              Disable Self-Service Personal No

Logout of Applications.

Log back in (this makes sure the new profile option values get picked up)

Click on Personalize Page (top right)
Scroll down to “Table: Notification List”
Click on the ‘Edit’ (Pencil)
Scroll down to “Records Displayed”
Change the value from Inherit to 1000 in the Responsibility column.
Click on Apply at the end of the table
Click on Return to Applications at the end of the page
You will now see 1-1000 records.
Do your stuff. Use Select All and deselect records as appropriate.  Click on the Close button at the top and follow the steps to close.


Turn Off and Reset back to defaults

To Remove Change:
Click on Personalize Page (top right)
Scroll down to “Table: Notification List”
Click on the ‘Edit’ (Pencil)
Scroll down to “Records Displayed”
Change the value to Inherit from 1000, click on the Inherit arrow icon.
Click on Apply at the end of the table
Click on Return to Applications at the end of the page
You will now see 1-25 records.

Turn off Personalisation:

Use Responsibility System Administrator
Go to Profile >  System
Enter your username in the user field and query back each of the following and set as shown:

1              FND: Personalization Region Link Enabled No
2              Personalize Self-Service Defn No
3              Disable Self-Service Personal No



Thursday, September 29, 2011

Running legacy 11.5.10 Apps on Windows 7


This took a bit of time to get the right components working for an old 11.5.10 install working on Windows 7 build PCs but you can use the following to get up and running with Professional / Core / Forms based E Business Suite applications.

Internet Browser - Firefox 3.5.19
Download and install locally.

JInitiator - 1.3.1.26 
Download and install locally.
http://metis.eur.nl/forms/jinitiator/jinit.exe

Fix for JVM - download jvm.dll
http://sathyabh.at/2009/06/27/fixing-internet-explorer-crash-on-launchin
g-oracle-forms-application-with-jinitiator/

and save to C:\Program Files\Oracle\JInitiator 1.3.1.26\bin\hotspot

Browser Plug In
Copy C:\Program Files\Oracle\JInitiator 1.3.1.26\bin\NPJinit13126.dll to
C:\[replace wth your installation direcory for firefox 3.5.19 above]\FirefoxPortableLegacy36\App\DefaultData\plugins

Thursday, September 22, 2011

No Unix No SQL Loader Interfaces and Data Conversions

The classic Interface or Dataload routines take the form of a flat datafile being loaded into the database, then some PL/SQL processing to parse and validate the data before moving it (usually) into Open Interface tables.

The data file would usually need FTP'ing to a directory on the host, loading into the database with SQL*Loader, file copied and archived using Unix (.prog) and a concurrent program submitted to do the SQL processing.  These steps would probably be defined in a sequential request set.

With 11g its now alot easier and all of this can be done in one PL/SQL package using UTL_FILE, database directories and External tables.  No .prog. No Unix. No SQL Loader.


Basic steps are as follows.


Create the external table (use _FILE suffix for external tables)

create table xxap_invoice_file
(
BATCH_NUMBER                     VARCHAR(20),
BATCH_TYPE                      VARCHAR(20),
BATCH_DATE                      DATE,
VENDOR_NAME                        VARCHAR(240),
...
INVOICE_NUMBER                  VARCHAR(240)
)
organization external
( default directory xx_incoming_files
access parameters
( RECORDS DELIMITED BY NEWLINE
  FIELDS TERMINATED by ','
  OPTIONALLY ENCLOSED BY '"'
  MISSING FIELD VALUES ARE NULL
  ( BATCH_NUMBER,
    BATCH_TYPE,
    BATCH_DATE date 'DD-MM-YYYY',
    VENDOR_NAME,
     ...
    INVOICE_NUMBER
  )
)
location ('xx_data_file.csv')
);
The external table works on a fixed filename (location).  I suggest you copy a dated or numbered file at runtime.

     --  making copy of file as xx_data_file.csv to load
     UTL_FILE.FCOPY ( 
      src_location  => 'XX_INCOMING_FILES', 
      src_filename  => v_filename,  -- e.g. 'xx_data_file_01-JAN-2011.csv' 
      dest_location => 'XX_INCOMING_FILES', 
      dest_filename => 'xx_data_file.csv');

Now populate a custom interface table from the external table (adding a RUN_ID from a custom sequence)
INSERT INTO xxap_invoices
(run_id, batch_number, batch_type....)
SELECT xx_ap_invoices_s.nextval, batch_number...
FROM XXAP_INVOICES_FILE;
Perform custom validation and processing on the new data in XXAP_INVOICES and populate Open Interface tables.  Finally submit the open interface job using fnd_submit.

fnd_request.submit_request
More examples to follow.  Let me know if you've any suggestions or questions?

Wednesday, May 20, 2009

Oracle AIM 3 Download

If you're templates are out of date download the latest ones from here.  Took me some searching, theres a password protected zip file around on the web with some drawn out method of getting the password no one wants to share, but this one works out the box.