Inline External Tables
Overview Inline external tables enable the run time definition of an external table to be part of a SQL statement, thus eliminating the need to create an external table as…
Read MoreLoading CSV Files from External Tables
Overview This topic provides examples of how to load CSV files from external tables under various conditions. Some of the examples build on previous examples. Technologies and Tools Used The…
Read More19C LISTAGG DISTINCT
Overview The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows for each group in a query according to…
Read MoreOracle Analytical Functions
The easiest way to understand analytic functions is to start by looking at aggregate functions. An aggregate function aggregates data from several rows into a single result row. The aggregate…
Read MoreBreak Comma Separated String
1. Overview This document will be helpful to print comma separated string with the new line report 2. Technologies and Tools Used Oracle Plsql code. 3. Use Case To display comma separated…
Read MoreGet working days between two working date excluding weekends
This function which will help you to get number of working days between two date excluding the weekends. This will help other to get logic between two working date.This is…
Read Moreoracle unpivot function
The Oracle UNPIVOT clause allows you to transpose columns to rows. The UNPIVOT clause is opposite to the PIVOT clause except that it does not de-aggregate data during the transposing process. It’s Very helpful when you…
Read MoreORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError – ecx_utils.INITIALIZE
When trying to submit one of GL report end with error. The error message shows ORA-29532: Java call terminated by uncaught Java exception. select * from ************_LOV ORA–29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException 29532. 00000…
Read MoreOracle R12 Query To Find Customer Notes
SELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_date, jnb.note_type note_type, fls.meaning note_type_meaning, jnt.notes notes FROM apps.hz_cust_accounts hca, apps.jtf_notes_b jnb, apps.jtf_notes_tl jnt, apps.fnd_lookups…
Read MoreOracle R12 GL To AR Transaction Details
SELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, gcck.segment7 subaccount, gcck.segment8 future1, gcck.segment9 future2, rctld.gl_date, gjb.name batch_name, gjh.name journal_name, ( SELECT user_je_category_name FROM…
Read More