Table FUN_USER_ROLE_DATA_ASGNMNTS is used for “Manage data access for users”. it will store use and role assignment to data security. Table name – FUN_USER_ROLE_DATA_ASGNMNTS1.user– username to find out from which base table through USER_GUID (FUN_USER_ROLE_DATA_ASGNMNTS)2.role […]
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. Reference: Doc ID: 1467664.1
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 […]
AR Miscellaneous Receipt to SLA Link R12 Accounting Data Model – Miscellaneous Receipts •Where POSTABLE_FLAG <> ‘N’ •EVENT_ID should exist •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH & MCD) •Debit & credit amounts should match Important columns […]
Enterprise Resource Planning and Integrations BlogSpot 