APEX sidestep - inconventient "Warn on Unsaved Changes"Some of my Oracle APEX pages give me a "Warn on unsaved changes" even though the user has not touched any items yet. To determine which of the items APEX believe have been touched you can execute beloAug 26, 2026
Oracle EBS R12 Concurrent program "Journal Import" exceptionsUsually the concurrent program “Journal Import“ runs without any problems. Once in a while the program ends in a warning. Checking the output file gives you some information but usually it doesnt give you the whole GL-key. To solve these issues you d...Jan 14, 2025·10
Exploring EBS customizations and translations with JDR_UTILSIn developing customizations and translations Ebs’s JDR_UTILS package has been invaluable. It provides backend solutions to … listCustomizations (see what was customized) printDocument (analyze document structure, applicable to both documents and c...Nov 11, 2024·50
XML Gateway outgoing messagesselect (delivery_timestamp - generation_timestamp) * 24 * 60 generate_to_deliver_minutes, generation_timestamp, case generation_status when '1' then 'Error' when '0' then 'Ok' else generation...May 30, 2024·2
Flagged FilesOracle EBS has a feature to flag files that you have customized. This feature is aptly named "Flagged Files". You can flag these files in EBS itself starting at the System Administrator responsibility: System Administrator -> Oracle Applications Mana...Apr 29, 2024·1
Concurrent request output filesWhen you work with EBS software you are bound to come across concurrent programs and concurrent requests. Concurrent requests are administered in the table "FND_CONCURRENT_REQUESTS". This table contains columns named "OFILE_SIZE" and "OUTFILE_NAME". ...Apr 24, 2024·18
PL/SQL Apps init and developmentWhile developing, once in a while, you want to execute some SQL or PL/SQL within the context of an EBS session. To be able to do that, I created a script to easily generate some initialization code for handling this issue. Beware, the script below as...Apr 22, 2024·5
