Interactive Grid Toolbar Customization Part 1
Overview Interactive Grid (IG) allows a great deal of customization to its toolbar and menus. The toolbar is implemented by a new toolbar widget. Like most widgets, the toolbar…
Read MoreSQL Query to Extract the Corporate Card Inter-Company Accounting Details in Oracle APPS R12
SQL Query to Extract the Corporate Card Inter-Company Accounting Details in Oracle APPS R12 Introduction This script will help to extract the complete Corporate Card Inter-Company Accounting Details in Oracle…
Read MoreUser 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 EMPLOYEE_FIRST_NAME ,ppn.last_name EMPLOYEE_LAST_NAME ,DECODE(SUSPENDED,'Y', 'Inactive User','N', 'Active…
Read MoreQuery 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 ————————————————–***************——————————————– SELECT gl.name "Security Context Value", pr.role_name"Job Role Name", pu.username "User Name", role.ACTIVE_FLAG…
Read MoreTransmission 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…
Read MoreSteps to start admin server on patch file system in r12.2
To start admin server on patch environment forcepatchfs option should be used as below. Source environment $. /data01/fs1/EBSapps/appl/APPS_Jay1.env cd $ADMIN_SCRIPTS_HOME [applmgr@mercury scripts]$ sh adadminsrvctl.sh start forcepatchfs You are running adadminsrvctl.sh…
Read MoreScript to find the customer contact roles
Introduction This script will used to identify the customer contact roles SELECT DISTINCT Batch_Identifier, NULL interface_row_id, NULL import_status_code, ‘I’ Insert_Update_Indicator, hcar.ORIG_SYSTEM_REFERENCE Contact_Role_Orig_Sys_Ref, hoc.ORIG_SYSTEM_REFERENCE||’-‘||’REL’ Rel_Src_Sys_Ref, hcar.role_type, NULL Role_Level, NULL Primary_Role, NULL…
Read MoreScript to find the customer contact points
Introduction This script will used to find the customer contact points. SELECT DECODE(cont_point.contact_point_purpose,’DUNNING’,cont_point.ORIG_SYSTEM_REFERENCE||’-DUN’,’COLLECTIONS’,cont_point. ORIG_SYSTEM_REFERENCE||’-COLL’,’BUSINESS’,cont_point.ORIG_SYSTEM_REFERENCE||’-BUSS’,cont_point.ORIG_SYSTEM_REFERENCE) Cnct_Point_Orig_Sys_Ref, hpsub.ORIG_SYSTEM_REFERENCE Party_Orig_Sys_Ref, hpobj.ORIG_SYSTEM_REFERENCE Party_Site_Orig_Sys_Ref, cont_point.Primary_flag, ‘I’ Insert_Update_Indicator, cont_point.contact_point_type, cont_point.contact_point_purpose, DECODE(cont_point.email_address,’x’,NULL,cont_point.email_address)email_address, cont_point.email_format, cont_point.phone_area_code, cont_point.phone_country_code, cont_point.phone_extension, cont_point.phone_line_type,…
Read MorePCITI Annual Award Celebration at Doyensys, 2020-2021
PCITI Annual Award Celebration at Doyensys recognizes employees who demonstrate exemplary behavior of our values. Doyensys stands by its core values that have helped us reach this stage where we…
Read MoreAR: Use Invoice Accounting for Credit Memos profile option is set to Yes
Introduction: You can’t provide an account assignment for credit memo transactions when the AR: Use Invoice Accounting for Credit Memos profile option is set to Yes. Cause: RA_INTERFACE_DISTRIBUTIONS_ALL tab should…
Read More