XDOLoader To upload BURSTING_FILE

#!/bin/sh
#  $Header$
#
{
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME       apps \
-DB_PASSWORD       apps \
-JDBC_CONNECTION   hostname:portno:database \
-LOB_TYPE                  BURSTING_FILE \
-APPS_SHORT_NAME   SQLAP \
-LOB_CODE                   IBYR_BACS \
-XDO_FILE_TYPE          XML \
-FILE_CONTENT_TYPE text/xml \
-FILE_NAME               IBYR_BACS.xml \
-CUSTOM_MODE       FORCE \
-DEBUG             true
} > 123.log 2>&1


 The same way to download

#!/bin/sh
#  $Header$
#
{
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME       apps \
-DB_PASSWORD       apps \
-JDBC_CONNECTION    hostname:portno:database \
-LOB_TYPE          BURSTING_FILE \
-APPS_SHORT_NAME   SQLAP \
-LOB_CODE          IBYR_BACS \
 

No List of Values for Payment Terms in Customer Account Profile Window in Oracle R12

Check the payment term Billing Cycle Control or not.

Receivables Manager>Set Up > Transactions> Payment Terms ( Check Billing Cycle column)

select cycle_name,billing_cycle_id,name from ra_terms_vl

Even if yes or no then please try as below.

Receivables Manager> Customers > Customers

Query the customer concerned

Tab: Account Profile

Uncheck the 'Enable' check box under 'Balance Forward Billing' under Account Profile Tab and then check the payment terms should be now visible.

Remove special characters from string in SQL

Using  regexp_replace function we can remove all special characters in sql.

Ex : This is/Anil@Maguluri

In the above string we have two extra characters /@

select regexp_replace('This is/Anil@Maguluri', '( *[[:punct:]])', ' ') test_string from dual;

result : This is Anil Maguluri

Account Payable Trial Balance Report Shows Fully Paid invoices

Paid Invoice is Still Showing in Payable Trial Balance Report As Outstanding.
Please try this metalink-note    1474628.1

Single Euro Payments (SEPA)

Cross Border payments,
Single Euro Payments Area (SEPA)
Faster Payments
BACS


I have worked on all European Countries Payments in R12 for all International banks.Please contract me if you need any help.So i will guide you with proper information. 

How to disable the Prepayment Matching Program (ARPREMAT) from the AutoInvoice.

Disable the  Business Event  oracle.apps.ar.batch.AutoInvoice.run 

 System Administrator > Workflow > 

                       Administrator Workflow > Business Events 

 Search for the event: oracle.apps.ar.batch.AutoInvoice.run

 Click on Subscription icon.

 Locate the Function: AR_PREPAYMENTS.rule_select_prepayments

 Click on the pencil icon to update the subscription and change status to Disabled. 

                              Save your changes.

Remittance Advices R12 (Send Separate Remittance Advices)

To Configure e-mail Remittances in R11, AP Remittance Advice (APPEWF) Workflow will be fired automatically based on business Event oracle.apps.ap.payment
 
R12 this workflow obsoleted. Oracle has given Send Separate Remittance Advices . To work this before we need to disable the below Business Event.

1. Login using the SYSADMIN user
2. Responsibility: Workflow Administrator Web Applications
3. Navigate:  Administrator Workflow -> Business Events.
4. Search Criteria  = oracle.apps.ap.payment , Click Go.
5. Click the "Subscriptions" icon for the Payment Event.
6. Click the Edit icon for ap_payment_event_wf_pkg.rule_function
7. Change the Status from "Enabled" to "Disabled" in Execution Condition Region.
8. Click Apply.

Step1
First we need to set up xdodelivery.cfg  based on e-mail,print and fax  which ever we want.
If the requirement is Email then find the correct SMTP host name and save the file in $XDO_TOP/resource/xdodelivery.cfg

<?xml version="1.0" encoding="UTF-8" ?> 
<config xmlns="http://xmlns.oracle.com/oxp/delivery/config"> 
<servers> 
<server name="mysmtp1" type="smtp_email" default="true"> 
<host>myhost.mydomain</host> 
<port>25</port> 
</server> 
</servers> 
<properties> 
<property name="ds-temp-dir">/tmp</property> 
<property name="ds-buffering">true</property> 
<property name="SMTP_CONTENT_TYPE:String">"application/pdf"</property> 
</properties> 
</config>

Step2
Set the Profile Option IBY: XML Publisher Delivery Manager Configuration File
Ex /u01/app/UATBAU/apps/apps_st/appl/xdo/12.0.0/resource/xdodelivery.cfg

Step3
Configure Profile options

IEX: SMTP From
Should Specify the E-mail From Address

IEX: SMTP Host
Should Specify the E-Mail host.

Step4
Login to the application.
Responsibility = Application Developer
Navigate : Application -> Messages

Query
IBY_FD_SRA%

Two Messages are returned.
IBY_FD_SRA_EMAIL_FROM
The Seeded message is...
account_payables@visioncorp.com

and the other
IBY_FD_SRA_EMAIL_SUBJ
The Seeded message is...
Separate Remittance Advice: payment reference number - &PMT_REF_NUM

Modify those messages to meet your requirement.

Step5

Configure the Separate Remittance Advice Delivery Method at Supplier and Supplier Site.

Step6

Specify the Separate Remittance Advice Format when configuring the Payment Process Profile.

Reporting Tab

Format - Specify The Remittance Advice Format you wish to use for this PPP Automatically Submit at Payment Completion Point -
              Check the Box for Automatic Submission
              Allow Multiple Copies for Payment Instruction - Check The Box if you want the user to be able to  print more than once.Condition

Step7.

Now Send Separate Remittance Advices will triggered after Payment Process Request. After finishing request supplier receive an automatic email with content designed in IBYR_SRA.rtf.

You can amend if you have any changes then upload it.

P.S.
Send Separate Remittance Advices will not send the output as an PDF attachment, because of  Bug 8208646  its an oracle enhancement request.
So this is going to be customization and have to create own data definition,template  and we need to attach bursting file to data definition for automatic Email functionality.
       
          

Error: '500 Internal Server Error' When Clicking The LOV( Discoverer)

The following error is encountered when clicking List Of Values in Discoverer Viewer:

"500 Internal Server Error"


Change the timeout for the EXISTING individual workbooks, do the following:

1. In the Viewer, open the workbook and click on the Preferences link and increase value

'Cancel list-of-values'

2. In the PLUS, open the workbook -> Tools -> Tools -> option -> Query Governor -> increase the time for 'Cancel list-of-values retrieval after'

ORA-02291: Integrity Constraint (GMI.IC_LOTS_MST_IC_ITEM_MST_B_FK) Violated

This error because of Trigger in IC_ITEM_MST (OPM Item Master). Whenever item created in OPM it will creates a item in Discrete Inventory side(MTL_System_Items_B).


Please recompile Flexfields.
Navigate to Oracle Inventory > Setup > Flexfields > Key > Segments.
Query on Application 'Inventory' and flexfield title ' System Items'.
To recompile the flexfield

APP-FND-00​500: AFPPRN Received a Return Code of Failure from Routine FDUPRN. Program Exited With Status 64

If the Payment instruction contains Payments from other Operating Units and 

if MOAC security is enabled, then we see this error will come. 

Check the below setups.

a.) check the profile 'MO: Security Profile' at user level or responsibility level.

