B.1 Enabling FTP from PCD UI

(Required) <Enter a short description here.>

To enable FTP from PCD UI, follow these steps:

1. Login to PCD Config Schema.
2. Execute the following update query to enable FTP:

   update configuration set PARAMVALUE ='Y' where paramname ='FTP_ENABLED';
   commit;

   Default parameters when FTP is not enabled:

   Figure B-1 Default parameters when FTP is not enabled

   
   

   

   
   
   Default parameters when FTP enabled:

   Figure B-2 Default parameters when FTP enabled

   
   

   

   
   
3. Login to PCD Atomic Schema and execute below queries:
   1. To update Standard Process API:

      update API_DETAILS set URI='<ftp_host:port/context>/restapi/ftpPcdRestservice/v1/getStandardProcessList'            where endpoint='FTP_1';
      commit;

      Example URL: http://whf00osu:7777/ftpwar/rest-api/ftpPcdRestservice/v1/getStandardProcessList

   2. To update 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

   3. 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;

   4. In API_DYNAMIC_HEADERS table set headers_values with FTP login username and base64 encoded password

      update API_DYNAMIC_HEADERS set headers_values='FTPUSER' where headers='userid';
      commit;
      update API_DYNAMIC_HEADERS
      set headers_values='Basic RlRQVVNFUjpwYXNzd29yZDE='
      where headers='authorization';
      commit;
      

      Note:

      The following step must be executed only when PCD 8074 is installed and RM Summary is enabled.
4. 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>;

5. After executing above grants From PCD Atomic schema: execute following blocks.

   Enter unique acl name in below block like ex: 'pcd_acl_file.xml'
   BEGIN
   DBMS_NETWORK_ACL_ADMIN.drop_acl (
   acl          => 'pcd_acl_file.xml');
   end;
   /
   
   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
   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; 
   /

6. Login to PCD Application. Navigate to the Default Parameters and select the Standard Process under the Transfer Pricing parameters section.

   Figure B-3 Default Parameters