ERR-1002 Unable to find item ID

[abrehmanjaffri]

While trying to submit the page having other process as well it gives error in my case

ERR-1002 Unable to find item ID for item "P36_REQUEST_JSON_Subject" in application "118". this item "P36_REQUEST_JSON_Subject" is rendered from json-region

[simonuwe]

This error could occure when somewhere an Javascript-exception occured and so not all the plugin's Javascript-code is executed. One known situation is issue #143.

Could you switch on a full trace and look in the browser console. There you should see the Javascript-exception. Could you send me this exception? May I get your JSON-schema?

[abrehmanjaffri]

Add error onto error stack: ERR-1002 Unable to find item ID for item "P36_REQUEST_JSON_Subject" in application "118".

Error: ERR-1002 Unable to find item ID for item "P36_REQUEST_JSON_Subject" in application "118".

• Additional info: Unexpected error, unable to find item name at application or page level.

• Display location: ON_ERROR_PAGE

• Association type:

• Item name:

• Region id:

• Column alias:

• Row:

• Model instance id:

• Model record id:

• Internal error: true

• Common runtime error: false

• APEX error code: WWV_FLOW.FIND_ITEM_ID_ERR

• SQL code:

• SQL error:

• Backtrace: ----- PL/SQL Call Stack ----- object line object handle number name 0x1cea9dbb0 1028 package body APEX_240100.WWV_FLOW_ERROR.INTERNAL_GET_ERROR 0x1cea9dbb0 1097 package body APEX_240100.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR 0x1cea9dbb0 1581 package body APEX_240100.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR 0x6e4f7af0 3261 package body APEX_240100.WWV_FLOW_META_DATA.FIND_ITEM_BY_NAME 0xbec8c7e0 1398 package body APEX_240100.WWV_FLOW.PARSE_PAGE_ITEMS_JSON_OBJECT 0xbec8c7e0 4016 package body APEX_240100.WWV_FLOW.ACCEPT 0x154514400 2 anonymous block

• Statement:

• Component: APEX_APPLICATION_PAGES ASAS (118000000036)

Exception in "final_exception_handler": Error Stack: ORA-20987: APEX - ERR-1002 Unable to find item ID for item "P36_REQUEST_JSON_Subject" in application "118". - Unexpected error, unable to find item name at application or page level. ORA-06512: at "APEX_240100.WWV_FLOW_ERROR", line 1123 ORA-06512: at "APEX_240100.WWV_FLOW_ERROR", line 1581 ORA-06512: at "APEX_240100.WWV_FLOW_META_DATA", line 3261 ORA-06512: at "APEX_240100.WWV_FLOW", line 1398 Backtrace: ORA-06512: at "APEX_240100.WWV_FLOW_ERROR", line 1123 ORA-06512: at "APEX_240100.WWV_FLOW_ERROR", line 1581 ORA-06512: at "APEX_240100.WWV_FLOW_META_DATA", line 3261 ORA-06512: at "APEX_240100.WWV_FLOW", line 1398 ORA-06512: at "APEX_240100.WWV_FLOW", line 4016

ON FULL TRACE DEBUG

[abrehmanjaffri]

{"type": "object", "required": ["Subject", "Description"],"properties": { "Subject":{ "type": "string" , "apex": { "label": "Subject", "colSpan": 12, "itemtype": "textbox" }}, "Description":{ "type": "string" , "apex": { "label": "Description", "itemtype": "richtext", "colSpan": 12 }}}}

[simonuwe]

JSON-schema works. The "itemtype": "textbox" is ignored.

[simonuwe]

So this loos like a Javascript-exception had occured.

Could you send me the output on the browser console. In Browser Menu Tools->WebdeveloperTools There should be at least one error. Click on error and expand the errors, that it looks like

[abrehmanjaffri]

 modelViewBase.min.js?v=24.1.5:4 Uncaught (in promise) NotSupportedError: Failed to execute 'define' on 'CustomElementRegistry': the name "a-model-cursor" has already been used with this registry at HTMLDocument. (modelViewBase.min.js?v=24.1.5:4:62870) at HTMLDocument.dispatch (desktop_all.min.js?v=24.1.5:5:43125) at v.handle (desktop_all.min.js?v=24.1.5:5:41120) at Object.trigger (desktop_all.min.js?v=24.1.5:5:71782) at HTMLDocument. (desktop_all.min.js?v=24.1.5:5:72378) at Function.each (desktop_all.min.js?v=24.1.5:5:3002) at w.fn.init.each (desktop_all.min.js?v=24.1.5:5:1482) at w.fn.init.trigger (desktop_all.min.js?v=24.1.5:5:72353) at e.trigger (desktop_all.min.js?v=24.1.5:14:133) at apexHacks (json-region.js:238:18) desktop_all.min.js?v=24.1.5:7 Server debug log message written: View Identifier = 1954470, Level = ERROR. https://jamdevapex.al-majid.tech:9503/ords/f?p=4000:939:7339591482656::NO:939:P939_PAGE_VIEW_ID:1954470#

[abrehmanjaffri]

this my jsonn schema now

{"type": "object", "required": ["Subject"],"properties": { "Subject":{ "type": "string" , "apex": { "colSpan": 12, "label": "Subject" }}}} still getting the error

[simonuwe]

You hit the issue #143 (Item Service). This will be fixed in rel-0.9.6, I'm just in the last tests, should be released this night, latest tomorrow.

Workaround: Use a Select list instead of "Popup LOV.

[simonuwe]

Should be fixed now in the new release 0.8.6 #149

[abrehmanjaffri]

yes its working now. Thankyou so much. 👍

[abrehmanjaffri]

it would be great to have a form builder plugin like this https://bpmn.io/toolkit/form-js/ since your plugin will support it rendering.

[nielsdebr]

Is this what you are looking for?

https://flowsforapex.com/ords/preview/r/simple-form-builder/json-sfb/home

[abrehmanjaffri]

@nielsdebr I tried it and it is working great though visually it would be more appealing and convenient for end user to have something like the BPMN form-js.

[abrehmanjaffri]

@nielsdebr I have made some changes on simple form builder thought to share with you. adding more properties to it.

[nielsdebr]

Thx for sharing. I would love to see a visual editor, but it needs financing (or a lot of spare time).

[abrehmanjaffri]

@nielsdebrI understand. I'm collaborating with a team on this, and we're making steady progress.