Installing API CCS Payment Details
This section focuses on the API CCS Payment Details installation, including:
Creating PL/SQL Package in the Oracle E-Business Suite Database
The Oracle E-Business Suite sysadmin or the Database Administrator are the indicated roles to create the PL/SQL package in the Oracle E-Business Suite database.
To create the PL/SQL package in the Oracle E-Business Suite database:
1. Download the PL/SQL package source file. It is located inside the ccs_ebs_fin.01_23_3000_sql.zip file. Read the ReadMe.txt file for more information about the configuration tasks.
2. Connect to the Oracle E-Business Suite database with the DB user you used to create custom objects.
3. Execute the PL/SQL package source file.
4. Create a synonym for the DB application user.
5. Grant the execute privilege to the DB application user.
Annotation
The package already has the annotation in the header section:
/* $Header: $ */
/*#
* This custom PL/SQL package can be used to retrieve CCS Payment details
* @rep:scope public
* @rep:product AP
* @rep:displayname ccs_payment_details
* @rep:category BUSINESS_ENTITY AP_PAYABLES
*/
/*#
* CCS Payment Details
* @param ReProcessDate varchar2
* @param ReProcessPayments clob
* @param Errors varchar2
* @param PaymentDetails clob
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname CCS_PAYMENT_DETAILS
*/
Validating the Annotation
To validate the annotation:
1. Copy the package header definition with the annotation to the corresponding path in the file.
$FND_TOP/patch/115/sql in the server where the Oracle E-Business Suite instance is running.
2. Generate the iLDT file.
$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -g -v -username=sysadmin per:patch/115/sql:ccs_payment_details.pls:23.3000=ccs_payment_details.pls
Note: Make sure to source the environment variables.
The command uses ccs_ebs_vendor_import_pkg.pls as the one including the annotation and the user sysadmin, the filename and the user can be different depending on the file name you are using and your Oracle E-Business Suite admin account.
The command will generate an iLDT file.
Example: ccs_payment_details_pls.ildt
Uploading Validated Annotation
Run the following command to upload the iLDT file to the Integration Repository. You can replace the iLDT file name with the file generated in the Validating the Annotation section.
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/wfirep.lct ccs_payment_details.ildt
Note: Make sure to source the environment variables.
Publishing as a Web Service
To publish the PL/SQL package:
1. Login to the Oracle E-Business Suite instance with the user that has Integration Repository Admin role.
2. Search for the PL/SQL Interface Type and Internal Name. Example: %CCS%
3. Click the “CCS_PAYMENT_DETAILS” package.
If the “CCS_PAYMENT_DETAILS” package is not listed on the Integration Repository tab, check for any warning or error message while creating the package. Refer to the Creating PL/SQL Package in the Oracle E-Business Suite Database section for more details.
4. Navigate to the REST Web Service tab, enter “GETCCSPAYMENTDETAILS ” as the alias, and click Deploy. If the deployment is successful, you will see the REST Service Status as “Deployed”.
5. Navigate to the Grants tab and create grant at least for the user you will use to configure the “OU EBSFIN for CCS-EBSFIN” Oracle Integration Cloud connection.