Learning Oracle Cloud

 

Hi Team 

            There are 5 ways to learn oracle cloud free. you have to plan and motivate your self to study oracle cloud , there are two types of cloud positions in market, Oracle cloud technical and oracle cloud Functional.

               First way

                             Login https://support.oracle.com/portal/ and check tab Knowledge 

                here you can get lot of documentation

              2nd Way 

•     learn.oracle.com
•     https://education.oracle.com/learning-explorer#startLearning

              3rd ways 

                             https://cloudcustomerconnect.oracle.com/

               4th ways

                           doc.oracle.com

                            partner.oracle.com

                           demo.oracle.com

                            ilearning.oracle.com

                                

Oracle Golden Tax : Integrating Oracle EBS with China's Golden Tax System

  

                         Oracle Golden Tax was introduced in  Oracle Apps R12 so it is not available to prior e-business suites. Golden Tax Adaptor helps transfer information from Account Receivables into Oracle Golden Tax and send it to Golden Tax system.

                          In China there are 2 types of credit memo, Special VAT credit Memo and other one called common VAT (Value added Tax ) credit memo,  To issue a Special VAT credit memo, you need to first fill application form and get approval from tax bureau. The 16 digit number on form needs to be put into description in golden tax Adaptor, The remaining process as handle in AR invoices.

                        withing the Golden Tax system you need to maintain bank name, bank branch name and bank account number for your customers , these information should keep in Chinese

 Golden Tax System is stand alone system is used to create and print customer vat invoices whenever you sell products or services to Chinese customers.

Vat Invoice Type  can map with AR transaction types while configuring Golden Tax Adaptor .

Golden Tax System (ASINO) requires Customer name, address,tax player id, bank information,invoice reviewer's name and collector's name apart from this we also need to setup the invoice amount limit, number of limit,etc in oracle system 

Deposit Golden Tax Invoice  : there is not any VAT involved, so there is no VAT with Golden system.In oracle Financials AR you can define transaction types which will interface to the  golden tax System.

you can define custom transfer rules , The rules helps to prevent unwanted AR transaction types transfer into golden tax modules. 

Programs used in golden Tax

    Receivables Transfer to Golden Tax Adaptor    

•   Golden Tax Invoice Purge -- used to purge golden Tax Invoices
•   Golden Tax Invoice Mapping Report
• 
  

Business Email : Situation Sentences

 

   Hello Friends,

                         In last session, we  had been talked about e-mail format,  We are discussing about email sentences with respective situation.

• 1.  Need send clarification mail
• 2.  Need send acknowledge mail
• 3.  Need send a attachment
• 4.  Provide answer on questions
• 5.  Asking confirmation or request to check
• 6.  Asking any help required
• 7.  Apologies for delay
• 8.  Avoid miscommunication
• 9.  Refer a meeting discussion

                   

Oracle WEBADI : Registration Web-adi Table

   Create table script 

     CREATE TABLE BNE.XXST_GOLD_IMPORT_INT_BNE_T

(

  OPERATING_UNIT        VARCHAR2(100),

  SOURCE                VARCHAR2(100),

  INVOICE_NUM           VARCHAR2(200),

  INVOICE_LINE_NUM      VARCHAR2(10),

  CURRENCY              VARCHAR2(20),

BILL_TO_CUSTOMER_NAME VARCHAR2(1000),

  VAT_CODE              VARCHAR2(100),

  VAT_NUMBER            VARCHAR2(100),

  VAT_DATE              DATE,

  CREATION_DATE DATE,

  USER_NAME VARCHAR2(100),

  RESPO_NAME VARCHAR2(100),

  STATUS VARCHAR2(5)

)

   ---Check Table name in Fnd_Tables 

          select * from fnd_tables where table_name='XXST_GOLD_IMPORT_INT_BNE_T';

   ---- Delete table from fnd_tables

       EXEC AD_DD.delete_table('BNE','XXST_GOLD_IMPORT_INT_BNE_T')

   ---Register Table name 

   EXEC AD_DD.REGISTER_TABLE ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','T');

   --- Register Column names in Table

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','OPERATING_UNIT',1,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','SOURCE',2,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','INVOICE_NUM',3,'VARCHAR2',200,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','INVOICE_LINE_NUM',4,'VARCHAR2',10,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','CURRENCY',5,'VARCHAR2',20,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','BILL_TO_CUSTOMER_NAME',6,'VARCHAR2',1000,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_CODE',7,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_NUMBER',8,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','VAT_DATE',9,'DATE',9,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','CREATION_DATE',10,'DATE',9,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','USER_NAME',11,'VARCHAR2',100,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','RESPO_NAME',12,'VARCHAR2',100 ,'Y','N');

EXEC AD_DD.REGISTER_COLUMN ('BNE','XXST_GOLD_IMPORT_INT_BNE_T','STATUS',13,'VARCHAR2',5 ,'Y','N');

            

Interview

Business Email : Email Format

 

                Business email is very important while you are working in professional world. Today I am going to talk about email format. how can we create very professional email. you always keep in mind, you have need to follow 3W rules and some other sequences while writing any business email. 

             Let us talk about 3W  rule what is 3W rule, i am going break this 3w rule here

•  Who    --- whom you send email
• what action -- what action are you taking while send mail
• when   -- when are you come up with result, you have need to share certain deadline with receiver.

           what should common format follow while sending any type of professional email

          I am sharing exact sequences here

•     Friendly open
•     Reason for your mail
•     Attachment
•     Offering help
•     Closing line

Few rules you always need to follow 

1- Always re-read your email before send mail

2-     

Sample e-mail

 Hello Linda,
I hope you are doing well                --- friendly open

I am writing  to you with regards to reporting issue, As you requested , I have updated changes in report,                                                                                                      --Reason for your mail
I have enclosed attachment with my comments.-                                  -- attachment
If you have any further questions, Please let me know.  -- offering help
Looking forward you suggestion or feedback on report 

====================================================================

             

 

Business English: Wh Questions

 

    

question word	function	Business English Sentences
what	asking for information about something	What is your name? What is current project status?
	asking for repetition or confirmation	What? I can't hear you. You did what?
what...for	asking for a reason, asking why	What did you do that for? What did you do to fix this issue?
when	asking about time	When did he leave? When are you plan migrate the change into prod?
where	asking in or at what place or position	Where do they live? Where are store project documents?
which	asking about choice	Which colour do you want? Which type project do you want to work?
who	asking what or which person or people (subject)	Who opened the door? Who has made change for this invoice?
whom	asking what or which person or people (object)	Whom did you see?
whose	asking about ownership	Whose are these keys? Whose turn is it?
why	asking for reason, asking what...for	Why do you say that? Why are you make change in test instances?
why don't	making a suggestion	Why don't I help you? Why don’t work with your teammate?
how	asking about manner	How does this work? How does this work?
	asking about condition or quality	How was your exam?
how + adj/adv	asking about extent or degree	see examples below
how far	distance	How far is Pattaya from Bangkok?
how long	length (time or space)	How long will it take? How long will it take time to execute this program?
how many	quantity (countable)	How many cars are there? How many
how much	quantity (uncountable)	How much money do you have? How much ticket do you have now?
how old	age	How old are you?
how come (informal)	asking for reason, asking why	How come I can't see her? How come I can’t see this invoice in instance?