4.6.4 Uploading Excel for Adjustment Entry Posting

You can post the adjustment entry by selecting the excel sheet and uploading it into Contract adjustment upload table using Contract Adjustment Upload screen.

Specify the User ID and Password, and login to Homepage.

1. On the homepage, type OLDXLUPD and click next arrow.
   The Contract Adjustment Upload screen is displayed.

   Figure 4-17 Contract Adjustment Upload

   
   

   
   Description of "Figure 4-17 Contract Adjustment Upload"

   
   
2. XL File to be uploaded - Choose the Excel File to be uploaded into Oracle Lending.
   On save the system uploads the excel sheet and validates the data uploaded from the excel sheet. On upload the system displays the message.

   Upload Successful

   On authorize, the system processes the data and triggers the corresponding event 'CADJ' and accounting entries for the validated records.

   The following fields are displayed.

   • Batch Number
   • Book Date
   • Total Number of Records in XL
   • Number of Records in Error
   • Contract Reference Number
   • CUSIP No
   • Firm Acct Mnemonic
   • Adjustment Value Date
   • Adjustment Amount
   • Dr GL Account
   • Cr GL Account
   • Status Description
   • Currency
   • Expense code of the contract
   • Debit Account Branch
   • Credit Account Branch
   • Adjustment Type
   • Recon ID
   • Instrument Number
   • Component
   • Remarks
   • Reversal

   Exceptions

   In case of any validation error and processing error, the system marks the entry status as an error and displays the error reason in this field.

   When you save the adjustment entries, the system displays a message with the following details:

   • The number of entries that have been validated.
   • The number of validation errors

   When you authorize the adjustment entries, the system displays a message with the following details:

   • The number of entries that have been uploaded.
   • The number of failed errors

   Using this screen, you can also post the adjustment entries for agency (LS) participant contracts and trading (SLT) position contracts.