Requisition Creation and Approve process in Fusion Applications
Requisition Creation and Approve Step 1: Login as Application User Step 2: you will be in home page as below Step 3: we need to navigate to Functional Setup Manager,…
Read MoreFunction to format the invoice number in AP
Function to format the invoice number in AP: Please find the below steps for Function to format the invoice number in AP CREATE OR REPLACE FUNCTION XXXX_VALIDATE_INVOICE( p_invoice_number VARCHAR2)…
Read MorePO details reports Using xml element tag-
PO details reports Using xml element tag-: Please find the below steps for PO details reports Using xml element tag: CREATE OR REPLACE PACKAGE BODY po_details_test_pkg as procedure po_details_insert( v_errbuf …
Read MoreAPI to update the supplier
API to update the supplier: Please find the blow steps for API to update the Supplier DECLARE p_api_version NUMBER; p_init_msg_list …
Read MoreAPI to update the customer locations
API to update the customer locations: Please find the below steps for update customer locations /* Formatted on 2/1/2018 6:54:52 PM (QP5 v5.163.1008.3004) */ DECLARE p_location_rec …
Read MoreAPI to update the attribute in AR invoice
API to update the attribute in AR invoice: Please find the below script for update the attribute in AR Invoice: DECLARE CURSOR c_ers_num is select trx_number,interface_header_attribute15 from ra_customer_trx_all where trx_number…
Read MoreHow to Resolve “ORA-29548: Java system class reported” in 12c?
After applying PSU to 12.1.0.2.0, the application gets following error. [Error] Execution (1: 1): ORA-29548: Java system class reported: release of classes.bin in the database does not match that of…
Read MoreEBS R12 Login Page Is Not Coming Up – java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE
Acual Behavior E-Business Suite (EBS) Production Instance Login page is not coming up, Instead a blank page is being displayed. The issue can be reproduced at will with the following…
Read MoreHow to attach ebs 10.1.2 oracle home to central inventory
This post is to define “How to attach ebs 10.1.2 oracle home to central inventory” bash-3.2$ opatch apply Oracle Interim Patch Installer version 1.0.0.0.64 Copyright (c) 2011 Oracle Corporation. All…
Read More