Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Oracle Fusion Technical

What is significance of Employee Job role in Oracle Cloud? and should you assign it to all employees? what is licensing implication?

  • by Yogesh Pachpute
  • Posted on January 15, 2023January 24, 2023
  • GRC

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: […]

Read More

Useful Fusion Cloud Tables

  • by Yogesh Pachpute
  • Posted on March 22, 2019March 25, 2019
  • Oracle Fusion Technical

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 […]

Read More

How to view ESS Jobs Submitted by other users

  • by Yogesh Pachpute
  • Posted on March 14, 2019January 13, 2023
  • Oracle Cloud Fusion Financial

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 […]

Read More

What is the difference between ERP Integration Service and Financial Utilities Service?

  • by Yogesh Pachpute
  • Posted on March 6, 2019March 7, 2019
  • Oracle Fusion Technical

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 […]

Read More

Implementation User Creation, Roles and Privileges

  • by Yogesh Pachpute
  • Posted on November 27, 2018
  • Oracle Cloud Fusion Financial

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 […]

Read More

AR Transaction to SLA Link

  • by Yogesh Pachpute
  • Posted on October 23, 2017February 2, 2022
  • Oracle Fusion Technical

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 […]

Read More

AR Adjustments to SLA Link R12

  • by Yogesh Pachpute
  • Posted on October 23, 2017February 2, 2022
  • Oracle Fusion Technical

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 […]

Read More

Transactions with Credit Applied and SLA Link

  • by Yogesh Pachpute
  • Posted on October 23, 2017February 2, 2022
  • Oracle Fusion Technical

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 […]

Read More

AR Receipts to SLA Link R12

  • by Yogesh Pachpute
  • Posted on October 17, 2017February 2, 2022
  • Oracle Fusion Technical

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 […]

Read More

AR Miscellaneous Receipt to SLA Link R12

  • by Yogesh Pachpute
  • Posted on October 17, 2017February 2, 2022
  • Oracle Fusion Technical

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 […]

Read More

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (25)
  • GRC (6)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Cutover Tasks (1)
  • Oracle Cloud Fusion Financial (12)
  • Oracle Cloud Security (2)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (10)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (2)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (17)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • RMCS (1)
  • SubLedger Accounting (26)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Calendar

Calendar

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 35 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar