ERPstuff - Oracle EBS Community

hello, I need to change a distribution charge account for an IN Process PO; from the default account of the Master Inventory organaization. If I have to do it from the backend, do I need to update another table besides po_distributions_all, and do I need to change any other column besides CODE_COMBI...

hello: I want to redecribe the problem below,please advise upon: We have a PO (108) that was partially matched to an invoice in an organization to it's chart of accounts. The PO was moved to a new organization according to requirements of new set of books and new charts of accounts to be created. A ...

hello, We have a PO 108 that was partially matched to an invoice in an organization to it's chart of accounts. The PO was moved to a new organization according to requirements of new set of books and new charts of accounts to be created. A new invoice was created in the new set of books and matched ...

helo,

is there anyway we can combine two bank statements with same account number,and two bank names in one statment to reconcile?

Hello, I'm trying to load a bank statement to the application by defining a new testing template and populating it with the BAI2 template. I have redefined the testing template with sample lines information. I ftp the dat file as ASCII to the server Bank Statement Loader program results in the follo...

Hello,

I 'm planning to take Oracle PL/SQL Developer Certified Associate exams:

Introduction to Oracle: SQL and PL/SQL-1Z0-001
and Program with PL/SQL - 1Z0-147

How should I prepare myself for these two exams?

Please note that I had not taken any oracle courses before.

Hello, Please read the following issue and advise on a solution. PO 381: column "segment1" in table "po_headers_all" is an approved purchase order of 9 lines,with po header id 797, in a foreign currency of the reporting set of books of the company.It has a record with revision 1 ...

For the answer I have followed please folow the link:

http://forums.oracle.com/forums/thread. ... 2&tstart=1

hello, Now I do have the following two queries that i would like to join together. select INVENTORY_ITEM_ID, sum(CASE WHEN UPPER(SUBINVENTORY_CODE) = 'MWAREHOUSE' THEN TRANSACTION_QUANTITY ELSE Null END) as "MAINWAREHOUSE QTY", sum(CASE WHEN UPPER(SUBINVENTORY_CODE) <> 'MWAREHOUSE' THEN TR...

Thank you.. I found the following and it worked perfectly: select INVENTORY_ITEM_ID ,sum(DECODE(UPPER(SUBINVENTORY_CODE),'MWAREHOUSE',TRANSACTION_QUANTITY)) as "MAINWAREHOUSE QTY" ,sum(DECODE(UPPER(SUBINVENTORY_CODE),'MWAREHOUSE',NULL, TRANSACTION_QUANTITY)) as "Business Centres QTY&q...

Thank you.. I found the following and it worked perfectly: select INVENTORY_ITEM_ID ,sum(DECODE(UPPER(SUBINVENTORY_CODE),'MWAREHOUSE',TRANSACTION_QUANTITY)) as "MAINWAREHOUSE QTY" ,sum(DECODE(UPPER(SUBINVENTORY_CODE),'MWAREHOUSE',NULL, TRANSACTION_QUANTITY)) as "Business Centres QTY&q...

Hello, I have two queries from the table "mtl_onhand_quantities", that i need to represnt in the same report. Each query represents the same column but with different conditions. The first query: (select INVENTORY_ITEM_ID,sum (TRANSACTION_QUANTITY) as "MAINWAREHOUSE QTY" from mtl...

Hello, I have two queries from the table "mtl_onhand_quantities", that i need to represnt in the same report. Each query represents the same column but with different conditions. The first query: (select INVENTORY_ITEM_ID,sum (TRANSACTION_QUANTITY) as "MAINWAREHOUSE QTY" from mtl...

More Info: We have only one operating unit that we would like to implement the internal requistions process within it's Organizational Structure (value chain, sections, etc.). is that possible? I have started to follow the metalink note: 406312.1 but i could not pass the "organization assignmen...

Hello, In the Inventory module in oracle applications 11.5.10, a user complained that the customized report does not bring out the recently issued transactions. I have found that these records have the fields: costed_flag = 'N' and request_id = 0 in mtl_material_transactions table. I have launched t...