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 = […]
Use following query to find the accounting package is being used 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 […]
Void: We’ll take the easiest one first “Void”. This of course means that the check is no longer valid and will not be going through your bank. Unreconciled: The next one is Unreconciled. This […]
Issue: The payments are made against the invoices in the payment manager screen. These payments have been cleared but the payment status is shown as reconciled. Now I want to void the payment but cannot […]
Issue: Payment is not getting accounted or payment is not posting to GL. Analysis: Query the Payment, then navigate to Tools à View Accounting Events à Check the status of Event_Status on accounting event page, […]
Requirement: Requirement is to identify Fixed Asset and Payables transaction related Asset Clearing Account coming into GL. This is to make the reconciliation of asset clearing account easy. Solution: Build BI Publisher report using following script […]
As per Oracle BI Publisher and EBS R12.1.3 certification matrix following are the compatibility of BI Publisher with EBS, Windows and Microsoft office. a) BI Publisher Desktop: The EBS 12.1.3 has the embedded BIP version […]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 SELECT code.concatenated_segments, period1.begin_balance_dr […]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 […]
Enterprise Resource Planning and Integrations BlogSpot 