My Oracle Support Banner

Column PAL_CUR_IND available in PMT_ALLOCATIONS table, not available in X_PMT_ALLOCATIONS. (Doc ID 2802411.1)

Last updated on AUGUST 28, 2021

Applies to:

Oracle Financial Services Lending and Leasing Cloud Service - Version 14.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Column PAL_CUR_IND available in PMT_ALLOCATIONS table, not available in X_PMT_ALLOCATIONS.

Due to this Account Delete API is fails with error.

Error Stack from alert log.

07/26/2021 16:57:10 SessionID=13706593 AppUser=UNDEFINED OSUser=oracle
 
ERROR
-----------------------
  OFSLL Error Msg :
  Ora Error Code : 904
  Ora Error Msg : ORA-00904: "PAL_CUR_IND": invalid identifier
  Context : Error in ORA-00904: "PAL_CUR_IND": invalid identifier : purcmn_el_100_01.copy_table Table = PAL_BVW
  Context : Error in : padprc_en_100_01.copy_delete
  Context : Error in : padprc_en_100_01.pdaprc_em_100_01
  Context : Error in : pdaprc_ew_100_01.pdaprc_ew_100_01
  Context : Error in : xcsdac_ew_100_01.xcsdac_ew_100_01

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute Account Delete API
2. Check whether the API processed successfully

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.