/* Query to Get Supplier Tax Payer ID */ select HP.PARTY_NAME VENDOR_NAME, PS.SEGMENT1 VENDOR_NUMBER, PSP.ORGANIZATION_TYPE, PSP.INCOME_TAX_ID, PSP.VAT_REGISTRATION_NUM, PSP.CREATED_BY, PSP.CREATION_DATE from POZ_SUPPLIERS_PII PSP, POZ_SUPPLIERS PS, HZ_PARTIES HP where PSP.VENDOR_ID=PS.VENDOR_ID and PS.PARTY_ID=HP.PARTY_ID
Configure Implementation and Employee User in Oracle Fusion
For any Oracle Fusion implementation project, we usually create two types of users: Let us check in details regarding each type of user and how to create these users: 1.Implementation User: Implementation users are those users who are implementing system. These are IT consultants who are working on implementation. These users are not actual employee […]
How to Restrict User for running ESS Job
In this section, we will see how to restrict ESS job to specific user. Let us create simple BIP report and ESS job based on BIP report. Follow steps mentioned in this below blog post to create Simple BIP report and ESS Job. Creating Simple BIP report in Oracle Cloud ERP Creating Custom ESS Jobs […]
Import Data Access for Users in Oracle Cloud ERP using ADFDI
In this section, we will check how to import and export data access for Users in bulk. We can import data access for users in bulk using ADFDI. Navigate to Setup and Maintenance —>Global Search—> Manage Data Access for users. Go to “Users with Data Access” as shown above. Provide Username and Role for which […]
Overview of Security Console in Oracle Fusion
Oracle Fusion Security Console: The Oracle Fusion Applications Security Console is an easy-to-use administrative work area where you perform most security-management tasks. This topic introduces the Security Console and describes how to access it Navigation to access Security Console is as below: Tools—> Security Console Click on Security Console Security Console consists of different […]
How to resolve-Unable to See Data Set Access and Ledger Name for Import Journal Program
Issue Description: While submitting Import Journal program, we face issue that we are not able to see Data access set and Ledger Name in parameter Lov as shown below: Solution: This issue is related to roles and data access required to run the Import Journal Program. Below roles and respective data access need to provide […]
How to bulk import Lookup Types and Lookup Codes in Oracle Fusion
In this article, we will try to create custom lookup type and lookup values using bulk import functionality in Oracle fusion. We can create Lookup Type and respective lookup values by creating two separate files. Files should have pipe (|) as delimiter and should be of UTF-8 encoding. Part-1: – Create Lookup Type For creating […]
How to Restrict User for running ESS Job
In this section, we will see how to restrict ESS job to specific user. Let us create simple BIP report and ESS job based on BIP report. Follow steps mentioned in this below blog post to create Simple BIP report and ESS Job. We have created below ESS Job as: When we create ESS Job […]