1. Trade - Oracle Banking Corporate Lending Integration User Guide
  2. Trade - Oracle Banking Corporate Lending Integration
  3. Integration Process
  4. Loan Creation during Import Bill Liquidation

2.3.1 Loan Creation during Import Bill Liquidation

Import bills are created for products with ‘Advance by Loan’ option selected

Saving Import Bill Liquidation

During liquidation of import bills, partial or full liquidation, details for loan creation will be available in Loan Preference screen. The details should be maintained as below:
  • Loan Amount = Bill liquidation amount minus Cash collateral in Bills, Collateral from LC and available amount in settlement account if 'Liquidate using Collateral' and 'Settle available Amount' flag are checked. If not, then Loan Amount = Liquidation Amount
  • Loan currency = Local currency or Bill Currency
  • Counterparty = Counterparty of the Import Bill
  • Value date = Liquidation date
  • Maturity date = Value Date + Tenor of loan product
  • Interest rate = Defaulted from Loan Product screen
  • Suspense GL = Bridge GL maintained at Import Bill product maintenance. Suspense GL in OBTF and OBCL should be the same
  • Liability number will be defaulted from BC limits. Multiple liabilities attached to that customer will be listed in the LOV. User can modify the same.
BC Limits will be defaulted to Loan Preference and you can modify the same.

Authorizing Import Bill Liquidation

During manual bill liquidation authorization, if the limits are tracked in the bill, then request for limit de-utilization will be posted to ELCM with process status as ‘U’ (in STTB_TF_REQ_MASTER ). If the de-utilization is successful then the process will be ‘P’. Bill authorization can proceed only if de-utilization is successful.

If any dual authorization overrides are logged during save of bill liquidation, then authorization of bill liquidation will fail with error ‘Contract Authorization possible only after authorizing the overrides'. You have to authorize the override manually and then proceed for authorization of bill liquidation.

Request for loan creation and authorization will be posted in intermediate store with the following details:
  • Unique Queue Reference Numbers will be generated.
  • User Id for Loan creation request to be 'SYSTEM'.
  • User Id for loan authorization request to be Bill liquidation authorization user Id. Bill authorization user logged in Queue table will be provided in Loan authorization request.
  • Status of Loan creation request will be based on limit tracking in Bills.
  • If Bill is booked with Limit Tracking, status of loan creation request to be 'Pending'. Once limit de-utilization is successful, status will be changed from 'Pending' to 'Unprocessed.
  • If Bill is booked without Limit Tracking, status of loan creation request to be 'Unprocessed'.
  • Status of Loan authorization request will be ‘Hold’.
If loan processing has failed and the user tries to authorize, the system displays an error message.

If Loan authorization has failed due to rejection of Credit Exception, manual authorization can be initiated again.

Deleting Import Bill Liquidation

If ‘External Loan Request Status’ is ‘Unprocessed’ then you cannot delete the bill. If ‘External Loan Request Status’ is ‘Failed’, then you can delete the bill. On successful Bill deletion entries from staging tables will be moved to History tables.

Parent topic: Integration Process