How to Deletion of Journal entry from Oracle ?
To Modify a journal batch that is frozen, follow this procedure: a). Setup > Journal > Sources b). Query the Journal Source c). Uncheck the Freeze Journals box and save…
Read MoreBILL CODE MAPPING IN ORACLE APPS R12
Step 1: Navigation: US AR SetupUser à Iron Source Bill Code MappingàEnter the Source->Operating Unit->Bill Code-> Modifiy the Code Combination-> Save
Read Morehow to define currency in oracle r12
To define a new currency: Go to GL Responsibility Navigate to the Currencies window. Setup >> Currencies >>Define
Read MoreOracle data fix remove unposted receipts and Full Merge events
Oracle data fix remove unposted receipts and Full Merge events We have follow the below script. Step:1 Create back up table Create table scratch.AR_RECEIPTS_BACKUP_MAY201 as select * from…
Read MoreDOCUMENT 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 MoreHow 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 MoreHow to add FA Locations In Oracle R12
Navigation >> FA responsibility >> assert >> Location add location and Save.
Read MoreData 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 MoreHow 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 MoreHow 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