SELECT spell_MONEY(100000) from dual;
Tuesday, 28 June 2016
Wednesday, 1 June 2016
Accounting Periods Open/Close in Oracle Apps
Accounting Periods for Responsibility wise Navigation
Purchasing:-
Financials->Accounting->open and Close Periods
Inventory:-
Change Organization
Accounting Close Cycle ->Inventory Accounting Periods
Receiving:-
Control -> Accounting -> Open/Close Periods
Payables Manager
Setup -> Calendar -> Accounting -> Periods
General Ledger
Setup -> Open/Close
Purchasing:-
Financials->Accounting->open and Close Periods
Inventory:-
Change Organization
Accounting Close Cycle ->Inventory Accounting Periods
Receiving:-
Control -> Accounting -> Open/Close Periods
Payables Manager
Setup -> Calendar -> Accounting -> Periods
General Ledger
Setup -> Open/Close
Subscribe to:
Posts (Atom)
Script to update salespersons customer site wise in oracle apps R12
SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...
-
I faced some issues when I query the below table data is not fetching in my query: SELECT * FROM hr_operating_units SELECT * FROM MTL_CAT...
-
For this error need to Check RTF template there should be tags are not correctly and if you are developing new RTF latest version. Just se...
-
select * from all_objects where object_name like 'GME%BATCH%' and object_type = 'TABLE' --------------------------------...