Get Org id from Responsibility Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.hr_organization_units hou, apps.fnd_profile_options_vl fpo, apps.fnd_profile_option_values fpov, apps.fnd_responsibility_vl frv WHERE […]
Receivables Important Concurrent Programs for Posting in R12 •Create Accounting •Submit Accounting •Transfer Journal Entries to General Ledger •Unposted Items Report •Revenue Recognition •Subledger Period Close Exception Report Create Accounting a) Invoice distribution lines not […]
Goal: If an expense report containing credit card transactions is approved and imported, then the associated invoice is deleted in Payables, are the credit card transactions then released for use with a new expense report […]
Goal: After an expense report with credit card transactions has been cancelled in Accounts Payable the expense report correctly shows a status of Cancelled, however, the credit card transactions on the expense report are not […]
Goal : A credit card related expense transaction was exported to AP successfully however the user noticed an anomly so they decided to cancel the invoice, purge data and retry to import the credit card […]
To enter an Expense report for an employee, the employee has to be Active. The expense code looks at the Hire Date and the Actual Termination Date to determine if an employee is Active. The […]
Rebuild AP Trial Balance in R12 To rebuild xla_trial_balances table or create a new report definition. For better performance of Data Manager run, increase the number of workers to 16,32 or 64 Navigate : Subledger […]
How to reconcile AP Trial Balance with Payable Transactions for a given period Get the output of the following for account and period where the difference was observed (In Detail); Now run following reports within […]
Before getting into the transactions, let’s see what are Debit Memos and Credit Memos. In Oracle Payables both of them are used to reduce the invoice amount. This reduction can be of any reason and […]
Oracle Cloud HCM Security Overview Data Roles: Data role is combination of Function Security and Data Security. In other words it is combination of workers job and the data instances that user with this role need […]
Enterprise Resource Planning and Integrations BlogSpot 