Introduction: This Post illustrates the steps required to Fetch the Invoice lines not transferred to GL in Oracle . Sql Script: SELECT rct.trx_number invoice_number, rctl.line_number, msib.segment1, hp.party_name bill_to_customer, DECODE (rctt.TYPE,…
Read MoreIntroduction: This Post illustrates the steps required to On Hand Quantity with Available To Transact in Oracle EBS. Script to Fetch the On Hand Quantity with Available To Transact Step-1…
Read MoreFIND ACL PRIVILEGES ==================== set pages 1000 lines 1000 col acl for a50 col principal for a20 col privilege for a20 col is_grant for a20 col invert for a20 col…
Read MoreIntroduction: This Post illustrates the steps required to fetch data from AR to GL in Oracle EBS 11i. Script SELECT je_header_id, line_number, trx_number, item_number, customer_number, customer_name, SOURCE, CATEGORY, batch_name,…
Read Morecol owner FOR a20 col segment_name FOR a40 SELECT S.owner “Owner”, Nvl(S.segment_name, ‘TABLE TOTAL SIZE’) “Segment_name”, Round(SUM(S.bytes) / 1024 / 1024 / 1024, 1) “Segment_size_GB” FROM dba_segments S WHERE S.segment_name…
Read MoreConsider the following scenarios: Scenario 1: DIP Import Sync from Active Directory (AD) to OID works for most entries, but fails when a new organizationalunit (ou) entry is added in…
Read MoreDuring an in progress ADOP patch session applying AD/TXK patch, users reported issues with login attempts to the E-Business Suite instance. To resolve the login issues, the ADOP patch session was…
Read MoreIssue: Error starting Admin Server When we are starting Admin Server, getting below error sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start logs: $EBS_DOMAIN_HOME/servers/AdminServer/logs/AdminServer.log adadminsrvctl.sh should be run only from the primary node Doyensys Cause: Wrong Entry…
Read MoreWhat is Oracle ADF? Oracle Application Development Framework (Oracle ADF) is an end-to-end application framework that builds on Java EE standards and open-source technologies to simplify and accelerate implementing enterprise…
Read Moreset verify off set feedback off set lines 300 set pages 0 set heading off set space 0 column text format a79 column line noprint select DECODE(line,1,’create or replace ‘,”)||text,…
Read More