Oracle eBS經驗分享

Prerequisites for this example

1. 1.Oracle9i database
2. 2.Oracle9i Report

Start ==>

1.Download and install the example files

   1.1 Go to the Oracle Technology NetworkWeb site(http://otn.oracle.com/product/reports/).Download the files BarcodePaper.zip and BarCodeWeb.zip into a temporary directory on your machine (e.g., d:\temp).

  Download Information:

•   BarcodePaper.zip download from http://www.oracle.com/technology/products/reports/htdocs/getstart/examples/BarcodeBeanPaper/index.html

  BarCodeWeb.zip download from http://www.oracle.com/technology/products/reports/htdocs/getstart/examples/BarcodeBeanWeb/index.html

  1.2 Unzip the contents of the file, maintaining the directory structure, into an examples directory on your machine

2. Update the REPORTS_CLASSPATH environment variable

oraclebarcode.jar folder path to your client regedit “REPORTS_CLASSPATH”

  ex. ORACLE_HOME/Examples/BarCodeBeanPaper/Scripts/oraclebarcode.jar;

Bat file

<<test_ftp.bat>>==content==

date /T>>%date:~0,4%%date:~5,2%%date:~8,2%.log
time /T>>%date:~0,4%%date:~5,2%%date:~8,2%.log
ftp -n -s:ftpscript.txt>>%date:~0,4%%date:~5,2%%date:~8,2%.log
date /T>>%date:~0,4%%date:~5,2%%date:~8,2%.log
time /T>>%date:~0,4%%date:~5,2%%date:~8,2%.log

<<ftpscript.txt>> ==content==

open 192.168.xx.xx

user
username
password
cd unixfolder/xx/

put "filename.csv"
quit

Updating Item Attributes to NULL

 

 The method to update these columns to NULL is to use the following values:

· for Numeric fields: insert -999999

· for Character fields: insert '!'

· for Date fields: the above list does not include any updateable date fields.

1.FND_GLOBAL.USERID --Returns userid

2.FND_GLOBAL.APPS_INTIALIZE procedure

•    APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
     This is used to set the values userid and responsibilityid for a session
  3.FND_GLOBAL.LOGIN_ID -Gives login id
  4.FND_GLOBAL.CONC_LOGIN_ID--Not sure how to use this
  5.FND_GLOBAL.PROG_APPL_ID--Concurrent program application id
  6.FND_GLOBAL.CONC_PROGRAM_ID--Concurrent program id
  7.FND_GLOBAL.CONC_REQUEST_ID (Server)This will give the concurrent request id of the program which is calling the plsql package..

ln_Request_id:=FND_GLOBAL.CONC_REQUEST_ID;