Error In The Value Sets: IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM

(Doc ID 2417308.1)

Last updated on JUNE 29, 2018

Applies to:

Oracle Payables - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

In 12.2.7, there is an error in the value sets: IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM.

Navigation:

System Administrator > Application > Validation > Set
Search for IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM
(B) Edit Information > (B) Test > Error

Error:

Test of value set IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM failed with following error message :
ORA-00904: "INS"."PAYMENT_INSTRUCTION_ID": invalid identifier
select PAYMENT_INSTRUCTION_ID VALUE , PAYMENT_INSTRUCTION_ID, pay_admin_assigned_ref_code "Reference Assigned by Admin" , creation_date "Creation Date" from IBY_PAY_INSTRUCTIONS_ALL , CE_SECURITY_PROFILES_V CE_SP, IBY_PROCESS_ORGS PO where PAYMENT_INSTRUCTION_STATUS NOT IN ('CREATION_ERROR', 'RETRY_CREATION', 'TERMINATED') AND INS.PAYMENT_INSTRUCTION_ID = PO.OBJECT_ID AND PO.OBJECT_TYPE = 'PAYMENT_INSTRUCTION' AND CE_SP.ORGANIZATION_TYPE = PO.ORG_TYPE AND CE_SP.ORGANIZATION_ID = PO.ORG_ID AND PAYMENT_INSTRUCTION_ID >= FND_NUMBER.CANONICAL_TO_NUMBER('0') ORDER BY PAYMENT_INSTRUCTION_ID

The problem is the alias "INS." in use in the where sentence and not declare/use in the from sentence and the rest of the querry.
This LOV is use by the concurrent program: Payment Instruction Register and we need this concurrent to work.

Changes

 Upgrade to $Header: ibycpprg.ldt 120.81.12020000.14

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms