Posts by Chandra Sekhar

DOCUMENT SEQUENCE CREATION IN RECEIVABLES

Enable Sequential Numbering Profile Option The profile option Sequential Numbering must be enabled in order to use the Document Sequence feature. This can be set at the site, application or responsibility level. Valid…

Read More

How to Create New Responsibility In Oracle apps R12 ?

Navigation: System Administrator ? Security ? Responsibility ? Define   Enter the details   Responsibility Name: IM CO AP Period End Application: Payables Responibility_key: IM_CO_AP_PERIOD_END Description: IM CO AP Period…

Read More

How to add FA Locations In Oracle R12

Navigation >> FA responsibility >> assert >> Location add location and Save.

Read More

Data Fix -Delete records – Customer Interface Table

Execute the below scripts for Backup Table Step1:- “CREATE TABLE scratch.RA_CUST_INT_INC0054156 as select * from apps.RA_CUSTOMERS_INTERFACE_ALL where org_id =****; / CREATE TABLE scratch.RA_CUST_PRO_INC0054156 as select * from apps.RA_CUSTOMER_PROFILES_INT_ALL where org_id=****;…

Read More

How to Update the Employee Details in Oracle apps R12 ?

Updating the Employee Details/Location/Address   Responsibility: HRMS Manager Navigation:Personnel->employees->query with employee last name Step1: Update the Manager   Step 2: Click on more and then click on assignments Click on…

Read More

How to add Cross validation Rule In GL ?

Navigation -> GL –> Setup -> Financials -> Flexfields -> Key -> Rules Search  Application Names. Query the CVR Name Enter the Code Combination values. Click on Save.   Thanks!…

Read More

How to add security Rules In GL ?

Define Security Rules: Navigation: General Ledger –> Setup –> Financial –> Flexfields –> Key –> Security –> Define. To define security rules: 1. Navigate to Define Security Rules window. 2.…

Read More

How to give the approval limits by user in AR

How to give the approval limits by user in Increase decrease in AR Navigation :-  AR Responsibility >>> Transaction>>> approval limits… mandatory parameters: User name >>> Document type >>> Source…

Read More

HOW TO ADD UNAPPLIED RECEIPTS REASON CODES TO BE ADDED SETUP IN ORACLE APPS

To achieve this we need to follow the below steps: Login with AR SuperUser Navigation: Collections>>Account Details Click on Account Details . One New Window will Display & Give the…

Read More

AP Payment status showing unprocessed in oracle apps

AP Payment status showing unprocessed in oracle apps   1>>> Check account status unprocessed ,it showing period exception reports   2>>> Check invoices status is accounted or not. 3>>> Check…

Read More