
Punchout debugging xml files
If you need to debug what is happening in a punchout exchance you can generate the xml's involved by enabling "FND: Debug Log Enabled" (AFLOG_ENABLED) for the specific user. Then, after you visited th
A small Oracle APEX intermezzo about apex_string.plist_put. Its kind of a weird set of functions/procedures where keys and values are put in one long apex_t_varchar2. The first key is put in slot 1, the first value is put in slot 2, etc … declare l...

Sometimes you are working on a template for a specific report but that report takes very long to complete. Testing maybe minor changes in the template gets boring very fast that way. Once you have run that long running report on your dev environment ...

Usually 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...

In 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...

select (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...

Oracle 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...