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.
In 12.2.7, there is an error in the value sets: IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM.
System Administrator > Application > Validation > Set
Search for IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM
(B) Edit Information > (B) Test > 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.
Upgrade to $Header: ibycpprg.ldt 120.81.12020000.14
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!