User Status Query – Oracle Fusion
The below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name ...
Query to get list of Data Accesses of users – Oracle Fusion
The below query extracts the list of data accesses given for any user in Oracle Cloud Application ...
Transmission Configuration For Payment Outbound Interface – Oracle Fusion
Transmission Configuration AP payments made in Oracle Could sends payment files to banks to make the real payment to vendors. In such cases, file transfer link has to be enabled between Oracle ...
PGP Key Encryption in AP Payment Outbound Interface
PGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable the security. In this case it will ...
Query to get tax registration at supplier level – Oracle Fusion
The below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party_name supplier_name ,SUP.segment1 ...
Project Expenditures Import Using FBDI – Oracle Fusion
This blog describes the step by step process of Project Expenditures data conversion in Fusion Application using File Based Data Import. FBDI Template: ...
Customer Site Usage Import Error Query – FBDI Oracle Fusion
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 ...
Customer Site Import Error Query – FBDI Oracle Fusion
The 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 ...
Customer Contact Points Import Error Query – FBDI Oracle Fusion
The 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 ...
Customer Account Import Error Query – FBDI
The 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 ...
