EBS

Oracle R12 SQL Query – Price List or Fee Schedule for Customer

select HP.PARTY_NAME “Customer Name”,HCAA.ACCOUNT_NUMBER,HCAA.ACCOUNT_NAME,qph.name “Price List Name”,HCSUA.SITE_USE_CODE,HCSUA.LOCATION from qp_list_headers qph,APPS.HZ_CUST_ACCOUNTS_ALL HCAA,APPS.HZ_CUST_ACCT_SITES_ALL HCASA,APPS.HZ_CUST_SITE_USES_ALL HCSUA,APPS.HZ_PARTIES HPWhere hcaa.account_number = –Customer Account Numberand HCAA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_IDand HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_IDAND HCSUA.PRICE_LIST_ID = QPH.LIST_HEADER_IDAND HCAA.PARTY_ID=HP.PARTY_ID

Read More

Purchase Invoice GL to AP Drill down for Account Analysis Reconciliation

Introduction: This document outlines how to reconcile Oracle General Ledger (GL) and Oracle Payables (AP) for Purchase Invoice analysis by using a specific SQL script to drill down to the…

Read More

AP: Create Accounting Completed In Warning with Offsets Error

Issue Overview: The error “The accounting program cannot create this journal line because the debit or credit that offsets it cannot be found” occurs when attempting to run the Create…

Read More

Delete the concurrent programs

Delete the concurrent programs    Prerequisites: If the concurrent program is not in use, the program details need to be entered in the lookup and then this concurrent program needs…

Read More

Multi-Node EBS with DMZ Setup

Many of you have asked about the best storage options for a multi-node EBS setup involving a DMZ server with a public load balancer. Here are some insights and best…

Read More

Resolving ORA-20001: Synonym Does Not Point to an Editioning View in ADOP Phase of Oracle EBS

Introduction  During the ADOP (Online Patching) process of Oracle E-Business Suite (EBS), you might encounter the following error message while running Autoconfig as part of adop phase=prepare: ORA-20001: Synonym does…

Read More

Resolving Port Conflicts During ADOP Validation in Oracle E-Business Suite

Introduction: The ADOP (Autonomous Database Operations) process is a crucial component of the Oracle E-Business Suite (EBS) used during patching, cloning, and upgrades. During the validation phase of ADOP, a series of…

Read More

oacore_server1- failed to startup with javax.naming.NameNotFoundException Error

DESCRIPTION: Getting oacore_server1- failed to startup Error when starting EBS R12.2.5 after clone. CAUSES: oaea_server1 is not registered in cloned Weblogic console. SOLUTION: Add the datasource of oaea_server1 in Weblogic…

Read More

Removing node name in EBS R12.2

DESCRIPTION: After EBS Test Clone EBS Prod URL Redirecting to EBS Test URL. CAUSES: EBSTEST Node Name is Added into EBS PROD’s Node table. SOLUTION: Remove the EBSTEST Node name…

Read More

View Output/Log returns “Authentication Failed/File server could not identify source file ” error Concurrent Program – R12.1.3

In Oracle E-Business Suite R12.1.3, when you try to view a report output/log, the following two errors are displayed: File server could not identify source file. or Authentication failed. In…

Read More