JPMA Seiyakukyo Line Listing Issue on AS 8.4.1
(Doc ID 2973924.1)
Last updated on DECEMBER 29, 2023
Applies to:
Oracle Life Sciences Argus Safety Japan - Version 8.4.1 to 8.4.1 [Release 8.4]Information in this document applies to any platform.
Symptoms
On version 8.4.1, Generated JPMA Seiyakukyo line listing (SLL) which has the advanced condition.
However, the case with the data does not populate due to ORA-00904 Invalid Identifier errors.
Steps:
1. Go to Reports > Periodic reports > SLL
2. Create a new report template with the advanced condition
3. Generate the report
Errors :
(The following errors are populated in Utilities > Logs > View error log and the cmn_error_log table)
AGProc.exe
PKG_PSR.P_GET_SKUKYO_L_DATA :- ERROR FOUND FOR REPORT_FORM_ID = ### ORA-00904: "S3"."CASE_XREF": invalid identifier
PL/SQL Call Stack:
278126794872815296
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
8443 PKG_PSR.P_GET_SKUKYO_L_DATA
1 __anonymous_block
PKG_PSR.P_GET_SKUKYO_FRGN_L_DATA :- ERROR FOUND FOR REPORT_FORM_ID = ### ORA-00904: "CM"."CASE_ID": invalid identifier
PL/SQL Call Stack:
10906631214751521432
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
9002 PKG_PSR.P_GET_SKUKYO_FRGN_L_DATA
1 __anonymous_block
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 |
| References |