AIM: Component is used for Create the Requisition against the Blanket Purchase Agreement For different Locations. SCRIPT: CREATE OR REPLACE PACKAGE BODY APPS.XXTTK_BPO_PKG IS PROCEDURE XXTTK_REQ ( ERRORBUF OUT VARCHAR2…
Read MoreDECLARE paslrec po_approved_supplier_list_rec; paarec po_asl_attributes_rec; padrec po_asl_documents_rec; chvrec chv_authorizations_rec; psicrec po_supplier_item_capacity_rec; psitrec po_supplier_item_tolerance_rec; x_errors po_asl_api_error_rec; x_session_key NUMBER; x_return_status VARCHAR2 (30); x_return_msg VARCHAR2 (2000); BEGIN — Populating values in paslrec paslrec…
Read MoreAPPLIES TO: Oracle Applications Manager – Version 12.2 to 12.2 [Release 12.2Cloud] Information in this document applies to any platform. SYMPTOMS: Trying to install 12.2 E-Business Suite on Linux and…
Read MoreAPPLIES TO: Oracle Applications Manager – Version 12.0 to 12.0.4 [Release 12] Information in this document applies to any platform. This problem can occur on any platform. SYMPTOMS: Error running…
Read MoreIssue: SSO is unable to establish a connection to EBS as the APPS password is wrongly updated. —— Error: ——- [2015-11-25T11:45:23.966-05:00] [wls_ods2] [ERROR] [DIP-20050] [oracle.dip.prodapp_calif_I] [tid: prodapp_calif_I] [userId: <anonymous>] [ecid:…
Read MoreYou can retry all errored activities for the specific item type, or you can choose to retry only activities for a particular work item of that item type, activities for…
Read MoreCAUSE : ———- Incorrect data is present in the OPP queue table AQ$FND_CP_GSM_OPP_AQTBL_S, which occurs when the concurrent managers are not shutdown correctly. A quick sql query shows orphaned OPP…
Read Moreset linesize 300; set pagesize 1000; spool rac_redo_switch_rate.log set heading off; select ‘******************************************************’ from dual; select ‘**** Redolog Switch Rate by Date and Hour ****’ from dual; select ‘******************************************************’ from…
Read MoreIssue: —— In an EBS-SSO integrated environment – The user Account is active in EBS and the SSO account is provisioned, but still unable to authenticate from the EBS-OAM login…
Read MoreCheck the status of WF Mailer : ———————————– SQL> select component_status from apps.fnd_svc_components where component_id = (select component_id from apps.fnd_svc_components where component_name = ‘Workflow Notification Mailer’); Find the Failed/Errored Notifications…
Read More