How to add custom/fields PO XML generation
In this blog, We will see how can we add the custom XML segments/fields that can be extended in PO XML output. PO_CUSTOM_XMLGEN_PKG package is the place where the business…
Read MorePO XML Views in Oracle
In Oracle Purchasing, The PO Output for Communication program is responsible for sending the PO copies to vendors with respect to the communication details captured. During the call of this…
Read MoreRecurring GL Journals extract query
In Oracle Financials, We have a provision to create a recurring journal in GL application. This blog will helping in extracting that journals. SELECT b.name batch, b.description batch_description, ( SELECT…
Read MoreAME Rule changes audit queries
In Oracle E-Biz applications Approvals Management Engine(AME) is widely used for approvals in Purchasing,HR modules. Especially an audit enabled systems, We need to capture the changes in the real-time systems.…
Read MoreApps listener fails to start on cloned instance with TNS-12533
Apps listener fails to start on cloned R12.1.3 instance with the following error. Cause: This error occurs when a host names in the tcp.invited_nodes list is invalid Solution: Remove invalid…
Read MoreAPP-FND-01542: This Applications Server is not authorized to access this database.
By default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following error would pop out: APP-FND-01542: This Applications Server is…
Read MoreSQL Query to retrieve User Roles – Fusion Applications
Query: SELECT pu.username,prdt.role_id, prdt.role_name, prd.role_common_name FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd WHERE pu.user_id = pur.user_id AND pu.username = <:P_USERNAME> AND prdt.role_id = pur.role_id AND prdt.role_id = prd.role_id…
Read MoreQuery to get Organization detail in Fusion
Overview : Below query to give the organization information in Fusion Query: SELECT hra.organization_id as bu_id ,hro.name organization_name ,hra.business_group_id, hro.* FROM HR_ALL_ORGANIZATION_UNITS_F hra, HR_ORGANIZATION_UNITS_F_TL hro WHERE 1=1 hra.ORGANIZATION_ID =…
Read MoreQuery to Extract the IPV Report Data
Introduction This Query will help to Fetch the IPV Report Data in Oracle Apps. SQL Query: BEGIN fnd_client_info.set_org_context (:p_org); END; SELECT glps.set_of_books_id, msi.organization_id, pov.vendor_id, glps.period_name, api.invoice_num invoice_num, aid.accounting_date invoice_date, DECODE…
Read MoreFRM-92102 Errors when Accessing a Forms Module
When attempting to access E-Business Suite Forms on a cloned E-Business Suite instance the following error occurs: FRM-92102 A network Error has occurred. The Forms Client has attempted to reestablish its…
Read More