b.)Navigate to HRMS Super User Responsibility > Security > Define Security Profile. 

Search for the profile '%%Value set in Step a %%'

Check the Security Type, It should be 'Secure organizations by organization hierarchy and/or 

organization list' in the organizations list, 

please ensure whether the right Operating unit is added. (as assigned to your responsibility).

After this, run 'Security List Maintenance request' concurrent program with the parameters: 

- Generate lists for = One Named Security Profile 

- Security Profile = 'Value set in Step a'

2. Ensure that the profile option 'Sequential Numbering' is set to 'Not Used'.

3. Navigate to 'Concurrent >> Program' 

Search for 'Format Payment Instruction Program'. 

Uncheck 'print' option. Save. 

Now run the concurrent program again.

How to Change the Output File Name Created by Payment Process Request

R12 after finishing Payment Process Request,Format Payment Instructions with Text Output request generates out put in particular directory depends on the below set up.

Default name of file is Request id.file extension

Oracle Payments Setup > Payment Process Profiles >

So the general requirement will be rename the file with sysdate, R11 i we can attach a custom program to payment program which will rename the file with sysdate for that payment request,Where as in R12 we don't have option to attach any custom program to do that.

By using the below script we can rename with sysdate.(Scheduled the same in UNIX)

#!/bin/sh

# Created: Anil Maguluri

# To rename the UK Format Payment Instructions with Sysdate

#-------------------------------------------------------------------

{

echo Format Payment Instructions

for file in UK*.xml

do

newfile=$(date "+%d%b%Y_$file" -d "$(stat -c "%y" $file)")

mv "$file" "$newfile"

done

echo rename the file

} > UK_install.log 2>&1

Dependent value sets in discoverer

This can be done only in Oracle Discover Plus 10g.

Go to parameter screen,on the right bottom of the form you have an Option "Filter the List of Values based on the selection conditions". Specify the parameters based on which the value need to be filtered.

 

Oracle Forms Development steps

1.      Set New Environment Variable for FORMS60_PATH

My Computer à PropertiesàAdvanced

Click on Environmental Variables  à Goto System variables

Click on New

Enter   Variable name: FORMS60_PATH

            Variable value: your local resource library path

Close and open the forms builder.

2.      Now copy the .plls from /ora_home/au/11.5.0/resource/

1.      FNDSQF

2.      JE

3.      JL

4.      GLOBE

5.      APPCORE2

6.      HRKPI

7.      PSB

8.      PSA

9.      IGI_CBC

10.  IGI_CC

11.  IGI_DOS

12.  IGI_EXP

13.  IGI_IAC

14.  IGI_MHC

15.  IGI_SIA

16.  IGI_STP

17.  GMS

18.  FV

19.  APPDAYPK

20.  APPFLDR

21.  GHR

22.  IGILUTIL2

23.  IGILUTIL

24.  JA

25.  APPCORE

26.  VERT

27.  PQH_GEN

28.  PSAC

29.  CUSTOM

30.  OPM

31.  VERT1

32.  VERT2

33.  VERT3

34.  VERT4

35.  VERT5

3.      Now copy the APPSTAND.fmb & TEMPLATE.fmb into your local directory

4.      Open the Oracle Forms Builder and try to open the libraries in the same order as above

5.      Open the APPSTAND.fmb or TEMPLATE.fmb they will be opened.

6.      Now for TEMPLATE.fmb Save as.. your required form name according to naming conversions. And change the name in FORM property palette.

7.      Open the Windows navigator and delete the BLOCKNAME window.

8.      Open the Canvases navigator and delete the BLOCKNAME canvas.

9.      Open the Data Blocks navigator and delete the BLOCKNAME data block.

10.  At data block navigator click + sign in tool palette proceed to create a data block

11.  Similarly use wizard to prepare layout as required

12.  Enter the details in PRE-FORM (Form level) trigger, for author etc., enter the first block name, and window name

13.  Enter the FORM NAME in the WHEN-NEW-FORM-INSTANCE (Form Level) trigger.

14.  Create new windows as required, and attach the window to canvas and vice versa.

15.  Include Subclass Information for all newly created things in their respective Property palette.

16.  At Program Unit: APP_CUSTOM (Package Body) enter <your first window> and <it child window> and <yet its child window> this will help to create relationship between windows viz. master-child.

17.  Save all the changes and SFTP to /ora_home/au/11.5.0/forms.

18.  Open telnet...IP address <username>, <password> cd to /ora_home/au/11.5.0/forms

19.  type the following command:

f60genm Module=<formname> Userid=<userid/password> [Parameters].

Optional parameters are (default values given):

Ex: f60genm Module=employee.fmb Userid=apps/apps Module_Type=FORM Output_File=/ora_home/cutom_folder/11.5.0/forms/US/employee.fmx

20.  The server shows all the compiled details with errors if any.

21.  Register the form as usual.

