Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Uncategorized

End Date Responsibility from Oracle for List of Users

  • by Yogesh Pachpute
  • Posted on August 14, 2017August 14, 2017
  • Uncategorized

First create a temp table to hold user responsibilities to be inactivated. 1 2 3 4 CREATE TABLE xxcb_user_resp ( user_name VARCHAR2(240), resp_name VARCHAR2(240) ) Then insert record into temp tables, you may prepare these […]

Read More

How to Alter Database Sequence or How to increment or decrements sequence.

  • by Yogesh Pachpute
  • Posted on February 23, 2017
  • Oracle Database

How to Alter Database Sequence or How to increment or decrements sequence. select * from all_sequences where sequence_name like ‘RA_TRX_NUMBER%’; SELECT last_number FROM all_sequences WHERE sequence_name = ‘RA_TRX_NUMBER_N1_81_S’; SELECT last_number FROM all_sequences WHERE sequence_name = […]

Read More

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Fixed Asset (23)
  • General Ledger (19)
  • GRC (5)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Fusion Financial (11)
  • Oracle Database (2)
  • Oracle Fusion HCM (9)
  • Oracle Fusion HCM Technical (4)
  • Oracle Fusion Technical (9)
  • Oracle Installations (3)
  • Oracle Inventory (1)
  • Oracle SQL (4)
  • Order Management (1)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (16)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • SubLedger Accounting (25)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 17 other followers

Calendar

Calendar

March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Apr    
Blog at WordPress.com.