Oracle Application Blog

Using Source Code Control in Oracle SQL Developer

Overview Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Using Oracle SQL Developer, you can browse database objects, run SQL statements, edit…

External Table

  External tables allow Oracle to query data that is stored outside the database in flat files. The ORACLE_LOADER driver can be used to access any data stored in any…

In-Database Archiving

In-Database Archiving Oracle Database 12c introduces In-Database Archiving to archive the low priority data in a table. The inactive data remains in the database but is not visible to the application.…

BI Publisher Advanced RTF Template Techniques Images, Charts and Graphs

Images and Charts  Oracle BI Publisher supports several methods of including images or charts in an Oracle BI Publisher report. •       Direct insertion •       URL reference •       OA_MEDIA directory reference…

Customer PO Conversion

Customer PO Conversion Description             This blog is used to create a Customer PO conversion. This blog will invoke the API OE_BLANKET_PUB.process_blanket and it processes the header and line level…

Query for Approval groups

SELECT pcr.control_rule_id, pcga.control_group_name, pcr.object_code,        pcr.rule_type_code, pcr.amount_limit,        (   segment1_low         || ‘.’         || segment2_low      …

Query for Approval Assignments

SELECT hou.NAME operating_unit, pj.NAME job, pcf.control_function_name,        pcga.control_group_name,        TO_CHAR (ppca.start_date, ‘DD-MON-YY’) start_date,        TO_CHAR (ppca.end_date, ‘DD-MON-YY’) end_date   FROM apps.po_position_controls_all ppca,    …

How to rectify FUN_INTER_PAY_NOT_VALID error in create accounting

During month close an error with invoices/receipts/transactions   “FUN_INTER_PAY_NOT_VALID”  is a blocker for the close. When this error occurs for AR, follow below steps to identify and fix this issue. Step…

Query to find list of suppliers who has attachments

Often times you might have to find a list of suppliers who has a specific attachment. For example, if you need to find list of suppliers who has attached with…

We are hiring "Oracle Apps DBA"