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 MoreTitle: Supplier Master Data Import – FBDI Template In this post , We will discuss about Supplier import in oracle fusion. Oracle has provided the FBDI tool to import suppliers…
Read MoreDescription: Trace File Analyzer Collector also known as TFA is a diagnostic collection utility which greatly simplifies the diagnostic data collection for both Oracle Database as well as Oracle Clusterware/Grid Infrastructure RAC environments.Trace…
Read MoreOrder To Cash Script o2c SELECT hp.party_name customer, hca.account_number, hp.party_number, ooh.order_number, ooh.flow_status_code order_status, rcta.trx_date invoice_date, rcta.trx_number invoice_number, rcta.status_trx invoice_status, rcta.invoice_currency_code invoice_currency, rctla.line_number, msi.segment1 item_number, rctla.description, rctla.extended_amount line_amt, arp.amount_due_original, arp.amount_due_remaining,…
Read MoreWhen 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 MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.3 and later GOAL: This note helps in how to use multiple cache size for tablespaces with different block size i.e…
Read MoreAPPLIES TO: Oracle Applications DBA - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2] SYMPTOMS: Autoconfig failed in application tier node after upgrading database to 19c on setting s_applptmp context…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later SYMPTOMS: Database Names: UAT RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171 : $ rman auxiliary /…
Read More