Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Oracle Fusion Technical

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, 2019March 22, 2019
  • 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. Reference: Doc ID: 1467664.1

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)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (22)
  • GRC (5)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Fusion Financial (8)
  • Oracle Database (2)
  • Oracle Fusion HCM (9)
  • Oracle Fusion HCM Technical (4)
  • Oracle Fusion Technical (9)
  • 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 (25)
  • 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 31 other followers

Calendar

Calendar

June 2022
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« May    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 31 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