Issue: —— 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 MoreThe below query extracts the error details along with interface attributes of Customer Site Usages import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,site_use.* FROM hz_imp_errors…
Read MoreThe below query extracts the error details along with interface attributes of Customer Sites import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,site.* FROM hz_imp_errors err…
Read MoreThe below query extracts the error details along with interface attributes of Customer Contact Points import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,cpt.* FROM hz_imp_errors…
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 MoreThe below query extracts the error details along with interface attributes of Customer Account import using FBDI in Fusion Applications. SELECT distinct err.message_name ERROR_MESSAGE ,msg.message_text MESSAGE_TEXT ,acc.* FROM hz_imp_errors err…
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 MoreThis blog contains sample payload to upload an image file in AR invoice attachments in Oracle Fusion Applications. During fusion implementation, we might come across a client requirement to upload…
Read More