Fusion

Create accounting calendars in GL fusion.

Accounting Calendar Options Define an accounting calendar to create your accounting year and the periods it contains. Specify common calendar options that the application uses to automatically generate a calendar…

Read More

[Security:090295]caught unexpected exception, No such object in Weblogic Remote managed Server.

Problem: <[Security:090295]caught unexpected exception, No such object> <[Security:090303]Authentication Failed: User weblogic weblogic.security.providers.authentication.LDAPAtnDelegateException: [Security:090295]caught unexpected exception, No such object> java.security.PrivilegedActionException: javax.security.auth.login.FailedLoginException: [Security:090938]Authentication failure: The specified user failed to log in. weblogic.security.providers.authentication.LDAPAtnDelegateException:…

Read More

SQL Query to retrieve User Roles – Fusion Applications

Query: SELECT pu.username,prdt.role_id, prdt.role_name, prd.role_common_name FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd WHERE pu.user_id = pur.user_id AND pu.username = <:P_USERNAME> AND prdt.role_id = pur.role_id AND prdt.role_id = prd.role_id…

Read More

Query to get Organization detail in Fusion

Overview : Below query to give the organization information in Fusion   Query: SELECT hra.organization_id as bu_id ,hro.name organization_name ,hra.business_group_id, hro.* FROM   HR_ALL_ORGANIZATION_UNITS_F hra, HR_ORGANIZATION_UNITS_F_TL hro WHERE 1=1 hra.ORGANIZATION_ID =…

Read More

To create an Interest Invoice in Oracle Fusion:

To create an Interest Invoice in Oracle Fusion: Created automatically by payables, for the amount of interest calculated on the overdue amount of an original invoice, for the overdue period.…

Read More

To see the active servers count in weblogic

Steps: login to the weblogic console Go to Domain Structure Under Domain Structure Click on deployments Click on  monitoring tab Now you can able to see number of active server…

Read More

Create Journal on a Spreadsheet Fusion

Please make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounting Dashboard and…

Read More

System variable to get current language by default in Oracle Fusion BIP report

Objective : Sometimes having a requirement to build the BIP report to display records other than English (ex: Arabic, French, German etc).  In Order to build such a report, you…

Read More

Tax only invoice

TAX only invoice

Read More

Smart view in Fusion

smart-view-in-fussion

Read More