The 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 MoreThis blog describes the step by step process of Supplier Contacts migration in Fusion Application using File Based Data Import. Using this process we can create Contact of Suppliers and…
Read MoreThis Query is useful to fetch the vendor details that are having certificates for lower Tax Deduction rates or Exceptional Tax Deduction case vendors. Script: SELECT vendor_name, pan_no, org_tan_num,…
Read More