Perl Script for SFTP
Following script I have use for SFTP with Oracle R12, this needs to be modified for General Use. I have used this script for following 2 purposes. a) AR: Getting Lockbox file from Chase Bank […]
Useful Fusion Cloud Tables
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 […]
How to view ESS Jobs Submitted by other users
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
What is the difference between ERP Integration Service and Financial Utilities Service?
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, 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 […]
Which are Fusion Business Unit & EBS Operating Unit (BU or OU) specific modules?
Which are Fusion Business Unit & EBS Operating Unit (BU or OU) specific modules? AP: Accounts Payables AR: Accounts Receivables PO: Purchasing OM: Order Management PC: Project Costing PB: Project Billing
GL Flexfield Qualifiers in R12
Flexfield Qualifier is “which segment qualifies for which attribute“. Each Segment can have one of the following Qualifying attributes attached to it. Some of them are mandatory others are optional. Cost Center: Usually assigned to Department Segment. This qualifying segment is used by Oracle Assets. Natural Account: This […]
Status code and Phase code in fnd_concurrent_requests
Status code and Phase code in fnd_concurrent_requests We always keep getting confused about the meanings of status_code and phase_code columns in fnd_concurrent_requests table. Here is the brief descriptions of statuses columns in the table. Table […]
Accounting In Fixed Assets
Brief Overview of Fixed Asset Accounting Depreciation Additions and Capitalizations Adjustments Transfers and Reclassifications Revaluations Retirements and Reinstatements Tax Accumulated Depreciation Adjustments A. Journal Entries for Depreciation When you run depreciation, Oracle Assets creates journal […]
How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger
How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger? For transactions like Additions, Adjustments, and Retirements etc. the mapping is: XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = FA_ADJUSTMENTS.TRANSACTION_HEADER_ID XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = FA_ADJUSTMENTS.ADJUSTMENT_LINE_ID For Depreciation event transaction rows: XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_CHAR_4 = […]
