SELECT “Transaction Type Name”, party_name, party_site_number, “Payment Terms”, gl_date, due_date, total_days, CASE WHEN total_days > 0 THEN amt_due_remaining END “Not Due Amount”, CASE WHEN total_days BETWEEN 1 AND 30 THEN…
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 MoreThis is the table where all the netting agreement would be storing. Script: select agreement_name, agreement_id from apps.fun_net_agreements_all;
Read MoreThis API is used to check the Accounting status of AP invoices. Script: DECODE(apps.AP_INVOICES_PKG.GET_POSTING_STATUS( aia.invoice_id ), ‘P’, ‘Partial’, ‘N’, ‘Unaccounted’, ‘Y’, ‘Accounted’);
Read MoreThis Query is used to extract all the TAX Type that are available in the system, Especially used when Migrating the data and reporting purpose. Script: SELECT ‘GST’ “Tax…
Read More