E1: BSFN: Using C API ubeSection_GetDataSelection to Get Report's Data Selection Failed with Error for Some Reports (Doc ID 2222868.1)

Last updated on AUGUST 23, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


Using the C API ubeSection_GetDataSelection in custom business function to get report's Data Selection data values, it works but for some report, it failed with error
"Unable to Find Object ID# - XXXX. Please Run ER Validation to verify Event Rule integrity" on pdf, where XXXX is an object ID.
For example, in customer JD Edwards App 9.0 release it always crashes on R00932, Object ID # 48.
Another example error when try to retrieve Data Selection of R11804
"Unable to find object ID# - 376. Please run ER Validation to verify Event Rule integrity."

Issue happen to JD Edwards App 9.2 as well.

Step to reproduce:-
1. Create a custom bsfn that call API ubeSection_GetDataSelection
2. Call the bsfn from a custom report and pass in section 5, report R11804 to get data selection of section 5 of R11804
3. Run the custom report and see error "Unable to find object ID# - 376. Please run ER Validation to verify Event Rule integrity." printed on the pdf.

Data selection for section 5 of R11804 is
Where BC Payment ID internal F0413 PYID is equal to RV Payment ID (Internal) 414-RP

Object ID 376 is RV Payment ID (Internal) 414-RP in section RP 411 Driver of R11804.

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