Note: To open any Oracle Standard Form copy into local system and Try to open it show what are all the libraries it needs to load, write them in a notepad and copy them from the server /ora_home/au/resource path and put in the default local resource library path

How to enable record history in Oracle custom form

Step1 :

The below is the Oracle  custom form, When we click on record history getting error as record history is not available here

Step 2 :

Alter the custom table by adding who columns.

alter table

      XXXXXXXXXXXXXXXXXX

add   (CREATION_DATE        DATE,

       CREATED_BY           NUMBER,

       LAST_UPDATE_LOGIN    NUMBER,

       LAST_UPDATED_BY      NUMBER,

       LAST_UPDATE_DATE     DATE

       )

Step 3 : Go to the forms builder and select the FMB.

             Then click on Data Block and Refresh  

Step 4 :  Select the new added Who columns

               

 Step 5 : 

Select PRE-INSET and PRE-UPDATE triggers and then  add

FND_STANDARD.SET_WHO;

Setp 6 :

 Compile the FMX and here you go :)

         

            

              

 

How to make a Oracle form Query Only

1. Login into the System Administrator/Application Developer responsibility.
2. Navigate to 'Security -> Responsibility -> Define'
3. Query for the responsibility for which you want to make the form as 'Query Only' and copy the 'Menu' name.
4. Navigate to 'Application -> Menu' and query with the menu name which we got in step 3 in 'User Menu Name'
5. Now look out for the form (Prompt) you want to make it as query only. Copy the value in the 'Function' field w.r.t the form that needs to be made as 'Query Only'.
6. Navigate to 'Application -> Funtion' and query with the function name we got in Step 5 in 'User Function Name' field.
7. Identify the correct Function for your form and then naviagate to the 'Form' tab.
8. Enter the value: QUERY_ONLY=YES

Customer Profile Class API in Oracle Apps (hz_customer_profile_v2pub.update_customer_profile)

BEGIN
   p_customer_profile_rec_type.cust_account_profile_id := 19273;
   --p_customer_profile_rec_type.credit_rating := 'Excellent';
   p_customer_profile_rec_type.PROFILE_CLASS_ID :=1085;
   p_object_version_number := 3;
  
   hz_customer_profile_v2pub.
   update_customer_profile (
      p_init_msg_list           => 'T',
      p_customer_profile_rec    => p_customer_profile_rec_type,
      p_object_version_number   => p_object_version_number,
      x_return_status           => x_return_status,
      x_msg_count               => x_msg_count,
      x_msg_data                => x_msg_data);
   FND_FILE. put_line (fnd_file.output,'x_return_status = ' || SUBSTR (x_return_status, 1, 255));
   FND_FILE. put_line (fnd_file.output,'Object Version Number = ' || TO_CHAR (p_object_version_number));
   FND_FILE. put_line (fnd_file.output,'Credit Rating = ' || p_customer_profile_rec_type.credit_rating);
   FND_FILE. put_line (fnd_file.output,'x_msg_count = ' || TO_CHAR (x_msg_count));
   FND_FILE. put_line (fnd_file.output,'x_msg_data = ' || SUBSTR (x_msg_data, 1, 255));
   IF x_msg_count > 1
   THEN
      FOR I IN 1 .. x_msg_count
      LOOP
         FND_FILE. put_line(fnd_file.output,SUBSTR (FND_MSG_PUB.Get (p_encoded => FND_API.G_FALSE), 1, 255));
      END LOOP;
   END IF;
EXCEPTION
   WHEN OTHERS
   THEN
      FND_FILE.put_line(fnd_file.output,'Error: ' || SQLERRM);
END;

This record in table hz_customer_profiles cannot be locked as it has been updated by another user.

The current Object Version Number did not assign to p_object_version_number value before calling public API.

HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE API

Please add the following in script before calling API

SELECT object_version_number
INTO in_out_object_version_number
FROM hz_customer_profiles
WHERE cust_account_profile_id = &cust_account_profile_id;

 

 

Customer Credit Limits API in Oracle Apps

