In today’s fast-evolving business landscape, staying ahead requires agility, collaboration, and a relentless focus on customer needs. Oracle’s Cloud ERP business exemplifies how open innovation can be a transformative force, driving faster time to market, […]
What is significance of Employee Job role in Oracle Cloud: Should you assign Employee Job role to all of your employees? what is licensing implication? You can assign Employee Job role to all employees if: […]
Useful Tables: ASE_PRIV_ROLE_MBR PM ASE_ROLE_TL RL ASE_ROLE_B R ASE_PRIVILEGE_VL PL PER_USERS UA PER_USERS UB ASE_ROLE_TYPE_VL RT fusion.PER_USERS fusion.PER_USER_ROLES fusion.PER_ROLES_DN_VL fusion.PER_USER_ROLES fusion.PER_ROLES_DN_VL fusion.FUN_USER_ROLE_DATA Table FUN_USER_ROLE_DATA_ASGNMNTS is used for “Manage data access for users”. it will store […]
Q: How to view ESS Jobs Submitted by other users? Ans: Assign “ESS Monitor Role” to user, then user will be able to see all jobs submitted by other users. After assigning XXX ESS Monitor […]
The “ERP Integration Service” and “Financial Utilities Service” are utility web services that provide external web service operations for automatically performing different tasks. Such as: a) Managing data files for import b) Launching Enterprise Scheduling […]
Implementation User Creation, Roles and Privileges Implementation User Creation Reset User Password Implementation User Creation Implementation user can be created from Security Console. To give required privileges to user we have to assign following 3 […]
AR Transaction to SLA Link R12 Important columns in the RA_CUST_TRX_LINE_GL_DIST table include: CUST_TRX_LINE_GL_DIST_ID column CODE_COMBINATION_ID column CUSTOMER_TRX_LINE_ID column ACCOUNT_CLASS column AMOUNT column The RA_CUST_TRX_LINE_GL_DIST table stores the accounting distribution for invoice, debit memo, and […]
AR Adjustments to SLA Link R12 Accounting Data Model – Adjustments •Where postable <> ‘N’ •Status should be ‘A’ •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=ADJ) •Debit & credit amounts should match •Adjustments Status = ‘W’ (Waiting […]
Transactions with Credit Applied and SLA Link R12 Accounting Data Model – Transaction With Credit Applied •Where postable <> ‘N’ •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=RA) •Debit and credit amounts should match •Amount prorated for each […]
AR Receipts to SLA Link R12 Accounting Data Model – Receipts •Where POSTABLE_FLAG <> ‘N’ •EVENT_ID should exist •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH and RA) •Debit & credit amounts should match Important columns in the […]
Enterprise Resource Planning and Integrations BlogSpot 