I. Create Accounting Program:
The Create Accounting program processes eligible accounting events to create subledger journal entries. To create the subledger journal entries, the Create Accounting program applies application accounting definitions that are created in the Accounting Methods Builder (AMB).
The Create Accounting program:
•Validates and creates subledger journal entries
•Optionally transfers the journal entries to GL
•Optionally posts the journal entries in GL
I promised to post the URL to the landing page for the Developer Days conferences, so here it is!
Check it out and sign-up today! And if you happen to know of a user group that is local to one of the dates feel free to pass the information on to them so they can share it with the rest of the members in the group.
Partition is made over dept_no and ordered by salary for both rank and dense_rank. They both make the same job except the numeric ranking. The same number is assigned for records with the same order value in both of them. At dense_rank, the numeric assignment is made sequentially for next row. But in rank, it is not [...]
there are not so many stuff about advanced queues for beginner level. this example may help you to figure out.. -- to create queue, some grants are given to our user GRANT "AQ_ADMINISTRATOR_ROLE" TO YTS; GRANT "AQ_USER_ROLE" TO YTS; GRANT EXECUTE ON SYS.DBMS_AQ TO YTS; -- queue table is created BEGIN SYS.DBMS_AQADM.CREATE_QUEUE_TABLE ( QUEUE_TABLE => [...]
this is a small hint to get a guick EXPLAIN PLAN when your ambulance button is not working at TOAD and you have limited time EXPLAIN PLAN FOR SELECT * from something; set pagesize 25 set linesize 121 SELECT * FROM TABLE(dbms_xplan.display); just run this as script.. Tagged: Oracle, pl/sql, [...]
It has been more than half a year since we've migrated from Oracle Jinitiator to Sun Java JRE Plug-in (Java 6 update 5) in our Oracle Applications (EBS) system, and I must say, I'm not satisfied yet.
Credit Card Chargeback:
A credit card chargeback takes place when a credit card holder disputes a charge with the credit card company (e.g. VISA) and the credit card company issues a chargeback to the customer for the disputed amount and notifies the vendor that they have issued a chargeback to the customer.
A cardholder can request a charge back for many reasons including, but not limited to:
•Charges for undelivered goods
Balance Forward Billing in 12i:
Balance Forward Billing replaces Consolidated Billing feature with enhancements to bill creation and presentation.
-Billing cycles are no longer just monthly. Easily create daily, weekly, monthly, bi-monthly, quarterly, and annual billings
-Bill on specific days of the month. User can not only specify the day of the month for the billing date, or even multiple days like “every 15th and last day of month”. User can also elect to bill on a specific day of the week, such as every Friday.
Self-Assed Tax :
Self Assessed tax differs from regular taxes in one way: as a purchaser, you are responsible for reporting and paying the tax and the supplier is not.
This was also known as USE TAX in previous releases.
For example: You receive an invoice for $1000 which is due to be paid to the supplier. Tax A for 10% was not charged on the invoice however, as the purchaser, you recognize that you are responsible to pay tax A. You would self-assess Tax A for the $100 and include it in your filings to the corresponding tax authority.