DECLARE
l_cust_prof_amt_rec    hz_customer_profile_v2pub.cust_profile_amt_rec_type;
l_version_num          number;
BEGIN        
l_cust_prof_amt_rec.cust_acct_profile_amt_id :=hz_cust_profile_amts.cust_acct_profile_amt_id;
l_cust_prof_amt_rec.trx_credit_limit := 0;                                                
l_cust_prof_amt_rec.overall_credit_limit :=1000;
l_version_num := l_cbd_rec (l_cbd).object_version_number;                      
                      hz_customer_profile_v2pub.update_cust_profile_amt
                                                      ('T',
                                                       l_cust_prof_amt_rec,
                                                       l_version_num,
                                                       l_return_status,
                                                       l_msg_count,
                                                       l_msg_data
                                                       );
END;   

Customer RelationShips using API in Oracle

DECLARE
l_cust_acct_relate_rec   hz_cust_account_v2pub.cust_acct_relate_rec_type;
l_msg_count              NUMBER;
l_msg_data               VARCHAR2 (2000);
l_return_status          VARCHAR2 (2000);
BEGIN
l_cust_acct_relate_rec.cust_account_id :=l_main_rec (l_main).cust_account_id;
l_cust_acct_relate_rec.related_cust_account_id :=l_rel.cust_account_id;
l_cust_acct_relate_rec.relationship_type := 'ALL';
l_cust_acct_relate_rec.created_by_module := 'DELL_AP_DATA_MIGRATION';
l_cust_acct_relate_rec.CUSTOMER_RECIPROCAL_FLAG := 'Y';                                                    
              hz_cust_account_v2pub.create_cust_acct_relate
                                                     ('T',
                                                      l_cust_acct_relate_rec,
                                                      l_return_status,
                                                      l_msg_count,
                                                      l_msg_data
                                                      );
END;

Unix FTP from Oracle to Windows

########################################
#Transfer file to Windows from  Archive#
########################################

echo 'Trying to copy files into FTP folder'

   sftp -nv <<END_OF_REMOTE_DIR
   open 120.10.1.1
   user ${FTP_UNAME} ${FTP_PWD}
   lcd  $Oracle_DIR
   cd   $Windows_DIR 
   binary
   for  file in ${FILE_NAME}*.${FILE_EXT}
   do
   mput  *.txt
   done
   bye
END_OF_REMOTE_DIR

rename the file with Sysdate in Unix

########################################
#                  Rename the file with sysdate               #
########################################

 
 for file in ${FILE_NAME}*.${FILE_EXT}
 do
 newfile=$(date "+%d%b%Y_$file" -d "$(stat -c "%y" $file)")
 mv "$file" "$newfile" 

Standard API for Supplier Sites (R11 i)

DECLARE
   CURSOR cur_suppsites_r11 (p_vendor_site_id NUMBER)
   IS
      SELECT pvsa.*, pvsa.ROWID
        FROM po_vendor_sites_all pvsa
       WHERE 1 = 1
       AND pvsa.vendor_site_id = p_vendor_site_id;
   v_date             DATE;
   v_itemkey          VARCHAR2 (100);
   v_vendor_site_id   NUMBER;
   v_user_id          NUMBER;
   v_resp_id          NUMBER;

