What is the correct way to insert a record in gl_interface_control table?
Hi there,
Does anyone know if we have a document on how to insert a record in gl_interface_control table? Here is what I try to do:
- I need to have a program to insert records in gl_interface table.
- I need to insert a line in gl_interface_control table as well.
- run journal import.
Here is what I did:
- created a program to insert records in gl_interface table
- at the end of the program, added a section to insert a record in gl_interface_table:
SELECT gl_journal_import_s.NEXTVAL INTO irun_id FROM DUAL;