Issue compiling form which referencing object via DB link using Forms Builder 12.2.1.19.0
Hi!
I am facing an issue trying to compile a form which referencing object via DB link using Forms Builder 12.2.1.19.0.
I am getting the same error trying to compile a form both on local Forms Builder or using
frmcmp_batch.sh script on Linux server using its 12.2.1.19.0 Middleware home.
Both source and target DBs are 19.24.0.0.0 having remote_dependencies_mode = SIGNATURE.
Forms alert says: "PDE-PSD001 : Could Not Find Reference To <Unknown program unit> While Loading Procedure body …" followed by hint messages Error 0 and ORA-02201 sequence not allowed here, and error 907 cannot load library…
In fact, I am referencing a table via DB link and I am able to access and query it using both SQL Plus from 12.2.1.19.0 Middleware installation, as well as SQL Developer.