BEGIN
   v_user_id := 7240; --fnd_profile.VALUE ('USER_ID');
   v_resp_id := 51683;--fnd_profile.VALUE ('RESP_ID');
   v_vendor_site_id := 37425;

   fnd_global.apps_initialize (user_id           => v_user_id,
                               resp_id           => v_resp_id,
                               resp_appl_id      => 200
                              );

   FOR v_site IN cur_suppsites_r11 (v_vendor_site_id)
   LOOP
      ap_vendor_sites_pkg.update_row
         (x_rowid                                => v_site.rowid,
          x_vendor_site_id                   => v_site.vendor_site_id,
          x_last_update_date               => v_site.last_update_date,
          x_last_updated_by                => v_site.last_updated_by,
          x_vendor_id                          => v_site.vendor_id,
          x_vendor_site_code              => v_site.vendor_site_code,
          x_last_update_login               => v_site.last_update_login,
          x_creation_date                     => v_site.creation_date,
          x_created_by                        => v_site.created_by,
          x_purchasing_site_flag           => v_site.purchasing_site_flag,
          x_rfq_only_site_flag              => v_site.rfq_only_site_flag,
          x_pay_site_flag                     => v_site.pay_site_flag,
          x_attention_ar_flag                => v_site.attention_ar_flag,
          x_address_line1                    => v_site.address_line1,
          x_address_line2                    => v_site.address_line2,
          x_address_line3                    => v_site.address_line3,
          x_city                                   => v_site.city,
          x_state                                 => v_site.state,
          x_zip                                    => v_site.zip,
          x_province                           => v_site.province,
          x_country                             => v_site.country,
          x_area_code                        => v_site.area_code,
          x_phone                               => v_site.phone,
          x_customer_num                  => v_site.customer_num,
          x_ship_to_location_id          => v_site.ship_to_location_id,
          x_bill_to_location_id           => v_site.bill_to_location_id,
          x_ship_via_lookup_code    => v_site.ship_via_lookup_code,
          x_freight_terms_lookup_code         => v_site.freight_terms_lookup_code,
          x_fob_lookup_code            => v_site.fob_lookup_code,
          x_inactive_date                   => v_date,
          x_fax                                  => v_site.fax,
          x_fax_area_code                => v_site.fax_area_code,
          x_telex                               => v_site.telex,
          x_payment_method_lookup_code        => v_site.payment_method_lookup_code,
          x_bank_account_name       => v_site.bank_account_name,
          x_bank_account_num         => v_site.bank_account_num,
          x_bank_num                      => v_site.bank_num,
          x_bank_account_type        => v_site.bank_account_type,
          x_terms_date_basis           => v_site.terms_date_basis,
          x_current_catalog_num      => v_site.current_catalog_num,
          x_vat_code                       => v_site.vat_code,
          x_distribution_set_id         => v_site.distribution_set_id,
          x_accts_pay_ccid             => v_site.accts_pay_code_combination_id,
          x_future_dated_payment_ccid         => v_site.future_dated_payment_ccid,
          x_prepay_code_combination_id        => v_site.prepay_code_combination_id,
          x_pay_group_lookup_code             => v_site.pay_group_lookup_code,
          x_payment_priority                  => v_site.payment_priority,
          x_terms_id                          => v_site.terms_id,
          x_invoice_amount_limit              => v_site.invoice_amount_limit,
          x_pay_date_basis_lookup_code        => v_site.pay_date_basis_lookup_code,
          x_always_take_disc_flag             => v_site.always_take_disc_flag,
          x_invoice_currency_code             => v_site.invoice_currency_code,
          x_payment_currency_code             => v_site.payment_currency_code,
          x_hold_all_payments_flag            => v_site.hold_all_payments_flag,
          x_hold_future_payments_flag         => v_site.hold_future_payments_flag,
          x_hold_reason                       => v_site.hold_reason,
          x_hold_unmatched_invoices_flag      => v_site.hold_unmatched_invoices_flag,
          x_match_option                      => v_site.match_option,
          x_create_debit_memo_flag            => v_site.create_debit_memo_flag,
          x_exclusive_payment_flag            => v_site.exclusive_payment_flag,
          x_tax_reporting_site_flag           => v_site.tax_reporting_site_flag,
          x_attribute_category                => v_site.attribute_category,
          x_attribute1                        => v_site.attribute1,
          x_attribute2                        => v_site.attribute2,
          x_attribute3                        => v_site.attribute3,
          x_attribute4                        => v_site.attribute4,
          x_attribute5                        => v_site.attribute5,
          x_attribute6                        => v_site.attribute6,
          x_attribute7                        => v_site.attribute7,
          x_attribute8                        => v_site.attribute8,
          x_attribute9                        => v_site.attribute9,
          x_attribute10                       => v_site.attribute10,
          x_attribute11                       => v_site.attribute11,
          x_attribute12                       => v_site.attribute12,
          x_attribute13                       => v_site.attribute13,
          x_attribute14                       => v_site.attribute14,
          x_attribute15                       => v_site.attribute15,
          x_validation_number                 => v_site.validation_number,
          x_exclude_freight_from_disc         => v_site.exclude_freight_from_discount,
          x_vat_registration_num              => v_site.vat_registration_num,
          x_offset_tax_flag                   => v_site.offset_tax_flag,
          x_check_digits                      => v_site.check_digits,
          x_bank_number                       => v_site.bank_number,
          x_address_line4                     => v_site.address_line4,
          x_county                            => v_site.county,
          x_address_style                     => v_site.address_style,
          x_language                          => v_site.LANGUAGE,
          x_allow_awt_flag                    => v_site.allow_awt_flag,
          x_awt_group_id                      => v_site.awt_group_id,
          x_pay_on_code                       => v_site.pay_on_code,
          x_default_pay_site_id               => v_site.default_pay_site_id,
          x_pay_on_receipt_summary_code       => v_site.pay_on_receipt_summary_code,
          x_bank_branch_type                  => v_site.bank_branch_type,
          x_edi_id_number                     => v_site.edi_id_number,
          x_edi_payment_method                => v_site.edi_payment_method,
          x_edi_payment_format                => v_site.edi_payment_format,
          x_edi_remittance_method             => v_site.edi_remittance_method,
          x_edi_remittance_instruction        => v_site.edi_remittance_instruction,
          x_edi_transaction_handling          => v_site.edi_transaction_handling,
          x_auto_tax_calc_flag                => v_site.auto_tax_calc_flag,
          x_auto_tax_calc_override            => v_site.auto_tax_calc_override,
          x_amount_includes_tax_flag          => v_site.amount_includes_tax_flag,
          x_ap_tax_rounding_rule              => v_site.ap_tax_rounding_rule,
          x_vendor_site_code_alt              => v_site.vendor_site_code_alt,
          x_address_lines_alt                 => v_site.address_lines_alt,
          x_global_attribute_category         => v_site.global_attribute_category,
          x_global_attribute1                 => v_site.global_attribute1,
          x_global_attribute2                 => v_site.global_attribute2,
          x_global_attribute3                 => v_site.global_attribute3,
          x_global_attribute4                 => v_site.global_attribute4,
          x_global_attribute5                 => v_site.global_attribute5,
          x_global_attribute6                 => v_site.global_attribute6,
          x_global_attribute7                 => v_site.global_attribute7,
          x_global_attribute8                 => v_site.global_attribute8,
          x_global_attribute9                 => v_site.global_attribute9,
          x_global_attribute10                => v_site.global_attribute10,
          x_global_attribute11                => v_site.global_attribute11,
          x_global_attribute12                => v_site.global_attribute12,
          x_global_attribute13                => v_site.global_attribute13,
          x_global_attribute14                => v_site.global_attribute14,
          x_global_attribute15                => v_site.global_attribute15,
          x_global_attribute16                => v_site.global_attribute16,
          x_global_attribute17                => v_site.global_attribute17,
          x_global_attribute18                => v_site.global_attribute18,
          x_global_attribute19                => v_site.global_attribute19,
          x_global_attribute20                => v_site.global_attribute20,
          x_bank_charge_bearer                => v_site.bank_charge_bearer,
          x_ece_tp_location_code              => v_site.ece_tp_location_code,
          x_pcard_site_flag                   => v_site.pcard_site_flag,
          x_country_of_origin_code            => v_site.country_of_origin_code,
          x_calling_sequence                  => NULL,
          x_shipping_location_id              => NULL,
          x_supplier_notif_method             => v_site.supplier_notif_method,
          x_email_address                     => 'anilmca02@gmail.com',
          x_remittance_email                  => v_site.remittance_email,
          x_primary_pay_site_flag             => v_site.primary_pay_site_flag,
          x_shipping_control                  => v_site.shipping_control,
          x_gapless_inv_num_flag              => v_site.gapless_inv_num_flag,
          x_selling_company_identifier        => v_site.selling_company_identifier,
          x_duns_number                       => v_site.duns_number,
          x_tolerance_id                      => v_site.tolerance_id
         );
   END LOOP;
   COMMIT;
END;