Manual Steps to do before testing FTP from PCD UI

B.4 Manual Steps to do before testing FTP from PCD UI

To do the testing FTP integration from the PCD UI manually, follow these steps:

Login to PCD Config Schema.
Execute the following update query to enable FTP:
```
update configuration set PARAMVALUE ='Y' where paramname ='FTP_ENABLED';
commit;
```
Figure B-31 Defualt Parameters when FTP is not enabled

Figure B-32 Defualt Parameters when FTP is enabled
Login to PCD Atomic Schema and execute following queries:
- To update the Standard Process API:
```
update API_DETAILS set URI='<ftp_host:port/context>/rest-api/ftpPcdRestservice/v1/getStandardProcessList'    where endpoint='FTP_1';
commit;
```
  Example URL: http://whf00osu:7777/ftpwar/rest-api/ftpPcdRestservice/v1/getStandardProcessList
- To update the Pricing API:
```
update  API_DETAILS
set URI='<ftp_host:port/context>/rest-api/ftpPcdRestservice/v1/getPricing’
where  endpoint='FTP_2';
commit;
```
  Example URL: http://whf00osu:7777/ftpwar/rest-api/ftpPcdRestservice/v1/getPricing
- Timed out URL:
```
update API_DETAILS
set URI='<ftp_host:port/context>/rest-api/ftpPcdRestservice/v1/getPricingData'
where endpoint='FTP_3';
commit;
```
  Example:
```
update API_DETAILS  set URI='http://whf00osu:7777/ftpwar/rest-api/ftpPcdRestservice/v1/getPricingData' where endpoint='FTP_3';
commit;
```
- In the API_DYNAMIC_HEADERS table, set the headers_values with FTP login username and base64 encoded password.
  
  Note:
  Base 64 encoded password should be generated for username:password. To get the base64 encoded password go to following link.
  https://www.base64encode.org/
  
  Example: If username is FTPUSER and password is oracle234:
  
  Username:password: FTPUSER:oracle234
  
  Encoded password: RlRQVVNFUjpvcmFjbGUyMzQ=
  
  Figure B-33 Encode to Base64 Format
1. Update API_DYNAMIC_HEADERS the UserId header with username:
  update API_DYNAMIC_HEADERS set headers_values='FTPUSER' where headers='userid'; commit;
2. Update authorization header with base64 encoded password as shown above to table with Basic as prefix:
```
update API_DYNAMIC_HEADERS
set headers_values='Basic RlRQVVNFUjpwYXNzd29yZDE='
where headers='authorization';
commit;
```
  Note:
  The following 3rd Step has to be executed only when PCD 8.1.2.0.0 is installed and RM Summary is enabled.
3. Grants to execute from sysdba:
```
grant execute on utl_http to  <pcd_atomic_schema>;
grant execute on dbms_lock to  <pcd_atomic_schema>;
grant execute on DBMS_NETWORK_ACL_ADMIN to  <pcd_atomic_schema>;
```
  After executing above grants From PCD Atomic schema: execute the following blocks.
  1. Enter unique acl name in the following block like ex: 'pcd_acl_file.xml':
```
BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'pcd_acl_file.xml', 
    description  => 'A test of the ACL functionality',
    principal    => 'PCD18CATOMIC',  -- pcd atomic schema name in capital
    is_grant     => TRUE, 
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);
end;
/
begin
  DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'pcd_acl_file.xml',
    host        => 'whf00osu',   -- ftp hostname
    lower_port  => 7777,      -- ftp port
    upper_port  => NULL);     
end; 
/
```
Login to PCD Application: Navigate to Default Parameters and select the Standard Process under Transfer Pricing parameters section.

Figure B-34 Default Parameters